大数据
w_yq111
这个作者很懒,什么都没留下…
展开
-
clickhouse报错
Code: 49, e.displayText() = DB::Exception: Part 20211009_67706_67706_0 is covered by 20211009_67118_67714_12 but should be merged into 20211009_67706_67715_1. This shouldn’t happen often., Stack trace (when copying this message, always include the lines be原创 2021-10-13 16:56:51 · 1157 阅读 · 0 评论 -
ZooKeeper session has been expired
与Zookeeper连接丢失,Unknown status, Cannot allocate block number in ZooKeeper: , ZooKeeper session has been expired…问题描述 在执行SQL中如在遇到如下报错:↑ Progress: 157.94 million rows, 6.91 GB (92.63 thousand rows/s., 4.05 MB/s.) Received exception from server (version 19原创 2021-10-13 15:24:50 · 2556 阅读 · 0 评论 -
Clickhouse中的同时查询太多了(Too many simultaneous queries in clickhouse)
Clickhouse中的同时查询太多了(Too many simultaneous queries in clickhouse)解决方案一:1、适当扩大配置文件这个属性值,<max_concurrent_queries>100</max_concurrent_queries>解决方案二:1、减少插入频率解决方案三:1、不处理也可,一般会自动恢复正常,需要观察一段时间,根据实际情况来...原创 2021-10-12 18:18:45 · 1347 阅读 · 0 评论 -
clickhouse报错---Code: 252, e.displayText() = DB::Exception: Too many parts (311). Merges are processi
clickhouse报错—Code: 252, e.displayText() = DB::Exception: Too many parts (311). Merges are processing significantly slower than inserts, Stack trace (when copying this message, always include the lines below):解决方案一:1、 一般Too many parts (311) 小于350不用处理,观察一段原创 2021-10-12 18:24:25 · 3116 阅读 · 0 评论