clickhouse "status=232/ADDRESS_FAMILIES" "code=exited, status=70" 问题

发布时间 2023-07-19 12:05:21作者: LiAnG24

clickhouse 21.2.4.6安装时的问题

232问题

[root@localhost liang]# sudo 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 三 2023-07-19 11:26:57 CST; 22s ago
  Process: 14021 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: 14021 (code=exited, status=232/ADDRESS_FAMILIES)

7月 19 11:26:57 localhost.localdomain systemd[1]: clickhouse-server.service: main process exited, code=exited, status=232/ADDRESS_FAMILIES
7月 19 11:26:57 localhost.localdomain systemd[1]: Unit clickhouse-server.service entered failed state.
7月 19 11:26:57 localhost.localdomain systemd[1]: clickhouse-server.service failed.

70问题

[root@localhost liang]# sudo 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 三 2023-07-19 11:30:12 CST; 6s ago
  Process: 14190 ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid (code=exited, status=70)
 Main PID: 14190 (code=exited, status=70)

7月 19 11:30:12 localhost.localdomain systemd[1]: clickhouse-server.service: main process exited, code=exited, status=70/n/a
7月 19 11:30:12 localhost.localdomain systemd[1]: Unit clickhouse-server.service entered failed state.
7月 19 11:30:12 localhost.localdomain systemd[1]: clickhouse-server.service failed.

232 似乎是日志问题,70是端口问题
博主也不太清楚,232后面跟了个address,但改了下日志权限就好了
查了一圈,网上的那几篇似乎不起作用,但通过gpt鼓捣出来了
232我是通过下面几个命令然后变成了70问题

ls -ld /var/lib/clickhouse/
ls -ld /var/log/clickhouse-server/
sudo chown -R clickhouse:clickhouse /var/lib/clickhouse/
sudo chown -R clickhouse:clickhouse /var/log/clickhouse-server/
sudo chmod 755 /var/lib/clickhouse/
sudo chmod 755 /var/log/clickhouse-server/
sudo systemctl restart clickhouse-server

然后再

vim /etc/clickhouse-server/config.xml

修改完是这样的

就是把 <listen_host>::</listen_host> 取消注释

sudo systemctl restart clickhouse-server
sudo systemctl status clickhouse-server

然后就能启动啦~