Running Grafana 8.0.2 on Debian GNU/Linux 11 (bullseye) on RaspberryPi
InfluxDB shell version: 1.8.4
I’m trying to get Grafana display data from InfluxDB using my own retention policies
I’ve created some new retention policies (RP) in InfluxDB and added data to them using some aggregation functions. I have verified whether there is data in there. And previously I could also just display data from the default RP (autogen) in Grafana.
When I now create a new graph or try to ‘Explore’ my data in Grafana, the ‘from’ is showing ‘Default’ and a concatenation of all current RP’s as retention policy, but then complaining these do not exist.
I had expected the different RP’s to show in the ‘from’ pull down menu, allowing me to select the RP from which I wanted to select the measurement.
My retention policies:
> show retention policies on domoticz
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
autogen 0s 168h0m0s 1 true
three_months 2400h0m0s 24h0m0s 1 false
five_years 44520h0m0s 168h0m0s 1 false
infinite 0s 168h0m0s 1 false
Verified there is data in the retention policy:
> select * from "domoticz"."three_months"."Power_UsageHigh" order by time DESC limit 10
name: Power_UsageHigh
time max
---- ---
1680858240000000000 11368878
1680857580000000000 11368875
1680857160000000000 11368872
1680857040000000000 11368871
1680856980000000000 11368866
1680856920000000000 11368865
1680856860000000000 11368863
1680856800000000000 11368862
1680856740000000000 11368860
1680856680000000000 11368858
> select * from "domoticz"."five_years"."Power_UsageHigh" order by time DESC limit 10
name: Power_UsageHigh
time max
---- ---
1680854400000000000 11368875
1680850800000000000 11368750
1680847200000000000 11368541
1680843600000000000 11368280
1680840000000000000 11367925
1680804000000000000 11367923
1680800400000000000 11367505
1680796800000000000 11367022
1680793200000000000 11366425
1680789600000000000 11366281
The query window in Grafana now showing the following when trying to select the correct RP:
What am I missing here? This is the first time I work with my own retention policies, but can’t seem to get it working.
Many thanks in advance for your support!