Ubuntu下ClickHouse启动失败：端口未监听且连接被拒绝

问题现象 #

• 执行sudo systemctl start clickhouse-server无任何反馈
• 数据库未监听默认端口，执行以下命令无结果返回：

  sudo netstat -tulpn | grep clickhouse
  sudo netstat -tulpn | grep 8123
  

• 使用clickhouse-client --password连接时报错：

  ClickHouse client version 22.8.4.7 (official build).
  Password for user (default): 
  Connecting to localhost:9000 as user default.
  Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
  

• 服务状态显示自动重启且退出码异常：

  clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
  Loaded: loaded (/lib/systemd/system/clickhouse-server.service; enabled; vendor preset: enabled)
  Active: activating (auto-restart) (Result: exit-code) since Wed 2022-09-07 ...
  Process: 10730 ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml (code=exited, status=233/RUNTIME_DIRECTORY)
  Main PID: 10730 (code=exited, status=233/RUNTIME_DIRECTORY)
  CPU: 90ms
  

• 错误日志核心提示：

  2022.09.07 11:42:23.694750 [ 21604 ] {} <Error> Application: DB::Exception: Caught Exception Code: 76. DB::ErrnoException: Cannot open file /var/lib/clickhouse/uuid, errno: 13, strerror: Permission denied. (CANNOT_OPEN_FILE) (version 22.8.4.7 (official build)) while writing the Server UUID file /var/lib/clickhouse/uuid
  

解决方案 #

1. 检查数据目录权限 #

执行命令查看/var/lib/clickhouse目录的所有者：

ls -ld /var/lib/clickhouse

正常情况下，该目录的所有者和组应为clickhouse:clickhouse。

2. 修复目录权限 #

如果权限不符，执行以下命令递归修改目录所有者：

sudo chown -R clickhouse:clickhouse /var/lib/clickhouse

3. 重启服务并验证 #

• 重启ClickHouse服务：

  sudo systemctl restart clickhouse-server
  

• 检查服务状态：

  sudo systemctl status clickhouse-server
  

  确认输出中显示active (running)。
• 验证端口监听：

  sudo netstat -tulpn | grep clickhouse
  

  应能看到8123（HTTP端口）和9000（TCP客户端端口）处于监听状态。

内容的提问来源于stack exchange，提问作者GTmember