1、 Problem description
After the Clickhouse is started, it can be accessed by itself. There is no problem, and it can also be accessed externally. However, check its error log and find that there are always errors
tail -f clickhouse-server/clickhouse-server.err.log
output:
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.
...
It doesn’t stop, so it’s embarrassing.
2. Problem-solving
After probing, the Clickhouse server may have been started twice before. Therefore, check the status file directly according to the log directory
cat /var/lib/clickhouse/status
ps -ef | grep clickhouse-server
Delete the corresponding clickhouse-server
kill -9 $pid
systemctl start clickhouse-server
Then, check the error log again, and it’s OK
tail -f clickhouse-server/clickhouse-server.err.log
Read More:
- [Solved] ClickHouse Start Error: Run under ‘sudo -u clickhouse‘
- [Solved] dbeaver Connect clickhouse Error: Unexpected driver error occurred while connecting to the database
- How to Solve Clickhouse restart error: Cannot obtain value of path from config file…
- DB::Exception: test: Authentication failed: [How to Solve]
- How to Solve ClickHouse Connect Error: Connection refuse
- [Solved] waterdrop Import hive to clickhouse Error: Too many partitions for single INSERT block (more than 100).
- How to Solve Pycharm SQL Union Error
- [Solved] Rabbitmq Server Error: unable to perform an operation on node ‘[email protected]‘. P
- [Solved] Fe node hangs up and restarts with an error sleepycat.je.locktimeoutexception: (JE 7.3.7) lock expired
- [Solved] zookeeper Startup Error: already running as process
- [Gradle is Stucked in Building Runing] log Error: Timeout waiting to lock journal cache
- [Solved] Rsync synchronization Error: @ERROR: Unknown module xxx
- Hbase Error: Regions In Transition [How to Solve]
- How to Solve Rabbitmq Error: Failed to start RabbitMQ broker
- [Solved] Zabbix Error: Cannot parse list of active checks
- [Solved] net core HTTP Error 500.31 – Failed to load ASP.NET Core runtime HTTP Error 500.30 – ASP.NET Core
- [Solved] Failed to load property source from location ‘classpath:/application.yml‘
- [Solved] Hadoop Start NameNode Error: ERROR: Cannot set priority of namenode process 2639
- [Solved] jedis Connect redis Error: connect timed out
- When installing zookeeper, you can view the process start, but the status display error: Error contacting service. It is probably not running