Skip to main content

PREQUEL-2025-0023

Clickhouse Keeper Network ErrorsHigh
Impact: 8/10
Mitigation: 2/10

PREQUEL-2025-0023View on GitHub

Description

Large ClickHouse queries can consume a significant amount of resources, triggering several NETWORK_ERROR or NO_REPLICA_HAS_PART errors.\n

Mitigation

Adjust the timeouts.\n\n```\n<yandex>\n <profiles>\n <default>\n <!-- Example bad timeout settings: -->\n <!-- connect_timeout: 10 -->\n <!-- connect_timeout_with_failover_ms: 1000 -->\n <!-- connect_timeout_with_failover_secure_ms: 1000 -->\n <!-- receive_timeout: 300 -->\n <!-- send_timeout: 300 -->\n <!-- tcp_keep_alive_timeout: 290 -->\n <!-- hedged_connection_timeout_ms: 50 -->\n\n <!-- Updated settings: -->\n <connect_timeout>100</connect_timeout>\n <connect_timeout_with_failover_ms>3000</connect_timeout_with_failover_ms>\n <connect_timeout_with_failover_secure_ms>3000</connect_timeout_with_failover_secure_ms>\n <receive_timeout>600</receive_timeout>\n <send_timeout>600</send_timeout>\n <tcp_keep_alive_timeout>600</tcp_keep_alive_timeout>\n <hedged_connection_timeout_ms>300</hedged_connection_timeout_ms>\n </default>\n </profiles>\n</yandex>\n```\n

References