Clickhouse报错：DB::Exception: Cannot lock file /var/lib/clickhouse/status

最新推荐文章于 2024-10-23 11:53:54 发布

RayBreslin

最新推荐文章于 2024-10-23 11:53:54 发布

阅读量6.8k

点赞数 3

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/u010886217/article/details/121776631

版权

ClickHouse 专栏收录该内容

3 篇文章

订阅专栏

一、问题描述

clickhouse启动后，本身也可以访问没有问题，而且外部也可以访问，但是查看其error日志，发现一直有报错

tail -f clickhouse-server/clickhouse-server.err.log
结果：
2020.10.07 19:05:32.720350 [ 8150 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
2020.10.07 19:06:02.970577 [ 8217 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
2020.10.07 19:06:33.220827 [ 8632 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
2020.10.07 19:07:03.471225 [ 8706 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
2020.10.07 19:07:33.720339 [ 8880 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
...

一直不停止，所以这个很尬尴。

二、问题解决

经过探查，可能是因为之前有clickhouse-server启动2次导致，所以，直接依据日志目录，查看这个status文件

cat /var/lib/clickhouse/status
ps -ef | grep clickhouse-server
删除对应clickhouse-server
kill -9 $pid
systemctl start clickhouse-server

然后，重新查看错误日志，就ok了

tail -f clickhouse-server/clickhouse-server.err.log