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)
proposal: cmd/cgo: cgo without a C toolchain
Replace PowerToys Run with Command Palette
VPS with a vRack leg
Possibility of Portal 1 Code Inclusion
Introducing NewPlayer
Metrics for PRs are never expiring ("memory leak")
ship even more of the compiler in source form
Flatpak Application TRACKING ISSUE
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
Comments (0)
No comments yet. Start the discussion.