【clickhouse-server安装问题】

原创已于 2025-10-14 11:04:33 修改 · 110 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#clickhouse

于 2025-10-11 09:45:54 首次发布

clickhouse 专栏收录该内容

1 篇文章

订阅专栏

启动报错

 clickhouse-server --config-file=/etc/clickhouse-server/config.xml
 报错：
 <Error> Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.

 journalctl -xe -u clickhouse-server
 报错：
 Oct 14 02:57:10 153 systemd[1]: clickhouse-server.service: main process exited, code=exited, status=218/CAPABILITIES
 Oct 14 02:57:10 153 systemd[1]: Failed to start ClickHouse Server (analytic DBMS for big data).

解决方案：
表面是权限报错，先检查权限，其实有可能是centos某些内核版本不支持启动参数导致

vi /usr/lib/systemd/system/clickhouse-server.service

#把这两行注释掉
CapabilityBoundingSet=CAP_NET_ADMIN CAP_IPC_LOCK CAP_SYS_NICE CAP_NET_BIND_SERVICE
AmbientCapabilities=CAP_NET_ADMIN CAP_IPC_LOCK CAP_SYS_NICE CAP_NET_BIND_SERVICE CAP_SYS_RESOURCE