Segmentation fault after upgrade to 23.9.1.1854

TL;DR

Upgrade to a supported release (23.12 or newer); old versions are not patched. Source: https://github.com/ClickHouse/clickhouse/issues/55659 (ClickHouse Cloud) Segfault after upgrading to 23.9.1: version 23.9 went out of support once 23.12 shipped.

Steps

1. Segfault after upgrading to 23.9.1: version 23.9 went out of support once 23.12 shipped. Upgrade to a supported release (23.12 or newer); old versions are not patched.
2. Source: https://github.com/ClickHouse/clickhouse/issues/55659 (ClickHouse Cloud)

When to use

Use this skill when you run into "Segmentation fault after upgrade to 23.9.1.1854".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: 23.9.1, 23.9. If you are on something much newer or older, the details may have shifted.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://github.com/ClickHouse/clickhouse/issues/55659

In gh:ClickHouse/clickhouse#55659, the issue was: Describe what's wrong We have a cluster of 6 nodes (3 shards and 2 replicas). Some time ago we updated it from 22.10.6.3-1 to the latest version and an hour later we encountered the first such problem. Some Clickhouse cluster nodes reboot unexpectedly with a Segfault error. We cannot repeat this, it happens for no apparent reason. We checked the logs and metrics, and nothing could help us understand the cause of the error. Does it reproduce on recent release? Yes. CH version is 23.9.1.1854 (official build). Expected behavior Cluster work without restarts. **Error message and/or sta. The verified answer: Segfault after upgrading to 23.9.1: version 23.9 went out of support once 23.12 shipped. Upgrade to a supported release (23.12 or newer); old versions are not patched.. Issue URL: https://github.com/ClickHouse/clickhouse/issues/55659