Search code examples
clickhouse

Receiving clickhouse Code: 210. DB::NetException: Net Exception: No route to host (XX.X.X.XX:9000) when trying to connect through remote host

I'm trying to connect clickhouse server through clickhouse-client from another node but getting following error:

Code: 210. DB::NetException: Net Exception: No route to host (xx.xx.xx.xxx:9000)

Clickhouse-client works on the same host but not from another server even though I'm able to ping the servers successfully. I've already tried <listen_host>0.0.0.0</listen_host> or :: or 127.0.0.0 settings in the config file, but nothing works.

Solution

  • Try running nc -z -v xx.xx.xx.xxx:9000 from where you are trying to connect. If you get the same no route to host error, then the problem is not with clickhouse.