clickhouse service cant start

[Panos Op]

● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data) Loaded: loaded (/lib/systemd/system/clickhouse-server.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Fri 2023-04-28 14:55:15 UTC; 1s ago Process: 1486 ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid (code=exited, status=232/ADDRESS_FAMILIES) Main PID: 1486 (code=exited, status=232/ADDRESS_FAMILIES) CPU: 100ms

[Panos Op]

Hi, I noticed that the clickhouse service was not running for a host in the cluster

It appears to be trying to start but fails with  status=232/ADDRESS_FAMILIES

[Panos Op]

clickhouse-server.err.log

2023.04.28 09:18:13.816438 [ 30737 ] {} <Fatal> Application: Child process was terminated by signal 9 (KILL). If it is not done by 'forcestop' command or manually, the possible cause is OOM Killer (see 'dmesg' and look at the '/var/log/kern.log' for the details).

[Panos Op]

issue resolved
related to interserver_http_host
setting in the config.xml file

[Vladimir]

Hi!

Actually `Application: Child process was terminated by signal 9` should not be related to config. What have you changed to start the server?

[Panos Op]

it turned out to be the linux oom killer 

it was terminating the service when really big queries were using up host memory

after multiple auto restarts, it was stuck and unable to start the server

sanitizing the config file somehow seems to fix the problem and allow it to restart

further memory limits where put in place in the config through the use of max_server_memory_usage