Is 0.11.2 SigNoz compatible with latest Clickhouse...
# support
a
Is 0.11.2 SigNoz compatible with latest Clickhouse release
22.11.2.30-1
?
Seems only service map breaks as of now from what I see.
Copy code
[35mDEBUG[0m	clickhouseReader/reader.go:1787	
		WITH
			quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state) AS duration_quantiles_state,
			finalizeAggregation(duration_quantiles_state) AS result
		SELECT
			src as parent,
			dest as child,
			result[1] AS p50,
			result[2] AS p75,
			result[3] AS p90,
			result[4] AS p95,
			result[5] AS p99,
			sum(total_count) as callCount,
			sum(total_count)/ @duration AS callRate,
			sum(error_count)/sum(total_count) as errorRate
		FROM signoz_traces.dependency_graph_minutes
		WHERE toUInt64(toDateTime(timestamp)) >= @start AND toUInt64(toDateTime(timestamp)) <= @end
		GROUP BY
			src,
			dest[{start 1670278519} {end 1670883289} {duration 604770}]
2022-12-12T22:15:19.163Z	[31mERROR[0m	clickhouseReader/reader.go:1792	Error in processing sql query: code: 184, message: Aggregate function quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state) is found inside another aggregate function in query: While processing quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state)
<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetDependencyGraph|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetDependencyGraph>
	/go/src/github.com/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:1792
<http://go.signoz.io/signoz/pkg/query-service/app.(*APIHandler).dependencyGraph|go.signoz.io/signoz/pkg/query-service/app.(*APIHandler).dependencyGraph>
v
@Alexei Zenin We haven’t tested clickhouse
22.11.2.30-1
Any advantages of using
22.11.2.30-1
over
22.8.8
? cc: @Srikanth Chekuri
a
Was just trying to use latest version for best performance/bug fixes, no specific reason other than keeping up to date
v
@Alexei Zenin We also track Clickhouse releases for perf improvements or bug fixes and update Clickhouse image regularly. You can rely on default Clickhouse version and let us know if you face any issues.