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 https://github.com/SigNoz/charts/blob/c8486fabd02e107c13b21a2f04563c5df7e4fb90/charts/signoz/values.yaml#L1151 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?

https://github.com/SigNoz/signoz-otel-collector/issues/180