After upgrading my HA installation to 2022.12 I have seen a strange behaviour when opening some of the sensor history (not all, only detected some sensors related to the system - cpu, memory, etc):
When I open the processor usage the new window shows data from today (december 2022) to a future date (april 2023):
Tried purging the recorder data, the entity data and no luck.
Strangely, when opening the history viewer (Show more) and selecting the time range in the future no data is shown:
I have upgraded recently to 2012.8 but the problem persists: for some sensors there is shown historical data from today, then a gap and then data from april’23.
Is someone else experiencing this behaviour? Should I open an issue on github?
Updating just in case someone suffers this sometime:
Solved the issue cleaning the records with future date in the MariaDB with phpmyadmin, in the tables: statistics_short_term, statistics_runs, events and state_changes. The definitive one was statistics_short_term
Hey… I’m also having this issue but I’m not using MariaDB… any indications on how to do it? I know that the suggestion will be to start using MariaDB, but that means losing all my current stats right?
I’m not aware if the sqlite db supports deleting records, it probably would allow editing it offline with some tool.
