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.
1
Aug 17, 2023 (3 months ago)
Romil
06:15 PMsignoz-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
07:49 PMRomil
07:50 PM1
SigNoz Community
Indexed 1023 threads (61% resolved)
Similar Threads
Alert Issues After Upgrading SigNoz
James experienced issues with alert rules after upgrading SigNoz. Srikanth suggested using sqlite tool to remove the alerts.
Resolving Signoz Query Service Error
Einav encountered an error related to a missing table in the Signoz service which was preventing data visibility in the UI. Srikanth guided them to restart specific components and drop a database table, which resolved the issue.
Troubleshooting Interactive Message Errors on Query-Service
Javier asked how to check query-service logs and shared an error message. Srikanth helped Javier identify the problem and suggested restarting the `clickhouse-setup_otel-collector-1` container. Javier confirmed the solution worked.