Help Center/ MapReduce Service/ Troubleshooting/ Using ClickHouse/ Failed to Re-create a Replicated Table After It Is Deleted from ClickHouse
Updated on 2025-12-01 GMT+08:00
Failed to Re-create a Replicated Table After It Is Deleted from ClickHouse
Symptom
When a ClickHouse replicated table is deleted and then recreated, the error message "Existing table metadata in ZooKeeper" is displayed.
Cause Analysis
- Deleting a replicated table in ClickHouse does not immediately remove the metadata in ZooKeeper.
- There is residual metadata in ZooKeeper.
Solution
- Wait for about 8 minutes until ZooKeeper deletes the metadata of the replicated table, and try again.
- Run the drop table table_name SYNC or drop table table_name no delay statement to correct the service operation.
Parent topic: Using ClickHouse
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
