IssueRaiser

maximum of series (500) reached for a single query

**Describe the bug** I am trying to collect Netflow using Loki. I am trying to create a "Top 10 Destinations" panel. The query has a large number of different series, and I get the error mentioned in the title. **To Reproduce** ```sum by (SrcAddr,DstAddr) (sum_over_time({job="netflow", SrcAddr=~"$srcaddr", DstAddr=~"$dstaddr", SamplerAddress=~"$exporter", Proto=~"$protocol", DstPort=~"$dstport"} | json | unwrap Bits[$__interval]))``` **Expected behavior** I would expect it to return the first 500 series rather than just completely error out. I'm not sure how I can get around this? In order to calculate the top 10, I need to get all the values and then figure out which ones are largest. I know that Loki includes a ```topk``` function, but that calculates based on each interval, not on the total over the whole time range **Environment:** Grafana Cloud

Posted by loganmc10 on Dec 6, 2020, 5:20 PM

Tags

Related issues

Raise real-world problems, find people facing the same issue, and discuss solutions.3,000 issues0 comments

github (E-commerce)

maximum of series (500) reached for a single query

loganmc10Dec 6, 2020, 5:20 PM

**Describe the bug** I am trying to collect Netflow using Loki. I am trying to create a "Top 10 Destinations" panel. The query has a large number of different series, and I get the error mentioned in the title. **To Reproduce** ```sum by (SrcAddr,DstAddr) (sum_over_time({job="netflow", SrcAddr=~"$srcaddr", DstAddr=~"$dstaddr", SamplerAddress=~"$exporter", Proto=~"$protocol", DstPort=~"$dstport"} | json | unwrap Bits[$__interval]))``` **Expected behavior** I would expect it to return the first 500 series rather than just completely error out. I'm not sure how I can get around this? In order to calculate the top 10, I need to get all the values and then figure out which ones are largest. I know that Loki includes a ```topk``` function, but that calculates based on each interval, not on the total over the whole time range **Environment:** Grafana Cloud

Comments (0)

No comments yet. Start the discussion.

Comment on this issue