#support

Bug Identified in Exception Screen on Fresh Install

TLDR Romil found a bug on the exception screen during a fresh install. Pranay suggested creating an issue on GitHub and potentially sharing a fix.

Powered by Struct AI

1

Aug 17, 2023 (3 months ago)
Romil
Photo of md5-9fdac386927ff20f6a6bc0d2a9164de5
Romil
06:15 PM
noticed a bug on the exception screen on fresh install:
signoz-query-service-0 signoz-query-service 2023-08-17T18:14:57.704Z    INFO    clickhouseReader/reader.go:2766 SELECT any(exceptionMessage) as exceptionMessage, count() AS exceptionCount, min(timestamp) as firstSeen, max(timestamp) as lastSeen, groupID, any(serviceName) as serviceName, any(exceptionType) as exceptionType FROM signoz_traces.distributed_signoz_error_index_v2 WHERE timestamp >= @timestampL AND timestamp <= @timestampU GROUP BY groupID ORDER BY serviceName DESC LIMIT @limit
signoz-query-service-0 signoz-query-service 2023-08-17T18:14:57.704Z    DEBUG   clickhouseReader/reader.go:2769 Error in processing sql query: code: 215, message: Column `serviceName` is not under aggregate function and not in GROUP BY. Have columns: ['any(serviceName)','count()','min(timestamp)','any(exceptionMessage)','max(timestamp)','any(exceptionType)','groupID']: While processing serviceName DESC
signoz-query-service-0 signoz-query-service 2023-08-17T18:14:57.704Z    ERROR   app/http_handler.go:2229        HTTP handler, Internal Server Error{error 26 0  Error in processing sql query}
signoz-query-service-0 signoz-query-service 
Pranay
Photo of md5-8df7ce0274b2473ec07403336e48b574
Pranay
07:49 PM
Please create an issue in github Romil and if you have a fix PR In mind, please share that as well 🙂
Romil
Photo of md5-9fdac386927ff20f6a6bc0d2a9164de5
Romil
07:50 PM
Okay!

1