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

  1. Wait for about 8 minutes until ZooKeeper automatically deletes the metadata of the replicated table, and try again.
  2. Run the drop table table_name SYNC or drop table table_name no delay statement to correct the service operation.