阅读量:0
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
