Hi guys,
I am again a bit struggling with database entries related to energy consumptions. Although state values seems to be ok (in statistics_short_term table, measuring kwh consumtion), sum column contains in rare cases not just variance in state column but addition of the whole state value to previous sum (i.e. doubleing the consumption), then it goes again fine and after some random time the same.
I assume that sum is generated automatically by HA, i.e. is it a bug? Shall I open it on github?
Below is an example of the output… I am running version 2022.2.9
| id | metadata_id | created | state | sum |
|---|---|---|---|---|
| 805072 | 29 | 2022-03-09 02:40:10.212482 | 13472.49 | 14062.169999999998 |
| 805158 | 29 | 2022-03-09 02:45:10.240479 | 13472.57 | 14062.249999999998 |
| 805244 | 29 | 2022-03-09 02:50:10.234776 | 13472.64 | 14062.319999999998 |
| 805330 | 29 | 2022-03-09 02:55:10.221820 | 13472.73 | 14062.409999999998 |
| 805416 | 29 | 2022-03-09 03:00:10.267149 | 13472.81 | 14062.489999999998 |
| 805502 | 29 | 2022-03-09 03:05:10.244628 | 13472.9 | 14062.579999999998 |
| 805588 | 29 | 2022-03-09 03:10:10.245962 | 13472.98 | 14062.659999999998 |
| 805674 | 29 | 2022-03-09 03:15:10.241821 | 13473.06 | 14062.739999999998 |
| 805760 | 29 | 2022-03-09 03:20:10.294412 | 13473.14 | 27535.92 |
| 805846 | 29 | 2022-03-09 03:25:10.231938 | 13473.22 | 27536.0 |
| 805932 | 29 | 2022-03-09 03:30:10.222656 | 13473.31 | 27536.09 |