Failed to Create a ClickHouse Replicated Table

Symptom

The following error message is displayed during the ClickHouse replicated table creation:

Cannot unlink file /srv/BigData/data2/clickhouse/store/061*****/format_version.txt, errno: 2, strerror: No such file or directory

Cause Analysis

• Check whether the ZooKeeper path set in the replicated table creation statement starts with a slash (/).
• If not, check whether there are other exceptions in the clickhouse-server.log file because the exception "Cannot unlink file" may shield the actual error due to the ClickHouse service logic.

Solution

1. Check whether the table creation statements are correct based on the table creation specifications.
2. Run the table creation statements again.