how to solve langfuse clickhouse cluster schema_migrations error

[dinfor]

Dear,
env:
linux centos7, langfuse version v3.81.1
Run langfuse using docker compose, connect to the clickhouse cluster, and customize the cluster name without using the official default,
The cluster name is ckcluster3s2r. When running docker compose up-d, an error occurs：
error: failed to open database: code: 701, message: Requested cluster 'default' not found in line 0: CREATE TABLE schema_migrations ON CLUSTER default ( version Int64, dirty UInt8, sequence UInt64 ) Engine=ReplicatedMergeTree ORDER BY sequence Applying clickhouse migrations failed. This is mostly caused by the database being unavailable.
However, this table schema_migrations was not found in the code, Similar to creating clusters in scores traces. What is the implementation principle of this table schema_migrations and why is it automatically created? How can langfuse be run successfully？
Thanks.

[RajatGarga]

Facing the same error. I am trying this on kubernetes.
The worker pod was successfully able to connect to clickhouse and run migrations but the web app pod fails with the error

error: failed to open database: code: 701, message: Requested cluster 'default' not found in line 0:
			CREATE TABLE schema_migrations ON CLUSTER default (
				version    Int64,
				dirty      UInt8,
				sequence   UInt64
			) Engine=ReplicatedMergeTree ORDER BY sequence
Applying clickhouse migrations failed. This is mostly caused by the database being unavailable.
Exiting...

[dinfor]

@RajatGarga Must the clickhouse name be "default"？ How to create schema migrations using other cluster names？

[RajatGarga]

For me it had to do with clickhouse not being deployed in cluster mode and langfuse defaulting to cluster mode while accessing it. Adding an environment variable to langfuse containers CLICKHOUSE_CLUSTER_ENABLED='false' fixed this issue for me.

According to my understanding, if clickhouse is deployed in cluster mode then a cluster named default should exist. You can run select * from system.clusters; on clickhouse to check available clusters.