clickhouse - clickhouse 警告 - 希望它最终会作为合并的结果出现

Question

重新启动 clickhouse-server 后

在waring以下至少出现0.5s一次。

2020.11.23 18:14:56.962144 [ 366 ] {} <Warning> timeseries.changchun (ReplicatedMergeTreePartCheckThread): Checking part 20201115_42618_42636_1
2020.11.23 18:14:56.964055 [ 366 ] {} <Warning> timeseries.changchun (ReplicatedMergeTreePartCheckThread): Checking if anyone has a part covering 20201115_42618_42636_1.
2020.11.23 18:14:56.970166 [ 366 ] {} <Warning> timeseries.changchun (ReplicatedMergeTreePartCheckThread): Found parts with the same min block and with the same max block as the missing part 20201115_42618_42636_1. Hoping that it will eventually appear as a result of a merge.

并且 DistributeSend 总是大于 6。

我想知道有 6 个部分 clickhouse-server 想要发送到其他分片。

我的 clickhouse-server 的版本是 20.38。

我该如何解决这个警告？

还有一件事我的集群有 3 个分片，每个分片都有 1 个副本。

标签： clickhouse

Answer 1

DistributeSend 与第一个问题无关。检查 system.distribution_queue

关于第一个问题。检查 system.replication_queue https://github.com/ClickHouse/ClickHouse/issues/10368