Resolving Table Headings and Converting Durationnano to Seconds
TLDR Hannes asked how to change table headings and convert durationnano to seconds, Srikanth recommended using a formula for conversion and "Legend" for formatting. Later Hannes clarified the issue was resolved.
Sep 05, 2023 (3 weeks ago)
Hannes
07:04 PM
Sep 06, 2023 (3 weeks ago)
Srikanth
08:00 AMUse the Legend formatting option
> how can I convert durationnano into seconds
Cumbersome but you can use formula.
Hannes
10:40 AMB/1000000 results inAPI responded with 400 - encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of queryHannes
10:42 AM{{tag_messaging.sidekiq.job_class}} , {{sidekiq.job_class}} & {{job_class}} none of which resulted in the class name to be used. What should I be using?Srikanth
10:42 AM{{messaging.sidekiq.job_class}}Srikanth
10:43 AMSrikanth
10:44 AMB/1000000 results inCan you share the full API response?
Hannes
10:45 AM{"status":"error","data":{"F1":"SELECT B.messaging.sidekiq.job_class as messaging.sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class`, quantile(0.99)(durationNano) as value from signoz_traces.distributed_signoz_index_v2 where (timestamp \u003e= '1693993539000000000' AND timestamp \u003c= '1693997100000000000') AND has(stringTagMap, 'messaging.sidekiq.job_class') group by `messaging.sidekiq.job_class` LIMIT 100) as B "},"errorType":"bad_data","error":"encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query"}Hannes
10:47 AMHannes
10:57 AM
SigNoz Community
Indexed 825 threads (61% resolved)
Similar Threads
Incorrect Alert Firing Issue in Threshold Condition
Harshith.R.S is experiencing an issue with alerts firing when the value is above the threshold. The issue remains unresolved after trying different query modifications suggested by Amol.
1Resolving 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.
Headers in Monitoring HTTP Endpoints & Otel-Collector Error
Rohit asks about providing headers in monitoring HTTP endpoints and reports errors in otel-collector logs. Srikanth mentions headers are unsupported and requires more investigation for errors.
Forwarding Exception Alerts from Rails to Mattermost
Andreas needs guidance setting up exception alerts in Rails to Mattermost. Amol provides a sample query and explains the setup process.
Bug Identified in Exception Screen on Fresh Install
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