ck进程似乎被打乱了,表无法合并和连接,然后大量的关闭等待

2guxujil  于 2021-07-15  发布在  ClickHouse
关注(0)|答案(0)|浏览(289)

我有一个集群,由一个分布式节点和2个碎片4个副本组成。我将批量数据插入一个操作系统中,以大约8000~1.3亿行/秒的速度将不领先的副本插入到一个操作系统中。大约15分钟后,生产数据进程无法成功插入数据,错误日志显示太多部分,因为这个副本没有合并数据。同时,此碎片的领头副本合并数据成功。此副本的进度是活动的,但似乎被击中。clickhouse\u客户端无法登录,对副本的分发查询将超时,并且此副本有太多关闭的\u等待连接。
很难复制。我在过去的半年里只见过几次。你可以测试以很高的速度插入其中一个复制品。我使用的clickhouse服务器版本是20.1.6.30。
这些是我抓拍的截图。
1.图为零件过多错误
2.此图显示连接状态
第二天,我再次遇到这个问题,下面的日志显示,插入和合并都不工作了!

-rw-r----- 1 root root 1 Jun 2 14:12 format_version.txt
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79020_79020_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79021_79021_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79022_79022_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79023_79023_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79024_79024_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79025_79025_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79026_79026_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79027_79027_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79028_79028_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_insert_441968_79029_79029_0
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441966_0_2412_4
drwxr-x--- 2 root root 4096 Jun 2 16:10 tmp_merge_441966_13807_14060_3
drwxr-x--- 2 root root 4096 Jun 2 16:10 tmp_merge_441966_8504_8764_3
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441967_33439_33544_3
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441967_33714_33764_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_100_125_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_126_150_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_1729_1753_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_1805_1829_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_181_205_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_1830_1854_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_206_230_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4039_4063_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4069_4094_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4441_4464_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4465_4489_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4566_4590_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_4591_4615_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_531_555_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_556_580_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_6854_6878_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_6924_6947_2
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7083_7091_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7092_7098_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7099_7108_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7132_7141_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7151_7159_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7170_7177_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7178_7184_1
drwxr-x--- 2 root root 4096 Jun 2 16:13 tmp_merge_441968_7185_7191_1

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题