Check to determine if Clickhouse tables should be clustered is catastrophically flawed

[doctorpangloss]

Past Issues Searched

• I have searched open and closed issues to make sure that the bug has not yet been reported

Issue is a Bug Report

• This is a bug report and not a feature request, nor asking for self-hosted support

Using official Plausible Cloud hosting or self-hosting?

Self-hosting

Describe the bug

analytics/lib/plausible/data_migration/numeric_ids.ex

Line 49 in 51f0e40

{:ok, %{num_rows: 1}} -> true

which calls

SELECT 1 FROM system.replicas WHERE table = 'events'

On a clean clustered Clickhouse, this will return 0.

Expected behavior

You must determine if clustered tables should be used some other way.

Screenshots

No response

Environment

No response

[doctorpangloss]

select 1 from system.clusters where host_address != '127.0.0.1'

should work instead. additionally, the legacy ddl needs to be updated