Randomly missing data in DB (internal SQlite & influxdb)

Fathermck · January 24, 2023, 9:41am

Hi there…
I have the same problem. It seems some datas are not recorded or lost when diplayed with grafana. Any solution ?

Is it possible to escalate this issue to the HA technical team ? Because grafana is useless if there is no easy solution.
Thanks.

AlfaJackal · May 10, 2023, 9:18am

The problem here is that Home Assistant only sends data to Influx if the sensor changes. I am having the same issue and no solution…

fill(previous) does not work because there isn’t even a ‘null’ value:
https://docs.influxdata.com/influxdb/cloud/query-data/flux/fill/

Andrejs · July 6, 2023, 10:58am

I had the same issue!
Yeah it’s seams that if the “value” is not changed the InfluxDB doesn’t not store it.
By default it FILL missing data value to NULL
You can change to FILL → Previous