我要评论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
发表评论