Help Center/
MapReduce Service/
Troubleshooting/
Using ClickHouse/
Failed to Re-create a Replicated Table After It Is Deleted from ClickHouse
Updated on 2025-08-19 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 will not remove the metadata in ZooKeeper immediately.
- The replicated table fails to be recreated due to the residual metadata on ZooKeeper.
Solution
- Wait for about 8 minutes until ZooKeeper automatically 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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot