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

• The ZooKeeper path set in the replicated table creation statement may be incorrect and does not start with a slash (/).
• There may be other exceptions in the clickhouse-server.log file but the exception "Cannot unlink file" may shield the actual error due to the ClickHouse service logic.

Solution

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