I have experienced several times where utility meters get ruined by rogue readings.
On my heatpump after on occasional reboots of the heatpump (reqired after configm changes) the power meter from (PZEM-004) registers in the megawatts momentarily.
As i run daily, monthly and yearly stats this corrupts all three and seems to be irrecoverable.
I can edit the statistics and then correct the current state on the entities for only a short time as this only corrects things till a restart of HA or a rerun of the statistics generation process on the hour.
The only fix is to roll back the database.
- Am i doing something wrong here, or does the ability to correct statistics not work?
- How on earth are the current stats cached after a removal of the table and a reboot?
In this graph, i have removed the utility “monthly daikin energy”,
restarted HA,
removed this table from the db,
restarted HA
re-added utility meter
restarted HA
then the table entry “monthly daikin energy” gets repopulated with a massive entry: