PREQUEL-2025-0023
Clickhouse Keeper Network ErrorsHighImpact: 8/10Mitigation: 2/10
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