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/ 目录可能之前权限有问题
Comment