-
Notifications
You must be signed in to change notification settings - Fork 8.3k
AGAIN skip_unavailable_shards=1 makes 6 tries if a shard is unavailable #48728
Copy link
Copy link
Closed
Labels
Description
It is happening again.
22.8 and 23.3. are affected.
SELECT *
FROM cluster('test_unavailable_shard', system.one)
SETTINGS skip_unavailable_shards = 1, send_logs_level = 'trace'
Query id: d5a5dc35-c7b0-4688-80e9-94423e98ab9b
2023.04.12 19:03:04.669543 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Debug> executeQuery: (from [::1]:45680) select * from cluster('test_unavailable_shard', system.one) settings skip_unavailable_shards=1, send_logs_level='trace' (stage: Complete)
2023.04.12 19:03:04.688746 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> ContextAccess (default): Access granted: REMOTE ON *.*
2023.04.12 19:03:04.689149 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2023.04.12 19:03:04.689184 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2023.04.12 19:03:04.689230 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> InterpreterSelectQuery: Complete -> Complete
2023.04.12 19:03:04.689632 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
┌─dummy─┐
│ 0 │
└───────┘
2023.04.12 19:03:04.732904 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №1, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.732980 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
2023.04.12 19:03:04.775978 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №2, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.776054 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
2023.04.12 19:03:04.824794 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №3, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.824941 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
2023.04.12 19:03:04.885624 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №1, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.885753 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
2023.04.12 19:03:04.944493 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №2, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.944582 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Trace> Connection (localhost:1): Connecting. Database: (not specified). User: default
2023.04.12 19:03:04.995784 [ 18373 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Warning> HedgedConnectionsFactory: Connection failed at try №3, reason: Code: 210. DB::NetException: Connection refused (localhost:1). (NETWORK_ERROR) (version 23.3.1.2823 (official build))
2023.04.12 19:03:04.996346 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.326853 sec., 3.059479337806292 rows/sec., 3.06 B/sec.
2023.04.12 19:03:04.996466 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Debug> MemoryTracker: Peak memory usage (for query): 431.31 KiB.
2023.04.12 19:03:04.996477 [ 28138 ] {d5a5dc35-c7b0-4688-80e9-94423e98ab9b} <Debug> TCPHandler: Processed in 0.327207039 sec.
Reactions are currently unavailable