部署在 kurebetes 上的 clickhouse 有一个 pod 无法启动,错误日志如下,请问如何解决这个问题?
Waited job failed: Code: 695. DB::Exception: Load job 'load table system.text_log' failed: Code: 49. DB::Exception: Part 202506_1819518_1820707_778 intersects previous part 202506_1819518_1820705_781.
It is a bug or a result of manual intervention in the server or ZooKeeper data: Cannot attach table `system`.`text_log` from metadata file /var/lib/clickhouse/store/6a8/6a819848-0d15-4129-aa81-98480d152129/text_log.sql from query ATTACH TABLE system.text_log UUID '9ad5ee7a-75e7-4c9a-98a2-d55c6da55009'
目前找到的最相关的一个线索是 github issue 中的一个评论 :
Also, the issue might be caused by clickhouse-operator: https://github.com/Altinity/clickhouse-operator/blob/ca6113414e898b5b43f67a2fc77696f4e082f316/pkg/controller/chi/worker-chi-reconciler.go#L105
https://clickhouse.com/docs/knowledgebase/part_intersects_previous_part
– dudu 1周前https://github.com/ClickHouse/ClickHouse/issues/47879
– dudu 1周前