clickhouse启动及可能遇到的问题

操作系统：CentOS Linux release 7.7.1908 (Core)
clickhouse版本：21.9.4.35
安装软件：
clickhouse-server-21.9.4.35-2.noarch
clickhouse-client-21.9.4.35-2.noarch
clickhouse-common-static-21.9.4.35-2.x86_64
操作用户：ROOT

1、安装

# yum install yum-utils
# rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
# yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64
# yum install clickhouse-server clickhouse-client

2、启动

简单粗暴的修改文件所有者为root用户
# chown -R root:root /var/lib/clickhouse /var/log/clickhouse-server /etc/clickhouse-server /etc/clickhouse-client
启动clickhouse服务
# clickhouse-server --config-file=/etc/clickhouse-server/config.xml

3、可能遇到的问题

需要注意以下文件夹的所有者是否统一为clickhouse用户
/var/lib/clickhouse
/var/log/clickhouse-server
/etc/clickhouse-server
/etc/clickhouse-client
如果没有修改文件夹的所有者，执行启动命令# clickhouse-server --config-file=/etc/clickhouse-server/config.xml可能会遇到如下错误

Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under ‘sudo -u clickhouse’.

提示使用clickhouse用户启动
# sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml
执行后又报错

Couldn’t save preprocessed config to /var/lib/clickhouse/preprocessed_configs/config.xml: Access to file denied: /var/lib/clickhouse/preprocessed_configs/config.xml

此时修改以下几个文件夹用户为clickhouse

# chown -R root:root /var/lib/clickhouse /var/log/clickhouse-server /etc/clickhouse-server /etc/clickhouse-client

启动时依然报错
Application: DB::ErrnoException: Could not calculate available disk space (statvfs), errno: 13, strerror: Permission denied

然后添加clickhouse用户到root用户组重新启动即可
# usermod -a -G root clickhouse

参考

https://clickhouse.com/docs/zh/getting-started/install/
https://github.com/ClickHouse/ClickHouse/issues/7902