ClickHouse / ClickHouse/clickhouse-js

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

Open
#627 1 comment 0 reactions 0 assignees View on GitHub
question
Dominant language
TypeScript
Stars
331
Forks
74
PR merge metrics
No merged PRs in 30d

Description

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 '' 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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.