Unable to determine server timezone

[igrishi]

Observed

When trying to execute a query over self hosted clickhouse cluster, the query fails as it is not able to determine the server timezone during connectivity. This behaviour is transient and upon retries the query is successfully executed.

Expected behaviour

The clickhouse should have queried the source and return the response.

Error log

error: unable to determine server timezone
   errorVerbose: unable to determine server timezone
github.com/ClickHouse/clickhouse-go/v2.(*httpConnect).readTimeZone
	/go/pkg/mod/github.com/!click!house/clickhouse-go/v2@v2.13.0/conn_http.go:295
github.com/ClickHouse/clickhouse-go/v2.dialHttp
	/go/pkg/mod/github.com/!click!house/clickhouse-go/v2@v2.13.0/conn_http.go:243
github.com/ClickHouse/clickhouse-go/v2.(*stdConnOpener).Connect.func1
	/go/pkg/mod/github.com/!click!house/clickhouse-go/v2@v2.13.0/clickhouse_std.go:68
github.com/ClickHouse/clickhouse-go/v2.(*stdConnOpener).Connect
	/go/pkg/mod/github.com/!click!house/clickhouse-go/v2@v2.13.0/clickhouse_std.go:88
database/sql.(*DB).conn
	/usr/local/go/src/database/sql/sql.go:1387
database/sql.(*DB).query
	/usr/local/go/src/database/sql/sql.go:1721
database/sql.(*DB).QueryContext.func1
	/usr/local/go/src/database/sql/sql.go:1704
database/sql.(*DB).retry
	/usr/local/go/src/database/sql/sql.go:1538
database/sql.(*DB).QueryContext
	/usr/local/go/src/database/sql/sql.go:1703
database/sql.(*DB).Query
	/usr/local/go/src/database/sql/sql.go:1717

Details

Environment

• clickhouse-go version: v2.13.0
• Interface: ClickHouse API / database/sql compatible driver
• Go version: 1.18
• Operating system: linux
• ClickHouse version: v23.12.2-debian
• Is it a ClickHouse Cloud? No
• ClickHouse Server non-default settings, if any:
• CREATE TABLE statements for tables involved:
• Sample data for all these tables, use clickhouse-obfuscator if necessary

[jkaflik]

@igrishi is it reproducible on newer ClickHouse version? 23.12 is not supported anymore.