Error when sending large string through clickhouse-js client: "Field value too long"

[calebeaires]

I'm encountering a persistent error when attempting to send large string data through the clickhouse-js client. Despite configuring various size limits in both the client settings and server configuration files, the error persists.

Error Message

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




Environment Details

• ClickHouse version: 25.4.1.2283 (official build)
• clickhouse-js client
• Operating system: macos

Steps to Reproduce

1. Connect to ClickHouse using the clickhouse-js client with the settings shown below
2. Attempt to insert/query with a large string value using the method exec
3. Receive the "Field value too long" error

Client Configuration

I've already tried increasing various size limits in the client settings:

const clickhouseSettings: ClickHouseSettings = {
    http_max_multipart_form_data_size: '10485760', // 10MB
    http_max_field_value_size: '10485760',         // 10MB
    max_query_size: '10485760',                    // 10MB
    allow_experimental_object_type: 1,
    alter_sync: '2',
    date_time_input_format: 'best_effort',
    enable_http_compression: 1,
    format_csv_allow_double_quotes: 1,
    format_csv_allow_single_quotes: 1,
    format_csv_null_representation: '',
    input_format_try_infer_datetimes: 1,
    join_use_nulls: 0,
    mutations_sync: '2',
    output_format_json_quote_64bit_integers: 0,
    s3_truncate_on_insert: 1,
    transform_null_in: 1,
    wait_end_of_query: 1
};

Server Configuration Changes
I've also modified the following server configuration files:
In config.xml and users.xml::

<max_http_post_field_size>10485760</max_http_post_field_size>

<max_query_size>10485760</max_query_size>

[luisvinicius09]

The flag http_max_field_value_size must be added in the user.d under the profile section - restart the clickhouse-server after changing.

<clickhouse>
        <profiles>
		<default>
                	<http_max_field_value_size>100000000</http_max_field_value_size>
			<max_query_size>2097152</max_query_size>
			<allow_experimental_json_type>1</allow_experimental_json_type>
                </default>
        </profiles>
</clickhouse>