This message was deleted.

Slackbot

10/31/2023, 4:23 PM

This message was deleted.

Nicolai Birkmose Oksen

10/31/2023, 4:23 PM

I've set the port in the Helm Chart values to 9000.

Nicolai Birkmose Oksen

10/31/2023, 4:46 PM

I figured it out - Port had to be a string. New issue - it fails to ping the clickhouse instance. I'm using Clickhouse Cloud - any suggestions?

Nočnica Mellifera

10/31/2023, 7:25 PM

I felt so smart noticing

(float64=9000)

but it looks like you figured out that bit, does a test ping to your clickhouse cloud instance succeed?

👍 1

Nicolai Birkmose Oksen

10/31/2023, 7:26 PM

Do you mean a simple ping from the command line on my pc?

Nočnica Mellifera

10/31/2023, 7:27 PM

yeah, like, is the instance available at :9000 ?

Mayur B

11/09/2023, 2:55 PM

@Nočnica Mellifera 8123 is being automatically appended in the Init Containers despite giving 9000 in the port. Also if i remove the Ports from the endpoint, the init container connects successfully to the db but the main pod gives missing port error

Mayur B

11/09/2023, 3:02 PM

@Prashant Shahi

Copy code

{
  "level": "fatal",
  "timestamp": "2023-11-09T14:59:48.372Z",
  "caller": "signozschemamigrator/migrate.go:104",
  "msg": "Failed to create migration manager",
  "component": "migrate cli",
  "error": "failed to parse dsn: parse \"<tcp://clickhouse-microk8s>:%!s(float64=9000)?username=xxx&password=xxx\": invalid port \":%!s(float64=9000)\" after host",
  "stacktrace": "main.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:104\nruntime.main\n\t/opt/hostedtoolcache/go/1.20.10/x64/src/runtime/proc.go:250"
}

This is what happens if i remove the port. This is the schema-migrator-pod. And this is the init container when the port is removed

Mayur B

11/09/2023, 3:03 PM

where is the value for .clickhouse.httpUrl being fetched from in the repo?

Mayur B

11/09/2023, 4:07 PM

Temporarily resolved it by disabling

Copy code

schemaMigrator:
  enabled: false

Mayur B

11/09/2023, 4:28 PM

Copy code

TCPHandler: Code: 81. DB::Exception: Database signoz_metrics doesn't exist

This is the error i get when i disable migrator

Mayur B

11/09/2023, 4:54 PM

signoz_metrics db is not getting created when deploying clickhouse helm chart

8 Views

Open in Slack

Previous Next

SigNoz Community

SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.