I have something to the 2024.7 database problem but it only started for me in 2024.8[.1] - whenever purge runs the recorder stops recording history (data ‘flatlines’). I’m using PostgreSQL as the backend via the TimescaleDB addon. I verified my DB schema has been migrated successfully, checked that all my integrations are updated.
It’s only “flatlining” after purge runs - automatically at 4:12 AM or manually by running recorder.purge. I don’t see any log errors or warnings indicating a problem (I turned up homeassistant.components.recorder to debug and it looks ok during a purge). I just turned off auto purge to work around it but am hoping there’s something else I can investigate to find the cause.
Is there something I can check? Logs don’t seem to help, but I can trigger it by running a purge manually - as soon as I do state change events aren’t recorded.