Skip to content

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

@danishhah

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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions