Grafana doens't find my data in Influxdb | Home Assistant | Page 1

sand birch Sep 16, 2024, 2:44 PM

#

Hi, i migrated my HAOS from the Pi4 to a VM on Virtualbox in order to keep only MQTT and Z2M on the Pi4. For that i did a backup of HAOS and restore on the VM. Its was working fine but after 2/3 days my Grafana is saying NO DATA in each graph on my dashboards. I have the feeling that Influxdb has disappeared or ins not found now. I tried to create a database with the same name, user, pwd, in Influxdb, and Grafana finds again the sensors but without any historic data, so it seems that i lost the history for all my sensors in Influxdb. Any idea of what is happening here and how i can solve it and get back my history ?

scenic aurora Sep 17, 2024, 6:43 AM

#

Have you updated the influxdb configuration on HomeAssistant

sand birch Sep 17, 2024, 8:58 AM

#

But it didn't change as I restored the backup which contained everything, ha and influxdb, in the same place. And after that it was working during about 1 day and then stopped. I have another issue also, ha is crashing, don't know why up to now, maybe its linked.

hollow hill Sep 18, 2024, 1:22 PM

#

I've had issues with Grafana where the sql by default gets a Top or First constraint added automatically, and that limits data in charts. I needed to edit the sql manually. Maybe you're encountering something similar resulting in no data due to a condition being added?

sand birch Sep 21, 2024, 2:07 PM

#

now it is again working with the data collected since the restart of Influxdb, but i lost all Influxdb data before that moment. I still have backups of the previous Influxdb, maybe there could be way to integrate these previous data in the current Influxdb ? But if exist and its a complex process not sure if i will try...

scenic aurora Sep 21, 2024, 2:49 PM

#

You can export and import them, it's a bit of a trick tho

#

Also depends on your db version

hollow hill Sep 22, 2024, 3:26 AM

#

Another approach could be to union the old table with the new one, that is concatenate them, using a sql query

scenic aurora Sep 22, 2024, 8:04 AM

#

Influxdb is not sql

#

You can try aggregation with continuous queries but the specifics depend on your selected version

hollow hill Sep 22, 2024, 2:17 PM

#

scenic aurora Influxdb is not sql

Apologies. I was thinking about MariaDB.

#Grafana doens't find my data in Influxdb