＜Error＞ Application: DB::Exception: Listen [::1]:8123 failed: Poco::Exception. Code: 1000, e.code()

问题一：

在连接clickhouse数据库时，使用

service clickhouse-server
/etc/init.d/clickhouse-service

时都会报     Init script is already running ，但是实际上数据库并没有起来，

可以使用

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

系列命令。

问题解决来源：https://github.com/ClickHouse/ClickHouse/issues/14861

 

问题二：

使用sudo systemctl status clickhouse-server命令时发现连接失败，显示clickhouse-server.service failed.或者 Now there is no clickhouse-server process.

使用

vim /var/log/clickhouse-server/clickhouse-server.err.log

查看clickhouse错误日志，显示：

<Error> Application: DB::Exception: Listen [::1]:8123 failed: Poco::Exception. Code: 1000, e.code() = 99, e.displayText() = Net Exception: Cannot assign requested address: [::1]:8123 (version 20.10.3.30 (official build))

查看配置文件：vim /etc/clickhouse-server/config.xml

将其中连接的配制改为：

可以发现使用sudo systemctl status clickhouse-server命令时显示状态正常：

问题解决来源：https://github.com/ClickHouse/ClickHouse/issues/815