HA crashes every few hours

[MaxK (Mark)]

Perhaps delete the database and let it rebuild from scratch?

Upgaded to 2025.1.4 but sqlite database seems to have failed to upgrade, now nightly purge fails preventing new data to be stored

There was a database change or two around then. If people ran out of room or had a big database and didn’t want to wait for it to finish the migration, then interrupted it, shit happened. I know not everyone agrees, but the HA database is for runtime data. Long term data should be stored elsewhere. If your database is over 2gb rethink your options and delete it. You have a (usually) small CPU and big databases slow stuff up, so keep your long term and working data separate. My opinion, but it h…

Edit: also, can you post the output of

Settings → system → repairs → [three dots upper right] → system information