Help Center/ MapReduce Service/ Troubleshooting/ Using ClickHouse/ Failed to Create a ClickHouse Replicated Table
Updated on 2025-12-01 GMT+08:00
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
- Check whether the table creation statement is correct based on the table creation specifications.
- Run the table creation statements again.
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.
