Home Assistant has stopped recording Histories

[tom1502 (Tom O'Donovan)]

Good morning,

I’ve found that Home Assistant has stopped recording the history of all devices after 3rd July. I noticed at first that my Energy Dashboard was not retaining any data, then watched as History graphs show no history but started to record data while I was observing them. If then navigate away from the dashboard and then return there is no data recorded.

I’m attempting to restore a backup from last week, prior to updating to 2024.7 but has anyone else encountered this?

I’m running a Home Assistant Yellow with an SSD. The SSD is working, that’s where the backups are stored, so I’m not sure what’s happened. I’ve not changed anything in Home Assistant, other than updating to 2024.7.

Thanks,

Tom

[francisp (Francis)]

See this link:

PSA: 2024.7 recorder problems

There are two issues that may affect your recorder in this release. ISSUE 1: If your recorder is stopping every morning at a bit past 4am, it is this issue: Purge causes recorder to stop writing to the DB until HA is restarted (Auto purge happens at 4:12am) · Issue #117263 · home-assistant/core · GitHub the fix for this will be released in version 2024.8 hopefully be released in a patch soon, until then disable recorder auto purging: configuration.yaml recorder: auto_purge: false ISSUE 2: …

[tom1502 (Tom O'Donovan)]

Thanks, I’ll check it out.

[Ellcon]

I had the same issue. I stopped HA and copied the database to a Windows pc. Then used sqlite3 to repair the database which found a few errors. Been recording fine now for 2 days. Procedure is in the 2nd post;

Restore corrupt database after nightly purge

Hi all, Hopefully someone can help me. My database gets corrupted every night at 4:12 during the auto purge. I did a integrity check using DB Browser for SQLite and it found 3 issues. My primary concern is my long term energy data I need to conserve, the other data points I can live with losing. Conceptually I’d say I have 2 options, either fix this DB or add the energy data to the new DB. Is there anyone that can help me fix this, ideally with a step by step approach. I have some computer/I…

[Ellcon]

I should add that there are other reports of a conflict with certain integrations causing this problem so it may not be your solution until next release.

[tom1502 (Tom O'Donovan)]

The solution suggested in the other post worked. I removed the icloud add-on, restarted and it’s all back to normal.

I appreciate the help.

[tom1502 (Tom O'Donovan)]

Hi,
I realise this was resolved before, but it’s happened again. I’ve not put the old add-on back, if anything I’m trying desperately to remove any that aren’t being used. I’ve lost my database so decided to switch to MariaDB to see if it would help. Nothing still no history being recorded and Home Assistant is running so slowly it’s beyond belief. It’s come out of nowhere. I had a couple of updates last night, which seem to be the root cause. I ended up rolling back to the back-up from yesterday; which I thought had worked. However, it’s just got worse as the day has gone on. Loading the dashboards takes a long time, if they load at all. I cannot get into Home Assistant from iPhone or iPad apps, they hang and then CTD. These were only small updates to Better Thermostat, Octopus Energy and Alexa Media Player.

I’m at the point that I think I may as well wipe my Yellow and start again. It’s just fallen flat on its face and I’ve no idea why. There still seems to be plenty of headroom for the CPU and there is still about 20% of the RAM available. Something has gone very wrong, but I don’t know where to start.

Does anyone have any tips?