Hello Community.
Docker version of Grafana - v11.1.0
Docker version of InfluxDB - v2.7.6
I have multiple buckets and have created a “dynamic” dashboard so that I can easily switch between hosts/databases.
To do this, I created a query type variable named “source_bucket” to select buckets, like so:
buckets()
|> filter(fn: (r) => r[“name”] != “_monitoring”)
|> filter(fn: (r) => r[“name”] != “_tasks”)
After that, I created a new query type variable named “sql_instance” that calls on the selected value from the first variable, and lists SQL instances, like so:
from(bucket: “$source_bucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “sqlserver_performance”)
|> keep(columns: [“sql_instance”])
|> group()
|> unique(column: “sql_instance”)
Until recently, it worked without problems, but today I am unable to get any results from the second query.
Running the first query, I am getting the list of buckets, so the variable is being populated, but at any time that I am running the second query, I get blank results.
There were no updates to the docker images made recently, and I did a stop/start cycle of the images, but that did not resolve the issue.
What would be the cause of this issue?