After installing clickhouse using rpm packages ,we got an issue with starting of clickhouse.
Below are the steps we followed for installation:
Download all the required packages on one particular location for eg: /opt/clickhouse using below commands
# mkdir /opt/clickhouse
# cd /opt/clickhouse # wget http://repo.yandex.ru/clickhouse/rpm/stable/x86_64/clickhouse-common-static-18.12.17-2.x86_64.rpm #wget http://repo.yandex.ru/clickhouse/rpm/stable/x86_64/clickhouse-server-base-18.12.17-2.x86_64.rpm #wget http://repo.yandex.ru/clickhouse/rpm/stable/x86_64/clickhouse-server-common-18.12.17-2.noarch.rpm #wget http://repo.yandex.ru/clickhouse/rpm/stable/x86_64/clickhouse-server-18.12.17-2.noarch.rpm #wget http://repo.yandex.ru/clickhouse/rpm/stable/x86_64/clickhouse-client-18.12.17-2.noarch.rpm
Now the above 5 packages will be available in the given location. Then we have to install the packages one after the other in the below order with the following commands.
# rpm -ivh clickhouse-common-static-18.12.17-2.x86_64.rpm
# rpm -ivh clickhouse-server-base-18.12.17-2.x86_64.rpm
# rpm -ivh clickhouse-server-common-18.12.17-2.noarch.rpm
# rpm -ivh clickhouse-server-18.12.17-2.noarch.rpm
# rpm -ivh clickhouse-client-18.12.17-2.noarch.rpm
Below is the error message.
systemctl status clickhouse-server
clickhouse-server.service - ClickHouse Server (analytic DBMS for big data) Loaded: loaded (/etc/systemd/system/clickhouse-server.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Mon 2019-07-08 19:36:24 +08; 54min ago Process: 23939 ExecStart=/etc/init.d/clickhouse-server --config=/etc/clickhouse-server/config.xml (code=exited, status=2)
Please help us
It worked for me by using the below command and the logs are also generating now:
sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml