I don’t have any idea of the solution, but I do have the same problem. I’m running Home Assisant 2022.12.8 on an ODROID X2 with it’s database on a Synology NAS. I use a SlimmeMeter to measure my energy and gas usage. That runs fine for a couple of days and then suddenly my Energy dashboard for the day is empty. When I perform a restart all the missing data is added to the current hour, causing huge spikes in my usage.
Since I also use a SlimmerMeter+ with DSMR Reader I still have the data I need, but it would be nice to have the same information in Home Assisant as well in a way I can trust it.
Hopefully this sparks a brainwave somewhere about what the issue could be.
I recently switched from homeassistant install in docker on my Synology NAS to a Rasperry Pi with an attached SSD.
Since then, i never had this problem again.