210 ошибка clickhouse

unable to connect to the client,following is the error

root@abcC:~# clickhouse-server client ClickHouse client version
20.1.4.14 (official build). Connecting to localhost:9000 as user default.
**Code: 210. DB::NetException: Connection refused (localhost:9000)**

lloiacono's user avatar

lloiacono

4,7122 gold badges30 silver badges46 bronze badges

asked Feb 18, 2020 at 14:35

Aneesh Babu's user avatar

5

Try this command:

sudo service clickhouse-server restart

Adrian Mole's user avatar

Adrian Mole

50.1k163 gold badges51 silver badges83 bronze badges

answered Mar 11, 2021 at 7:17

Pankaj's user avatar

You can try 3 things:

  1. try to deletemy-clickhouse/user.d/allow_only_from_localhost.xml config. Now, the user default can connect from any ip (caution).

  2. check the tcp port with

clickhouse extract-from-config --config-file "$CLICKHOUSE_CONFIG" --key=tcp_port

by default it is 9000.
Then try connecting to the correct tcp port

clickhouse-client --port 9000

ClickHouse client version 21.8.15.7.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.8.15 revision 54449.

c6d6dd1623a5 :)
  1. If you are using the docker image yandex/clickhouse-server, you can try to add my-clickhouse/config.d/docker_related_config.xml config.
<yandex>
     <!-- Listen wildcard address to allow accepting connections from other containers and host network. -->
    <listen_host>::</listen_host>
    <listen_host>0.0.0.0</listen_host>
    <listen_try>1</listen_try>

    <!--
    <logger>
        <console>1</console>
    </logger>
    -->
</yandex>

then in your .dockerfile :

FROM yandex/clickhouse-server:latest

