Hi team! Quite new to signoz and just upgrade to 0...
# support
z
Hi team! Quite new to signoz and just upgrade to 0.36 in my self hosted kubernetes cluster, but getting errors connecting clickhouse db when trying to run the migration script.
Copy code
$ kubectl run -n signoz -i -t signoz-migrate --image=signoz/migrate:0.36 --restart='Never'  -- -host=signoz-clickhouse -port=9000 -userName=admin -password=27ff0399-0d3a-4bd8-919d-17c2181e6fb9
If you don't see a command prompt, try pressing enter.
warning: couldn't attach to pod/signoz-migrate, falling back to streaming logs: unable to upgrade connection: container signoz-migrate not found in pod signoz-migrate_signoz
2024-01-04T06:33:40.645Z	DEBUG	migrate/main.go:224	Params: signoz-clickhouse 9000 admin
2024-01-04T06:33:41.646Z	FATAL	migrate/main.go:228	Error while connecting to clickhouse{error 26 0  dial tcp: lookup signoz-clickhouse: i/o timeout}
main.main
	/go/src/github.com/signoz/migrate/main.go:228
runtime.main
	/usr/local/go/src/runtime/proc.go:250
pod signoz/signoz-migrate terminated (Error)
I also tried using the pod ip instead of the service name, still getting
dial tcp: i/o timeout
error. However the port is accessible when I try telnet within the container. Any help or suggestions would be much appreciated!
n
@Prashant Shahi
p
Can you check if the ClickHouse cluster is ready and available? You will want to check for chi pods and clickhouse service