I used the energy monitor to help collecting electricity usage in my home office. Something very weird happened in the month of Dec and it happened multiple times already - the “sum” from the “statistics” table jumped without any reason. I have included two screenshots from sqlite browser examining the table.
In the attached screenshots, the device (ID 52) is the z-wave outlet’s sensor that output accumulative total kWh. Therefore, the “sum” column should be the same as the “state” column. It is fine for the past 3-4 months until Dec 6, it jumped from 19.52 to 170.11 without any change from the value reported by the sensor. It jumped again on Dec 21 from 17.62 to 1073766658.82 without any reported change in the total consumption from the sensor. There are couple other jumps after that but I did not include them in this posting.
I understand that I can update the table (and did it already on my production system) but is there any reason why it jumped? Any help is very much appreciated!
P.S. if I posted to the wrong category, please let me know which one I should post this question. Thank you!
P.P.S. I also noticed the “statistics_short_term” table’s entries are all incorrect as well, and based on description I gathered, it is being used as short term cache for the hourly calculation. I updated the entries there manually in my production system as well (I shutdown HA before I update the tables).
