snuba events_analytics_ platform requires clickhouse 23.3

[ntcong]

Issue submitter TODO list

• I've searched for an already existing issues here

Describe the bug (actual behavior)

The upgrading process failed with snuba-migrate because events_analytics_ platform can't be migrated
Executing snuba migrations migrate manually and it fails

  File "/usr/local/lib/python3.11/site-packages/clickhouse_driver/client.py", line 237, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 36.
DB::Exception: Codec DoubleDelta does not accept any arguments. Stack trace:

0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<
char> > const&, int, bool) @ 0xa40325a in /usr/bin/clickhouse
1. ? @ 0x140fec52 in /usr/bin/clickhouse
2. ? @ 0x14e1cf6e in /usr/bin/clickhouse
3. DB::ISerialization::enumerateStreams(DB::ISerialization::SubstreamPath&, std::__1::function<void (DB::I
Serialization::SubstreamPath const&)> const&, DB::ISerialization::SubstreamData const&) const @ 0x14238771
 in /usr/bin/clickhouse

Expected behavior

migrations successful

values.yaml

.

Helm chart version

25.9.0

Steps to reproduce

official self-hosted image uses 23.8 and automatically upgrade clickhouse to 23.8
https://github.com/getsentry/self-hosted/blob/master/install/upgrade-clickhouse.sh

I tried setting clickhouse image to 23.3.19.32 and the migrations went through.

Screenshots

No response

Logs

No response

Additional context

No response

[patsevanton]

Please write your values.yaml

[shcherbak]

we facing similar problem with release 24.8
getsentry/snuba#6355
there is a syntax error in migration query

events_analytics_platform (readiness_state: limited)
[-]  0001_spans (IN PROGRESS)

[swade1987]

I also raised the same issue #1508 but mine is for a total fresh installation.

When you read this error: getsentry/snuba#6355, it matches the exact point at which my failure occurred.

2024-10-04 11:19:58,663 Query: SELECT version FROM migrations_dist FINAL WHERE group = 'events_analytics_platform' AND migration_id = '0001_spans’; ⁠

Then I have a failure straight after ⁠ 0001_spans ⁠

[patsevanton]

Try tag 25.16.0

[patsevanton]

@ntcong Try https://github.com/sentry-kubernetes/charts/releases/tag/sentry-v25.19.0

[Mokto]

This issue is stale because it has been open for 30 days with no activity.