改变数据存储目录导致启动失败

clickhouse 在改变默认存储路径后启动时会报一些权限错误。

Application: DB::ErrnoException: Could not calculate available disk space (statvfs), errno: 13, strerror: Permission denied

一般将所有的配置的目录所有权修改为 clickhouse 即可解决，或者将 clickhouse 用户加入 root 组，会自动修改所属的目录。

usermod -a -G root clickhouse

修改后再次启动

[root@ecs ~]# service clickhouse-server restart
Now there is no clickhouse-server process.
 chown -R clickhouse: '/var/run/clickhouse-server/'
Will run sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon
Waiting for server to start
Waiting for server to start
Server started

可以发现我们的 /var/run/clickhouse-server/ 目录可能之前权限有问题