#support

External ClickHouse Server Installation Issue

TLDR Syed faced a connection error with an external ClickHouse server. Srikanth and Ankit suggested changing the cluster name to 'cluster'. The issue was resolved after updating the name.

Powered by Struct AI
Apr 07, 2023 (8 months ago)
Syed
Photo of md5-f16c6ead78bebb6489e7ed7b121f5ce9
Syed
02:13 AM
Hi Team, I am installing signoz with external clickhouse server. I am facing an issue. Getting below error:
kubectl logs -f my-release-signoz-otel-collector-54bf55dbb9-ckqmz

Defaulted container "my-release-signoz-otel-collector" out of: my-release-signoz-otel-collector, my-release-signoz-otel-collector-init (init)
2023-04-07T02:08:48.916Z    info    service/telemetry.go:111    Setting up own telemetry...
2023-04-07T02:08:48.916Z    info    service/telemetry.go:141    Serving Prometheus metrics    {"address": "0.0.0.0:8888", "level": "Basic"}
2023-04-07T02:08:48.916Z    info    components/components.go:30    Stability level of component is undefined    {"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "stability": "Undefined"}
Error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": error connecting to primary db: code: 170, message: Requested cluster 'cluster' not found
2023/04/07 02:08:48 application run finished with error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": error connecting to primary db: code: 170, message: Requested cluster 'cluster' not found

My override file:

global:
  storageClass: gp2
  cloud: aws

clickhouse:
  enabled: false
  cloud: other


externalClickhouse:
  host: 54.75.80.150
  cluster: events 
  user: xxxxxx
  password: xxxxxxxxxxxxxxx
  secure: false
  verify: false
  httpPort: 8123
  tcpPort: 9000

allowedNetworkIps:
    - "0.0.0.0/0"

I really appreciate your kind response.
Srikanth
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
02:17 AM
There should be a cluster named with cluster
Syed
Photo of md5-f16c6ead78bebb6489e7ed7b121f5ce9
Syed
02:18 AM
where? my clickhouse cluster name is event
Srikanth
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
02:18 AM
SigNoz needs a cluster named with cluster . Create one if it doesn’t exist.
Syed
Photo of md5-f16c6ead78bebb6489e7ed7b121f5ce9
Syed
02:18 AM
    Environment:
      CLICKHOUSE_HOST:                  54.75.70.130
      CLICKHOUSE_PORT:                  9000
      CLICKHOUSE_HTTP_PORT:             8123
      CLICKHOUSE_CLUSTER:               events
      CLICKHOUSE_DATABASE:              signoz_metrics
      CLICKHOUSE_TRACE_DATABASE:        signoz_traces
      CLICKHOUSE_USER:                  admin
      CLICKHOUSE_PASSWORD:              2kkkkkkkb9
      CLICKHOUSE_SECURE:                false
      CLICKHOUSE_VERIFY:                false
      K8S_NODE_NAME:                     (v1:spec.nodeName)
      K8S_POD_IP:                        (v1:status.podIP)
      K8S_POD_NAME:                     my-release-signoz-otel-collector-54bf55dbb9-ckqmz (v1:metadata.name)
      K8S_POD_UID:                       (v1:metadata.uid)
      K8S_NAMESPACE:                    platform (v1:metadata.namespace)
      K8S_CLUSTER_NAME:
      SIGNOZ_COMPONENT:                 otel-collector
      OTEL_RESOURCE_ATTRIBUTES:         host.name=$(K8S_NODE_NAME),signoz.component=$(SIGNOZ_COMPONENT),k8s.cluster.name=$(K8S_CLUSTER_NAME),k8s.pod.uid=$(K8S_POD_UID),k8s.pod.ip=$(K8S_POD_IP)
      LOW_CARDINAL_EXCEPTION_GROUPING:  false
02:19
Syed
02:19 AM
this is my env for otel collector
02:19
Syed
02:19 AM
ok let me change the name of my clickhouse cluster
02:28
Syed
02:28 AM
I will update once I get the name updated.
Ankit
Photo of md5-dbe7088320fe1d922707613e02f3420d
Ankit
04:00 AM
cluster name cannot be different than cluster
Syed
Photo of md5-f16c6ead78bebb6489e7ed7b121f5ce9
Syed
07:45 AM
Thanks alot, Let me bring up the cluster
08:07
Syed
08:07 AM
Thanks a lot Ankit and Srikanth. Really really appreciate your help. It is now working. You guys are rock. Now I will change zooker because I want to use using clickhouse-keeper. and will change query service endpoint to point to my external database

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 1023 threads (61% resolved)

Join Our Community