COPY config.d/* /etc/clickhouse-server/config.d/

answered Dec 3, 2021 at 9:46

Pierre Louis's user avatar

Try this command It’s working for me.
clickhouse-client —host 127.0.0.1 —password

answered Jun 27, 2022 at 10:56

Hassan Abrar's user avatar

Specify the config path when starting the server, that will show you what error you are getting, very comfortable way for debuging the issue:

clickhouse-server --config-file=/etc/clickhouse-server/config.xml

or

sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml

Further read:
https://clickhouse.com/docs/en/operations/troubleshooting/

answered Jul 27, 2022 at 22:24

S.Roshanth's user avatar

S.RoshanthS.Roshanth

1,4993 gold badges25 silver badges36 bronze badges

Источник

unable to connect to the client,following is the error

root@abcC:~# clickhouse-server client ClickHouse client version
20.1.4.14 (official build). Connecting to localhost:9000 as user default.
**Code: 210. DB::NetException: Connection refused (localhost:9000)**

lloiacono's user avatar

lloiacono

4,7122 gold badges30 silver badges46 bronze badges

asked Feb 18, 2020 at 14:35

Aneesh Babu's user avatar

5

Try this command:

sudo service clickhouse-server restart

Adrian Mole's user avatar

Adrian Mole

50.1k163 gold badges51 silver badges83 bronze badges

answered Mar 11, 2021 at 7:17

Pankaj's user avatar

You can try 3 things:

  1. try to deletemy-clickhouse/user.d/allow_only_from_localhost.xml config. Now, the user default can connect from any ip (caution).

  2. check the tcp port with

clickhouse extract-from-config --config-file "$CLICKHOUSE_CONFIG" --key=tcp_port

by default it is 9000.
Then try connecting to the correct tcp port

clickhouse-client --port 9000

ClickHouse client version 21.8.15.7.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.8.15 revision 54449.

c6d6dd1623a5 :)
  1. If you are using the docker image yandex/clickhouse-server, you can try to add my-clickhouse/config.d/docker_related_config.xml config.
<yandex>
     <!-- Listen wildcard address to allow accepting connections from other containers and host network. -->
    <listen_host>::</listen_host>
    <listen_host>0.0.0.0</listen_host>
    <listen_try>1</listen_try>

    <!--
    <logger>
        <console>1</console>
    </logger>
    -->
</yandex>

then in your .dockerfile :

FROM yandex/clickhouse-server:latest

COPY config.d/* /etc/clickhouse-server/config.d/

answered Dec 3, 2021 at 9:46

Pierre Louis's user avatar

Try this command It’s working for me.
clickhouse-client —host 127.0.0.1 —password

answered Jun 27, 2022 at 10:56

Hassan Abrar's user avatar

Specify the config path when starting the server, that will show you what error you are getting, very comfortable way for debuging the issue:

clickhouse-server --config-file=/etc/clickhouse-server/config.xml

or

sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml

Further read:
https://clickhouse.com/docs/en/operations/troubleshooting/

answered Jul 27, 2022 at 22:24

S.Roshanth's user avatar

S.RoshanthS.Roshanth

1,4993 gold badges25 silver badges36 bronze badges

Источник

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.

vladimir's user avatar

vladimir

13.5k2 gold badges44 silver badges70 bronze badges

asked Sep 10, 2020 at 3:34

Sonam's user avatar

2

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.

answered Sep 10, 2020 at 12:54

photographyraptor's user avatar

2

I had this on my Mac and the console output from ./clickhouse server indicated that port 9000 was already in use. It was being used by php-fm which had been installed via Homebrew. I stopped PHP, restarted the ClickHouse server and was then able to connect.

answered Nov 23, 2022 at 12:42

The Man Doug's user avatar

Источник

Solve Code: 210. DB :: NETEXCEPTION: Connection Refused (localhost: 9000)
Start Clickhouse -Client error
Query the solution online: Modify the configuration file: vim /etc/clickhouse-server/config.xml. Listen_host only stays this configuration
<listen_host>::</listen_host>
Start still error.
2. Repeated query code: 210. DB :: NetException: Connection Refused (localhost: 9000) problem, almost all of them are changing the above configuration file, I will query the status of Clickhouse-Server, displaying running, but Server! Here inserts a picture description] (https://img-blog.csdnimg.cn/20210714151031891.jpg#pic_center
Didn’t start.
Finally, the main problem is that in RedHat 7 and after the operating system, you need to start with SystemCTL.
Server starts, start Clickhouse-Client again and test OK
Solve DBEAVER Can’t connect to Clickhouse

The reason for the connection may be that the virtual machine’s firewall is not closed.
Use Service iptables status to view the status of the firewall. The display is that the firewall is in a closed state:
However, using the systemctl status firewalld to query the status of the firewall, display the state of the firewall to be on: This is very out.
Start the service, use the DBEAVER to connect Clickhouse:

Then use the Systemctl Disable FireWallD command to permanently shut down the firewall. Finally, DBEAVER successfully connects Clickhouse.
Finally, attach some common commands of the virtual machine on the firewall:

Источник

не удается подключиться к клиенту, следующая ошибка

root@abcC:~# clickhouse-server client ClickHouse client version
20.1.4.14 (official build). Connecting to localhost:9000 as user default.
**Code: 210. DB::NetException: Connection refused (localhost:9000)**

person
Aneesh Babu
  
schedule
18.02.2020
  
source
источник

comment

Clickhouse не запущен. проверить service clickhouse-server status
  —  person Denny Crane    schedule 18.02.2020

comment

попробуйте clickhouse-client -h 127.0.0.1 --user default также проверьте grep -r -E "listen|host_regexp|<host>|<ip>" /etc/clickhouse-server/ проверьте, что ваше соединение разрешено, возможно, localhost разрешен как другой IP-адрес
  —  person Slach    schedule 19.02.2020

comment

это ошибка при выполнении СЕРВИС CLICKHOUSE-SERVER STATUS clickhouse-server.service — ClickHouse Server (аналитическая СУБД для больших данных) Загружено: загружено (/etc/systemd/system/clickhouse-server.service; включено; вендо Активно: активируется ( автоматический перезапуск) (Результат: код выхода) с четверга 20.02.2020 17 Процесс: 9066 ExecStart=/usr/bin/clickhouse-server —config=/etc/clickhouse-se Основной PID: 9066 (code=exited , status=70) Задачи: 0 Память: 0B ЦП: 0 CGroup: /system.slice/clickhouse-server.service
  —  person Aneesh Babu    schedule 20.02.2020

comment

clickhouse-server.service — ClickHouse Server (аналитическая СУБД для больших данных) Загружено: загружено (/etc/systemd/system/clickhouse-server.service; включено; предустановка производителя: включено) Активно: активируется (автоматический перезапуск) (Результат: код выхода) с четверга 20 февраля 2020 г. 17:32:35 UTC; 7 с назад Процесс: 9066 ExecStart=/usr/bin/clickhouse-server —config=/etc/clickhouse-server/config.xml —pid-file=/run/clickhouse-server/clickhouse-server.pid (code= e Основной PID: 9066 (код=выход, статус=70)
  —  person Aneesh Babu    schedule 20.02.2020

comment

проверьте журнал, чтобы найти причину проблемы: tail -64 /var/log/clickhouse-server/clickhouse-server.err.log
  —  person vladimir    schedule 26.04.2020

Ответы (1)

Попробуйте эту команду:

sudo service clickhouse-server restart

person
Pankaj
  
schedule
11.03.2021

Источник

Понравилась статья? Поделить с друзьями:

Интересное по теме:

  • 204 ошибка что это
  • 2106 ошибка шевроле авео
  • 206 ошибка ватсмайнер
  • 20a804 ошибка бмв f10
  • 210870 ошибка опель зафира

    • 0 0 голоса
    Рейтинг статьи
    Подписаться
    Уведомить о
    guest

    0 комментариев
    Старые
    Новые Популярные
    Межтекстовые Отзывы
    Посмотреть все комментарии