Hello!
To start, I am new to InfluxDB so I will try my best to explain the situation, but bear with me if I get terminology wrong or have trouble explaining some aspects.
I am running InfluxDB v2.7.11 (Server: fbf5d4a Frontend: f4b5694)
I have a VyOS instance configured to send metrics to a dedicated InfluxDB bucket. I’ve been able to put together queries to build graphs for throughput of various interfaces using Grafana. However, for one specific interface, I am running into a problem where if the time range starts on or after 2025-03-10T00:00:00Z the query returns zero results. If the time range starts on or before 2025-03-09T23:59:59Z I can see all data up to current.
The full query is as follows:
from(bucket: "vyos")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["host"] == "va1-fw0" and r["interface"] == "wg4242" and r["_field"] == "bytes_recv")
|> derivative(nonNegative: true)
|> map(fn: (r) => ({r with _value: r._value * 8.0}))
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
I can perform the following query in the Data Explorer and see that data from 2025-03-10 to current is, in fact, there, and the number of data points the problematic interface has is equal to the number of data points other interfaces without this problem have.
from(bucket: "vyos")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["host"] == "va1-fw0" and r["interface"] == "wg4242" and r["_field"] == "bytes_recv")
When I use the Inspect Query feature in Grafana it shows that it’s receiving a 200 status from InfluxDB and that it simply just didn’t receive any results. The InfluxDB Data Explorer seems to indicate the same. I’m not seeing anything unusual in the InfluxDB log either.
I can run the above queries against any other interface with any time range and I get the expected results, the issue is just limited to a specific interface.
Any ideas?
