我正在使用默认设置运行click house版本"20.6.4"。当我穿过原木时,我发现了大量的原木。
ServerErrorHandler: Code: 210, e.displayText() = DB::NetException: Connection reset by peer, while reading from socket
和
u003cWarningu003e ConnectionPoolWithFailover: Connection failed at try №1, reason: Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 172.16.*.*:9000 (172.16.*.*:9000) (version 20.6.3.28 (official build))","msg_id":"SERVER-1","namespace":"clickhouse.server","priority":6,"timestamp":"2020-09-21T00:01:23.623067Z","user_id":"","user_name":""}
我正在使用默认设置的go clickhouse客户端(没有更改任何超时(几乎每分钟插入一次数据(大约60-70k行(尽管看起来没有任何影响,但得到了很多这些是我的超时相关设置:
name value type
connect_timeout 10 SettingSeconds
connect_timeout_with_failover_ms 50 SettingMilliseconds
connect_timeout_with_failover_secure_ms 100 SettingMilliseconds
receive_timeout 300 SettingSeconds
send_timeout 300 SettingSeconds
tcp_keep_alive_timeout 0 SettingSeconds
idle_connection_timeout 3600 SettingUInt64
distributed_directory_monitor_sleep_time_ms 100 SettingMilliseconds
distributed_directory_monitor_max_sleep_time_ms 30000 SettingMilliseconds
insert_in_memory_parts_timeout 600000 SettingMilliseconds
replication_alter_columns_timeout 60 SettingUInt64
insert_quorum_timeout 600000 SettingMilliseconds
use_client_time_zone 0 SettingBool
insert_distributed_timeout 0 SettingUInt64
distributed_ddl_task_timeout 180 SettingInt64
stream_poll_timeout_ms 500 SettingMilliseconds
http_connection_timeout 1 SettingSeconds
http_send_timeout 1800 SettingSeconds
http_receive_timeout 1800 SettingSeconds
query_profiler_real_time_period_ns 1000000000 SettingUInt64
query_profiler_cpu_time_period_ns 1000000000 SettingUInt64
max_execution_time 0 SettingSeconds
timeout_overflow_mode throw SettingOverflowMode
timeout_before_checking_execution_speed 10 SettingSeconds
temporary_live_view_timeout 5 SettingSeconds
lock_acquire_timeout 120 SettingSeconds
mark_cache_min_lifetime 0 SettingUInt64
date_time_input_format basic SettingDateTimeInputFormat
Is there anything i can change to minimize these errrors??
从套接字读取时,对等方重置连接
该消息中的IP地址是什么?是CH服务器还是客户端?不过这确实是个错误。这只是意味着客户端已经离开,服务器并没有得到所有预期的数据。
这是两个不同的问题。
尝试时连接失败№1.connect_timeout_with_failover_ms 50
50ms<--检查副本之间的延迟(ping(。如果延迟>超过1毫秒,则需要增加connect_timeout_with_failover_ms
cat /etc/clickhouse-server/conf.d/user_substitutes.xml
<?xml version="1.0"?>
<yandex>
<profiles>
<default>
<connect_timeout_with_failover_ms>1000</connect_timeout_with_failover_ms>
<default>
</profiles>
</yandex>