v.23.4Improvement

Increase connect_timeout_with_failover_ms to 1000 ms

Increase default value for connect_timeout_with_failover_ms to 1000 ms (because of adding async connections in https://github.com/ClickHouse/ClickHouse/pull/47229) . Closes #5188. #49009 (Kruglov Pavel).
Increased the default value of connect_timeout_with_failover_ms to 1000 ms to accommodate asynchronous connections.

Why it matters

The change addresses the need for a longer connection timeout caused by the introduction of asynchronous connections. Increasing the timeout ensures more reliable connection attempts when failover is enabled, improving client stability and reducing premature connection failures.

How to use it

The new default timeout of 1000 ms is applied automatically. Users can override this setting by explicitly configuring the connect_timeout_with_failover_ms parameter in their client or server settings if a different timeout value is preferred.