[Bug]: why jaeger don't connect clickhouse databases; about jaeger-clickhouse

[zhixiangjoy]

I meet the same problem, I solved by add "//" before ck address, like this: address: //clickhouse.test-clickhouse:9000.

[pradipsakh]

@ericinfra , I am facing the same problem. Did you found solution for this ?

[ericinfra]

@ericinfra , I am facing the same problem. Did you found solution for this ?

@pradipsakh

Sorry, I went back to my hometown last week
This problem is related to two configurations

1.Note: must first create the following database and sql in clickhouse

CREATE DATABASE IF NOT EXISTS jaeger ON CLUSTER '$CLUSTER_NAME' ENGINE=Atomic;

2.The config.yaml of jaeger needs to clearly write spans_table, and it cannot be defaulted. My yaml file is as follows::

cat <<EOF | kubectl apply -f -
apiVersion: v1
kind: ConfigMap
metadata:
  name: jaeger-clickhouse
  namespace: observability
  labels:
    jaeger-clickhouse: demo
data:
  config.yaml: |
    address: clickhouse.test-clickhouse:9000
    username: jaeger
    password: jaeger123
    database: jaeger
    replication: true
    spans_table: jaeger_spans
    spans_index_table: jaeger_index
    operations_table: jaeger_operations
    ttl: 15
EOF

cat <<EOF | kubectl create -f -
apiVersion: jaegertracing.io/v1
kind: Jaeger
metadata:
  name: jaeger-clickhouse
  labels:
    jaeger-clickhouse: demo
spec:
  storage:
    type: grpc-plugin
    grpcPlugin:
      image: ghcr.io/jaegertracing/jaeger-clickhouse:0.13.0
    options:
      grpc-storage-plugin:
        binary: /plugin/jaeger-clickhouse
        configuration-file: /plugin-config/config.yaml
        log-level: debug
  volumeMounts:
    - name: plugin-config
      mountPath: /plugin-config
  volumes:
    - name: plugin-config
      configMap:
        name: jaeger-clickhouse
EOF

3.You need to ensure that all the nodes of the clickhouse are normal. Maybe the jaeger link to the clickhouse needs to be improved, so you need to ensure that each node of the clickhouse is normal. I configured 16G memory for each node of the clickhouse and it is normal.

Wish you all the best