Final, Final Edit: If the system runs out of disk space, and the table rebuild fails, it will try again in 2024.8.1 or later see Recorder still locking up even after update to 2024.8.0 · Issue #123348 · home-assistant/core · GitHub Ensure legacy event foreign key is removed from the states table whe…

There’s 2 separate issues. Which one do you have? This thread was created to address issues caused by custom integrations that @tom_l has highlighted. Separately, there’s an influx of people who have a separate (older) issue related to purge that will be addressed in 2024.8. That issue was not c…

Will it (it being the SQLite DB rewrite) really be merged in 2024.7.2? The github issue still refers it to be a fix for 2024.8. Smart fix for the custom integrations :slight_smile:

Thanx for pointing out the temporary solution. I added the lines to my configuration.yaml Now I have seen that Frenck is working on a 2027.2 update. I wonder if that solves the problem. Do I have to delete the lines in my configuration.yaml after updating to 2027.2?

Yes, see: Remove legacy foreign key constraint from sqlite states table home-assistant:dev ← home-assistant:sqlite_fix_fk opened 06:09PM - 28 Jun 24 UTC (UTC) …

Wonderful! :star_struck: This is very good! Thanks for the link and confirmation.

[image] PV-Joe: Do I have to delete the lines in my configuration.yaml after updating to 2027.2? Yes you do.

[image] Release 2024.7.2 · home-assistant/core Remove legacy foreign key constraint from sqlite states table (@bdraco - #120779) (recorder docs) Direct Users to App-Specific Passwords for iCloud integration to prevent MFA spam (@rcmaehl - #1209... Done. …/Fr…

I’ve read the release note. Is this going to result in a full states table rebuild for those of us on mariadb as well? It’s difficult to find any information because only sqlite has been mentioned in all the talk about this bug (and mariadb as far as I can tell from my own instance doesn’t seem to h…

Thats good news, thanks! I’ve two questions: is it possible to reactivate icloud3 again without locking up the database because just the requests are blocked? And: if I would migrate from SQLite to MariaDB or Influx, would that help as well? Thanks in advance.

The problem was unique to SQLite and did not affect MySQL/maria/postgresql so there is no table rebuild for those engines. The SQLite states table rebuild does not increment the schema version since it’s not a change in schema, its only a table rebuild to remove the old legacy schema that some syst…

Thanks for confirming that, and providing a bit more insight into things. You’re a star.

PSA: 2024.7 recorder problems

Configuration

frenck (Franck Nijhof) July 10, 2024, 11:21am 76

Done.

…/Frenck

The recorder backlog queue reached the maximum size