v.23.9Improvement

Disable Server Shutdown by Systemd to Prevent Data Loss

Disable killing the server by systemd (that may lead to data loss when using Buffer tables). #54744 (Azat Khuzhin).
Disable server termination by systemd to prevent potential data loss with Buffer tables.

Why it matters

Systemd killing ClickHouse server abruptly can cause data loss when using Buffer tables, which rely on in-memory buffering before flushing data. This feature prevents systemd from forcibly killing the server, ensuring data integrity and stability.

How to use it

Configure the server or systemd service settings to disable or adjust the behavior of systemd killing the ClickHouse server. This usually involves modifying the systemd service unit to prevent sending a kill signal or handling it gracefully to avoid data loss with Buffer tables.