Skip to content

Poco::Exception. Code: 1000, e.code() = 0, HTML Form Exception: Field value too long #627

Description

@danishhah

Hello, I get this error

Poco::Exception. Code: 1000, e.code() = 0, HTML Form Exception: Field value too long

when I try to pass a lot of IDs to my Clickhouse view. I have tried to increase the Clickhouse settings, specifically the http_max_field_value_size one, but that doesn't seem to do anything.

const result = await clickhouseClient.query({
      query,
      query_params: queryParams,
      format: 'JSONEachRow',
      clickhouse_settings: {
        http_max_field_value_size: '10485760',
        max_query_size: '10485760',
        http_max_request_param_data_size: '10485760',
        http_max_chunk_size: '10485760',
      },
    })

Can someone please advise? I have also tried increasing it on the DB level, by updating it for the user, using:

ALTER USER '<user_name>' SETTINGS http_max_field_value_size = 10485760;

But that doesn't do anything either.

Environment:

Clickhouse client version: "@clickhouse/client": "^1.11.2"
Clickhouse version: 25.12.1.1426

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions