Since couple of hours ago the

Traces

tab in the traces explorer stopped working and I am getting 500s. I upgraded the version from 0.82 to 0.84.1 so I am curious if it is related.

POST <http://localhost:8080/api/v4/query_range> 500 (Internal Server Error)
dispatchXhrRequest @ xhr.js:195
xhr @ xhr.js:15
dispatchRequest @ dispatchRequest.js:51
Promise.then
_request @ Axios.js:163
request @ Axios.js:40
httpMethod @ Axios.js:226
wrap @ bind.js:5
getMetricsQueryRange @ getQueryRange.ts:19
GetMetricQueryRange @ getQueryResults.ts:30
queryFn @ useGetQueryRange.ts:50
fetchFn @ query.js:300
run @ retryer.js:95
(anonymous) @ retryer.js:149
Promise.then
(anonymous) @ retryer.js:145
Promise.catch
run @ retryer.js:116
(anonymous) @ retryer.js:149
Promise.then
(anonymous) @ retryer.js:145
Promise.catch
run @ retryer.js:116
Retryer @ retryer.js:156
fetch @ query.js:332
executeFetch @ queryObserver.js:199
onSubscribe @ queryObserver.js:40
subscribe @ subscribable.js:16
(anonymous) @ useBaseQuery.js:60
commitHookEffectListMount @ react-dom.development.js:23150
commitPassiveMountOnFiber @ react-dom.development.js:24931
commitPassiveMountEffects_complete @ react-dom.development.js:24891
commitPassiveMountEffects_begin @ react-dom.development.js:24878
commitPassiveMountEffects @ react-dom.development.js:24866
flushPassiveEffectsImpl @ react-dom.development.js:27039
flushPassiveEffects @ react-dom.development.js:26984
commitRootImpl @ react-dom.development.js:26935
commitRoot @ react-dom.development.js:26682
performSyncWorkOnRoot @ react-dom.development.js:26117
flushSyncCallbacks @ react-dom.development.js:12042
commitRootImpl @ react-dom.development.js:26959
commitRoot @ react-dom.development.js:26682
finishConcurrentRender @ react-dom.development.js:25981
performConcurrentWorkOnRoot @ react-dom.development.js:25809
workLoop @ scheduler.development.js:266
flushWork @ scheduler.development.js:239
performWorkUntilDeadline @ scheduler.development.js:533Understand this error


query.js:358 Error: API responded with 500 -  Something went wrong status: encountered multiple errors: 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 >= '1747859308000000000') AND (__table4.timestamp <= '1747862908000000000')) AND ((__table4.ts_bucket_start >= 1747857508) AND (__table4.ts_bucket_start <= 1747862908)) 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 >= '1747859308000000000') AND (__table1.timestamp <= '1747862908000000000')) AND ((__table1.ts_bucket_start >= 1747857508) AND (__table1.ts_bucket_start <= 1747862908)) 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')
    at GetMetricQueryRange (getQueryResults.ts:42:9)

Thanks @Dimitris Mavrommatis for reporting the issue. Let me check with team and also try to upgrade from mentioned version