clickhouse 安装过程中出现的问题

原创

香山上的麻雀 2021-06-21 16:35:50 ©著作权

文章标签 clickhouse 文章分类 大数据

©著作权归作者所有：来自51CTO博客作者香山上的麻雀的原创作品，请联系作者获取转载授权，否则将追究法律责任

ch安装

安装步骤：

sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
sudo yum install clickhouse-server clickhouse-client

sudo /etc/init.d/clickhouse-server start
clickhouse-client

报错信息

安装结束后启动客户端报错：

$ clickhouse-client
ClickHouse client version 21.2.4.6 (official build).
Connecting to localhost:9000 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9000)

然后排查：

$ sudo  netstat -tunlpa | grep 9000
tcp        0      0 10.60.11.3:9000         0.0.0.0:*               LISTEN      9791/python2.7      
tcp        0      0 10.60.11.3:49000        10.60.11.3:12321        TIME_WAIT

发现9000端口被占用了

修改clickhouse 默认端口

cd /etc/clickhouse-server
vim config.xml

将配置文件中的9000全部替换为9001
然后再次启动：

注意端口修改后启动clickhouse-client要加上 --port 9001，如下：

# [cdh-test03 root 19:57:51] [Mon Feb 22] ~
$ /etc/init.d/clickhouse-server start
Init script is already running

$ clickhouse-client  --port 9001
ClickHouse client version 21.2.4.6 (official build).
Connecting to localhost:9001 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9001)

发现仍然报错
检查发现clickhouse-server根本没起来。
然后用如下命令启动：

sudo systemctl start clickhouse-server
sudo systemctl stop clickhouse-server
sudo systemctl status clickhouse-server

然后就正常启动了。

$ clickhouse-client  --port 9001
ClickHouse client version 21.2.4.6 (official build).
Connecting to localhost:9001 as user default.
Connected to ClickHouse server version 21.2.4 revision 54447.

cdh-test03 :) quit;
Happy Chinese new year. 春节快乐!

参考：https://blog.csdn.net/qq_35423190/article/details/109629855