Clickhouse 连接错误次数

william 收录于 Programming

2021-07-07 约 200 字预计阅读 1 分钟

警告

本文最后更新于 2021-07-07，文中内容可能已过时。

问题：

 1
 2
 3
 4
 5
 6
 7
 8
 9
10


>     DBI::dbSendQuery(conn, sql)
Error in select(conn@ptr, statement) :
DB::Exception: All attempts to get table structure failed. Log:
Code: 279, e.displayText() = DB::NetException: All connection tries failed. Log:
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))

解决方案参考：Inconsistent behaviour of Distributed table engine and remote table function when called with cluster and with list of addresses

1

SET connections_with_failover_max_tries = 5

Clickhouse 连接错误次数

相关内容