如何查询Clickhouse的错误日志

一、需求

Clickhouse-常见错误Detaching broken part If it happened after update, it is likely because of backward incompability. You need to resolve this manually - 登峰造极境

二、技术实现

查询服务器状态

curl -I http://<server-ip>:8123/ping

如果返回200：Ok.则服务器正常。

方法一

tail -f -n 1000  /var/log/clickhouse-server/clickhouse-server.err.log

方法二

SELECT *
FROM system.errors
ORDER BY last_error_time DESC
LIMIT 10;