For the last couple of weeks I am having the issue that the energy dashboard shows ONE totally off value between 4 and 5 am which destroys the whole dashboard and statistics:
But it happens every night between 4 and 5 am - does anyone have an idea what that could be - I have prepared a cron-job deleting negative values between that timeframe and started testing it but would like to actually solve the root cause of it…
So I double checked again - the history graphs of all sensors are correct - only in the dashbboard it shows wrong - I think there the statistic values are used - they are wrong - why I do not know:
So here for examle - Grid Import - all of the sudden at 4:10 am - the import was minus 64,34 - so a negative value…
Still noone with an idea why that happens ? It really happens almost every night now and with all “Energy” sensor - so now even my watermeter reports every night that I have “exported thousands of liters to the grid” Can I somehow delete the whole LTS and also if needed the history - I am now so frustrated that I even would delete all data from the last years to get a clear picture - with these wrong values in the dashboard, it becomes totally useless
I have the same problem. I have nothing changed the last few months except updating home assistant and suddenly it behaves like this so i am pretty sure that’s another bug.
Just a thought from a novice. Maybe the database purge isn’t working correctly.
You could try TEMPORARILY disabling the purge to see what happens. See: Recorder Integration
FYI I use MariaDB rather than the default SQLAlchemy. Also, lot of folks using RPi’s have issues with SD card memory. Here is an article on Maria DB: Optimize Your Home Assistant Database