TNND，我是真的服了，估計玩阿里云集群的兄弟，都會遇到這個個問題。

首先我們來看啟動信息：

[root@hadoop101 ~]# clickhouse-client -m?
ClickHouse client version 20.4.5.36 (official build).
Connecting to localhost:9000 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9000)

從上面看，完全看不出問題，別信網(wǎng)上說的什么端口占用、進(jìn)程沒關(guān)

直接開日志

[root@hadoop101 clickhouse-server]# tail -f clickhouse-server.log

我們截取ERROR日志信息

2022.02.14 17:32:43.642826 [ 2396 ] {} <Information> Application: starting up
2022.02.14 17:32:43.646257 [ 2396 ] {} <Debug> Application: rlimit on number of file descriptors is 500000
2022.02.14 17:32:43.646274 [ 2396 ] {} <Debug> Application: Initializing DateLUT.
2022.02.14 17:32:43.646282 [ 2396 ] {} <Trace> Application: Initialized DateLUT with time zone 'Asia/Shanghai'.
2022.02.14 17:32:43.646304 [ 2396 ] {} <Debug> Application: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2022.02.14 17:32:43.646484 [ 2396 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'hadoop101' as replica host.
2022.02.14 17:32:43.648321 [ 2396 ] {} <Debug> ConfigReloader: Loading config '/etc/clickhouse-server/users.xml'
2022.02.14 17:32:43.649468 [ 2396 ] {} <Information> Application: Uncompressed cache size was lowered to 3.75 GiB because the system has low amount of memory
2022.02.14 17:32:43.649689 [ 2396 ] {} <Information> Application: Mark cache size was lowered to 3.75 GiB because the system has low amount of memory
2022.02.14 17:32:43.649726 [ 2396 ] {} <Information> Application: Setting max_server_memory_usage was set to 6.75 GiB
2022.02.14 17:32:43.649734 [ 2396 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2022.02.14 17:32:43.651423 [ 2396 ] {} <Information> DatabaseOrdinary (system): Total 2 tables and 0 dictionaries.
2022.02.14 17:32:43.656837 [ 2401 ] {} <Information> BackgroundProcessingPool: Create BackgroundProcessingPool with 16 threads
2022.02.14 17:32:43.657703 [ 2401 ] {} <Debug> system.metric_log: Loading data parts
2022.02.14 17:32:43.663843 [ 2401 ] {} <Debug> system.metric_log: Loaded data parts (2 items)
2022.02.14 17:32:43.664195 [ 2401 ] {} <Debug> system.trace_log: Loading data parts
2022.02.14 17:32:43.664937 [ 2401 ] {} <Debug> system.trace_log: Loaded data parts (3 items)
2022.02.14 17:32:43.665026 [ 2396 ] {} <Information> DatabaseOrdinary (system): Starting up tables.
2022.02.14 17:32:43.665941 [ 2396 ] {} <Information> DatabaseOrdinary (default): Total 0 tables and 0 dictionaries.
2022.02.14 17:32:43.665958 [ 2396 ] {} <Information> DatabaseOrdinary (default): Starting up tables.
2022.02.14 17:32:43.666002 [ 2396 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 16 threads
2022.02.14 17:32:43.666800 [ 2396 ] {} <Debug> Application: Loaded metadata.
2022.02.14 17:32:43.666835 [ 2396 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2022.02.14 17:32:43.668407 [ 2396 ] {} <Information> Application: Shutting down storages.
2022.02.14 17:32:43.668460 [ 2420 ] {} <Trace> SystemLog (system.trace_log): Flushing system log
2022.02.14 17:32:43.668545 [ 2420 ] {} <Debug> SystemLog (system.trace_log): Will use existing table system.trace_log for TraceLog
2022.02.14 17:32:43.668793 [ 2420 ] {} <Debug> DiskLocal: Reserving 1.00 MiB on disk `default`, having unreserved 26.30 GiB.
2022.02.14 17:32:43.669562 [ 2420 ] {} <Trace> system.trace_log: Renaming temporary part tmp_insert_202202_1_1_0 to 202202_19_19_0.
2022.02.14 17:32:44.665383 [ 2421 ] {} <Trace> SystemLog (system.metric_log): Flushing system log
2022.02.14 17:32:44.665754 [ 2421 ] {} <Debug> SystemLog (system.metric_log): Will use existing table system.metric_log for MetricLog
2022.02.14 17:32:44.667693 [ 2421 ] {} <Debug> DiskLocal: Reserving 1.00 MiB on disk `default`, having unreserved 26.30 GiB.
2022.02.14 17:32:44.668659 [ 2421 ] {} <Trace> system.metric_log: Renaming temporary part tmp_insert_202202_1_1_0 to 202202_71_71_0.
2022.02.14 17:32:44.669585 [ 2396 ] {} <Trace> BackgroundSchedulePool/BgSchPool: Waiting for threads to finish.
2022.02.14 17:32:44.669831 [ 2396 ] {} <Debug> Application: Shut down storages.
2022.02.14 17:32:44.670359 [ 2396 ] {} <Debug> Application: Destroyed global context.
2022.02.14 17:32:44.670824 [ 2396 ] {} <Error> Application: DB::Exception: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = DNS error: EAI: -9 (version 20.4.5.36 (official build))
2022.02.14 17:32:44.670847 [ 2396 ] {} <Information> Application: shutting down
2022.02.14 17:32:44.670853 [ 2396 ] {} <Debug> Application: Uninitializing subsystem: Logging Subsystem
2022.02.14 17:32:44.670904 [ 2399 ] {} <Trace> BaseDaemon: Received signal -2
2022.02.14 17:32:44.670925 [ 2399 ] {} <Information> BaseDaemon: Stop SignalListener thread

提取關(guān)鍵信息：

2022.02.14 17:32:44.670824 [ 2396 ] {} <Error> Application: DB::Exception: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = DNS error: EAI: -9 (version 20.4.5.36 (official build))

他說連接不上這個端口，好了，我們一般到這就是去查看端口了，結(jié)構(gòu)netstat一看，沒被占用，就迷茫了。

重點：我們看配置文件就知道了

 <!-- Listen specified host. use :: (wildcard IPv6 address), if you want to accept connections both with IP
v4 and IPv6 from everywhere. -->

    <!-- <listen_host>::</listen_host> -->

    <!-- Same for hosts with disabled ipv6: -->
    <listen_host>0.0.0.0</listen_host>

    <!-- Default values - try listen localhost on ipv4 and ipv6: -->
    <!--
    <listen_host>::1</listen_host>
    <listen_host>127.0.0.1</listen_host>
    -->

從上面我們可以看得到，他說你要是用IPV4網(wǎng)絡(luò)格式的話，就不能用

<listen_host>::</listen_host>

必須的是

<listen_host>0.0.0.0</listen_host>

改好之后，重啟一下就好了，主要原因還是你云服務(wù)器沒開IPV6，應(yīng)該是這樣吧。文章來源地址http://www.zghlxwxcb.cn/news/detail-515983.html

到了這里，關(guān)于ClickHouse報錯：Code: 210. DB::NetException: Connection refused (localhost:9000)的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！