clickhouse处理readonly报错

最新推荐文章于 2024-08-15 19:35:14 发布

不吃饭的猪

最新推荐文章于 2024-08-15 19:35:14 发布

阅读量635

点赞数 1

文章标签： clickhouse

本文链接：https://blog.csdn.net/weixin_51473488/article/details/140670681

版权

1，clickhouse执行

SYSTEM RESTORE REPLICA db_com.dwd_com_t_judge_result_local;

SYSTEM RESTORE REPLICA db_com.dwd_com_t_judge_result_local

Query id: 70669be0-eef8-41da-b761-4980ce48ece2

0 rows in set. Elapsed: 0.001 sec.

Received exception from server (version 23.3.1):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Replica path is present at /clickhouse/tables/3/db_com/dwd_com_t_judge_result/replicas/bigdata-30 - nothing to restore. If you are sure that metadata is lost and that replica path contains some garbage, then use SYSTEM DROP REPLICA query first… (BAD_ARGUMENTS)
解决方法，手动删除zk中的路径，重新执行修复readonly的几个步骤，中间删除zk路径的不执行
readonly参考以下方法
https://blog.csdn.net/weixin_51473488/article/details/133743119