使用
systemctl start clickhouse-server
启动失败，报错信息如下：
[root@hantest mysql]# systemctl status clickhouse-server
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since Wed 2021-06-30 10:03:22 CST; 2s ago
Process: 5711 ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid (code=exited, status=232/ADDRESS_FAMILIES)
Main PID: 5711 (code=exited, status=232/ADDRESS_FAMILIES)
Jun 30 10:03:22 hantest.com systemd[1]: clickhouse-server.service: main process exited, code=exited, status=232/ADDRESS_FAMILIES
Jun 30 10:03:22 hantest.com systemd[1]: Unit clickhouse-server.service entered failed state.
Jun 30 10:03:22 hantest.com systemd[1]: clickhouse-server.service failed.
解决：
journalctl -xe
Jun 30 10:03:21 hantest.com polkitd[751]: Unregistered Authentication Agent for unix-process:5673:185017 (system bus name :1.164, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en
Jun 30 10:03:22 hantest.com clickhouse-server[5711]: Processing configuration file '/etc/clickhouse-server/config.xml'.
Jun 30 10:03:22 hantest.com clickhouse-server[5711]: Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Jun 30 10:03:22 hantest.com clickhouse-server[5711]: Poco::Exception. Code: 1000, e.code() = 13, e.displayText() = Access to file denied: /var/log/clickhouse-server/clickhouse-server.log, Stack trace
注意这行报错：
e.displayText() = Access to file denied: /var/log/clickhouse-server/clickhouse-server.log, Stack trace
查看日志：
[root@hantest mysql]# cat /var/log/clickhouse-server/clickhouse-server.log
2021.06.30 09:28:20.685110 [ 2596 ] {} <Information> SentryWriter: Sending crash reports is disabled
2021.06.30 09:28:20.928173 [ 2596 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2021.06.30 09:28:21.153625 [ 2596 ] {} <Information> : Starting ClickHouse 21.6.4.26 with revision 54451, build id: 12B138DBA4B3F1480CE8AA18884EA895F9EAD439, PID 2596
2021.06.30 09:28:21.153735 [ 2596 ] {} <Information> Application: starting up
2021.06.30 09:28:21.153751 [ 2596 ] {} <Information> Application: OS Name = Linux, OS Version = 3.10.0-1160.el7.x86_64, OS Architecture = x86_64
2021.06.30 09:28:25.684603 [ 2596 ] {} <Information> Application: Calculated checksum of the binary: 26864E69BE34BA2FCCE2BD900CF631D4, integrity check passed.
2021.06.30 09:28:25.684733 [ 2596 ] {} <Trace> Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds.
2021.06.30 09:28:25.690613 [ 2596 ] {} <Trace> Application: The memory map of clickhouse executable has been mlock'ed, total 186.64 MiB
2021.06.30 09:28:25.755594 [ 2596 ] {} <Error> Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.
2021.06.30 09:28:25.782973 [ 2596 ] {} <Information> Application: shutting down
2021.06.30 09:28:25.782986 [ 2596 ] {} <Debug> Application: Uninitializing subsystem: Logging Subsystem
2021.06.30 09:28:25.783825 [ 2597 ] {} <Trace> BaseDaemon: Received signal -2
2021.06.30 09:28:25.783848 [ 2597 ] {} <Information> BaseDaemon: Stop SignalListener thread
使用命令：
[root@hantest mysql]# sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml
Processing configuration file '/etc/clickhouse-server/config.xml'.
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Poco::Exception. Code: 1000, e.code() = 13, e.displayText() = Access to file denied: /var/log/clickhouse-server/clickhouse-server.log, Stack trace (when copying this message, always include the lines below):
发现是log文件的权限错误。查看文件权限：
[root@hantest mysql]# ll /var/log/clickhouse-server/clickhouse-server.log
-rwxrwxrwx. 1 root root 1566 Jun 30 09:28 /var/log/clickhouse-server/clickhouse-server.log
查看服务的用户权限：
vim /usr/lib/systemd/system/clickhouse-server.service
[Unit]
Description=ClickHouse Server (analytic DBMS for big data)
Requires=network-online.target
After=network-online.target
[Service]
Type=simple
User=clickhouse
Group=clickhouse
更改权限：
[root@hantest mysql]# chown clickhouse:clickhouse /var/log/clickhouse-server/clickhouse-server.log
[root@hantest mysql]# chown clickhouse:clickhouse /var/log/clickhouse-server/clickhouse-server.err.log
