Alok Singh
02/06/2025, 10:47 AM{
"level": "ERROR",
"timestamp": "2025-02-06T10:39:39.558Z",
"caller": "clickhouseReader/reader.go:4517",
"msg": "error while reading time series result",
"error": "code: 179, message: Multiple expressions __table1.trace_id and __table2.traceID for alias traceID. In scope SELECT __table2.serviceName AS `subQuery.serviceName`, __table2.name AS `subQuery.name`, count() AS span_count, __table2.durationNano AS `subQuery.durationNano`, __table2.traceID AS traceID FROM signoz_traces.signoz_index_v3 AS __table1 ALL INNER JOIN (SELECT __table3.traceID AS traceID, __table3.durationNano AS durationNano, __table3.serviceName AS serviceName, __table3.name AS name FROM (SELECT __table4.trace_id AS traceID, __table4.duration_nano AS durationNano, __table4.`resource_string_service$$name` AS serviceName, __table4.name AS name FROM signoz_traces.signoz_index_v3 AS __table4 WHERE ((__table4.parent_span_id AS parentSpanID) = '') AND ((__table4.timestamp >= '1738751816000000000') AND (__table4.timestamp <= '1738838216000000000')) AND ((__table4.ts_bucket_start >= 1738750016) AND (__table4.ts_bucket_start <= 1738838216)) ORDER BY durationNano DESC LIMIT _CAST(1, 'UInt64') BY traceID) AS __table3) AS __table2 ON (__table1.trace_id AS traceID) = __table2.traceID WHERE ((__table1.timestamp >= '1738751816000000000') AND (__table1.timestamp <= '1738838216000000000')) AND ((__table1.ts_bucket_start >= 1738750016) AND (__table1.ts_bucket_start <= 1738838216)) GROUP BY __table2.traceID, __table2.durationNano, __table2.name, __table2.serviceName ORDER BY __table2.durationNano DESC LIMIT _CAST(1, 'UInt64') BY __table2.traceID LIMIT _CAST(10, 'UInt64')",
"stacktrace": "<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetListResultV3|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetListResultV3>\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4517\ngo.signoz.io/signoz/pkg/query-service/app/querier.(*querier).runBuilderListQueries.func1\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/querier/querier.go:489"
}
Vikrant Gupta
02/06/2025, 2:25 PMAlok Singh
02/14/2025, 3:04 PMAlok Singh
02/14/2025, 3:25 PMsubQuery.serviceName
, __table2.name AS subQuery.name
, *count*() AS _span_count_, __table2.durationNano AS subQuery.durationNano
, __table2.traceID AS _trace_id_ FROM signoz_traces.signoz_index_v3 AS __table1 ALL INNER JOIN (SELECT __table3.traceID AS traceID, __table3.durationNano AS durationNano, __table3.serviceName AS serviceName, __table3.name AS name FROM (SELECT __table4.trace_id AS traceID, __table4.duration_nano AS durationNano, __table4.resource_string_service$$name
AS serviceName, __table4.name AS name FROM signoz_traces.signoz_index_v3 AS __table4 WHERE ((__table4.parent_span_id AS parentSpanID) = '') AND ((__table4.timestamp >= '1738751816000000000') AND (__table4.timestamp <= '1738838216000000000')) AND ((__table4.ts_bucket_start >= 1738750016) AND (__table4.ts_bucket_start <= 1738838216)) ORDER BY durationNano DESC LIMIT _CAST(1, 'UInt64') BY traceID) AS __table3) AS __table2 ON (__table1.trace_id AS traceID) = __table2.traceID WHERE ((__table1.timestamp >= '1738751816000000000') AND (__table1.timestamp <= '1738838216000000000')) AND ((__table1.ts_bucket_start >= 1738750016) AND (__table1.ts_bucket_start <= 1738838216)) GROUP BY __table2.traceID, __table2.durationNano, __table2.name, __table2.serviceName ORDER BY __table2.durationNano DESC LIMIT _CAST(1, 'UInt64') BY __table2.traceID LIMIT _CAST(10, 'UInt64')Ekansh Gupta
02/14/2025, 4:39 PMAlok Singh
02/15/2025, 9:21 AMEkansh Gupta
02/15/2025, 1:40 PMAlok Singh
02/17/2025, 4:45 AMEkansh Gupta
02/17/2025, 5:58 AMAlok Singh
02/17/2025, 7:18 AMAlok Singh
02/17/2025, 8:26 AMEkansh Gupta
02/17/2025, 1:44 PMAlok Singh
02/17/2025, 4:35 PMMing Fang
04/18/2025, 11:05 PMEkansh Gupta
04/23/2025, 4:35 AMMing Fang
04/23/2025, 4:37 AM