Everything’s been working fine for the last year or so.
But sometime around installing the 2024 update (not sure if it’s releated), HomeAssistant has stopped updating graphs every night around 4 AM pacific time.
Here is a good example:
When this happens, the actual numbers in the dashboard are correct–it’s just the graph that flatlines.
Restarting Home Assistant or rebooting the VM returns things to normal:
My sqlite database is huge. I think that may be part of the problem.
At one point I modified the config file to save a year of stats, then a few months ago when I kept running low on space, I removed the config option and restarted the VM. The database is still huge, so I tried going into developer tools and running the recorder purge, but that had no effect on the side of the sqlite file.
I haven’t noticed anything interesting in the error logs when this happens.
Any ideas on what I should try?