Do not continue retrying to connect to ZK if the query is killed or over limits

[Algunenano]

Changelog category (leave one):

• Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

• Do not continue retrying to connect to ZK if the query is killed or over limits

Documentation entry for user-facing changes

Closes #47983

Check with a restarting ZK (keeps resetting the session)

set max_execution_time=5
insert into bi_connector_log(start_datetime) Select now();

• Before: Code: 159. DB::Exception: Received from clickhouse-02:59000. DB::Exception: Timeout exceeded: elapsed 142.722363052 seconds, maximum: 5. (TIMEOUT_EXCEEDED)
• After: Code: 159. DB::Exception: Received from clickhouse-02:59000. DB::Exception: Timeout exceeded: elapsed 7.13354754 seconds, maximum: 5. (TIMEOUT_EXCEEDED)

[Algunenano]

Added an integration test and rebased with master to fix broken test (timezone issues)

[Algunenano]

• Integration tests (tsan) [4/6] -> Likely my fault. I assumed the ZK status/connection was reset per test but probably that's not the case.
• Stateless tests (tsan) [1/5] -> Lock order inversion: onCancel #47460

[SmitaRKulkarni]

Rest all LGTM

[Algunenano]

Stress test: #48151 (unrelated)
Everything else seems good

[SmitaRKulkarni]

@Algunenano Could you please resolve conflicts with master (src/Backups/BackupCoordinationRemote.cpp)

[SmitaRKulkarni]

Unrelated failure
Stateless tests (tsan) - 02187_async_inserts_all_formats - #47866