External Clickhouse config issue

[sarsony1]

Hello. I am having an issue with externalClickhouse setup.
I dont think externalClickhouse custom cluster value is being passed down.
I am using a cutom cluster name which I can see in the dry run but I am getting an error as follows

2023-11-09T06:32:04.043Z	info	exporter@v0.79.0/exporter.go:275	Stability level of component is undefined	{"kind": "exporter", "data_type": "metrics", "name": "clickhousemetricswrite"}
time="2023-11-09T06:32:04Z" level=info msg="Executing:\nCREATE DATABASE IF NOT EXISTS signoz_metrics ON CLUSTER cluster\n" component=clickhouse
2023/11/09 06:32:04 Error creating clickhouse client: code: 701, message: Requested cluster 'cluster' not found

Its still using the default value cluster. I tried to look at the code but I could not find any trace of CLICKHOUSE_CLUSTER env var you are passing to the collector. Please help with this.

[dhawal1248]

Hi @sarsony1 , how are you configuring the cluster currently? are you setting some env likeCLICKHOUSE_CLUSTER?

[dhawal1248]

We have recently changed the way we run migrations and accept the cluster variable
We run migrations in a separate k8s job now, can you try doing the following?

• Add --cluster-name arg followed by your cluster name here

  charts/charts/signoz/values.yaml

  Line 1151 in c8486fa

  args: {}

  
  the section should look something like

args:
  - --cluser-name
  - <your-cluster-name>

[dhawal1248]

Will add a section about this in the readme

[balagurrr]

otelCollector has the same error - Requested cluster 'cluster' not found.
How can I fix this?

SigNoz/signoz-otel-collector#180