https://signoz.io logo
Join Slack
Powered by
Hello! I've been using SigNoz for about 18 months ...
# support
j
Hello! I've been using SigNoz for about 18 months self hosted and love it. I now need to use Tags on Metrics to surface some data in a dashboard. I can't see how to do 'Group By' on the Metrics Dashboard, so I can split by Tags? I have 'Type' as a tag on my Metric, and want to split the count on the graph. However I can't see how to do this, everything I try gives me 500 response. 
API responded with 500 - Something went wrong status: error in builder queries
Many thanks for the excellent product!
Here is the error log:
Copy code
ERROR clickhouseReader/reader.go:4688 > timestamp=2025-03-31T21:07:43.053Z msg=error while reading result error=code: 173, message: Couldn't allocate 449 bytes when parsing JSON: while executing 'FUNCTION JSONExtractString(labels :: 1, 'type' :: 2) -> JSONExtractString(labels, 'type') String : 3' stacktrace=<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.getPersonalisedError|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.getPersonalisedError>
	/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4688
<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.readRowsForTimeSeriesResult|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.readRowsForTimeSeriesResult>
	/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4525
<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetTimeSeriesResultV3|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetTimeSeriesResultV3>
	/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4608
<http://go.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).execClickHouseQuery|go.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).execClickHouseQuery>
	/home/runner/work/signoz/signoz/pkg/query-service/app/querier/v2/querier.go:117
<http://go.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).runBuilderQuery|go.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).runBuilderQuery>
	/home/runner/work/signoz/signoz/pkg/query-service/app/querier/v2/helper.go:268

INFO utils/time.go:17 > timestamp=2025-03-31T21:07:43.053Z msg=Elapsed time func_name=GetTimeSeriesResultV3 duration=16 path=/dashboard/ec56ae28-916b-455e-ac6a-ef829ab408fb/new source=dashboards client=browser dashboardID=ec56ae28-916b-455e-ac6a-ef829ab408fb alertID= viewName= query=SELECT type, ts, sum(per_series_value) as value FROM (SELECT type, ts, If((per_series_value - lagInFrame(per_series_value, 1, 0) OVER rate_window) < 0, nan, If((ts - lagInFrame(ts, 1, toDate('1970-01-01')) OVER rate_window) >= 86400, nan, (per_series_value - lagInFrame(per_series_value, 1, 0) OVER rate_window))) as per_series_value FROM (SELECT fingerprint, any(type) as type, toStartOfInterval(toDateTime(intDiv(unix_milli, 1000)), INTERVAL 60 SECOND) as ts, max(value) as per_series_value FROM signoz_metrics.distributed_samples_v4 INNER JOIN (SELECT DISTINCT JSONExtractString(labels, 'type') as type, fingerprint FROM signoz_metrics.time_series_v4 WHERE metric_name IN ['userexchangegrain_stream_userexchangeupdates'] AND temporality = 'Cumulative' AND __normalized = true AND unix_milli >= 1743451200000 AND unix_milli < 1743455220000) as filtered_time_series USING fingerprint WHERE metric_name IN ['userexchangegrain_stream_userexchangeupdates'] AND unix_milli >= 1743453360000 AND unix_milli < 1743455220000 GROUP BY fingerprint, ts ORDER BY fingerprint, ts) WINDOW rate_window as (PARTITION BY fingerprint ORDER BY fingerprint, ts)) WHERE isNaN(per_series_value) = 0 GROUP BY type, ts ORDER BY type ASC, ts ASC servicesTab=
I am using C#, and sending data like such:
Copy code
var _meter = new Meter($"MyCounters");
var counter = _meter.CreateCounter<int>("userexchangegrain.stream.userexchangeupdates");
counter.Add(1, [
    new KeyValuePair<string, object?>("type", "example")
]);
s
n
Hey @James Carter, just checking in—were you able to get the issue resolved?
j
Hey @Nagesh Bansal No, I gave up after a while and just exported metrics another way to fix my problem. I've just tried again now, updated the following: Dumped signoz DB Pulled latest main signoz (84.1) Updated portainer (docker host) Updated proxmox (VM host) And I still get this same error from clickhouse trying to allocate to parse the JSON from the metric tags.
Okay, I ended up resolving this for me by changing the CPU Type on my proxmox for my docker host, from 
x86-64-v2-AES
to 
host
Now I can succesfully query metrics by labels!
9 Views
Open in Slack
PreviousNext
Powered by