The error message “DB::Exception: Cannot lock file /clickhouse/status

The error message “DB::Exception: Cannot lock file /data/clickhouse/data/clickhouse/status. Another server instance in the same directory is already running.” indicates that there is already another instance of ClickHouse running on the same directory that is trying to lock the same file.

ps aux | grep clickhouse-server

如果看到运行的程序，可以直接执行下面的命令停止服务

sudo systemctl stop clickhouse-server

检查 “/data/clickhouse/data/clickhouse/status” 文件权限， 确保ck有权限操作

ls -l /data/clickhouse/data/clickhouse/status

如果是权限错误，执行下面的操作

sudo chmod 666 /data/clickhouse/data/clickhouse/status

如果上面都不行， 可以删除status文件取重启CK

sudo rm /data/clickhouse/data/clickhouse/status
sudo systemctl start clickhouse-server

如果还不行，可以重新安装