Hi,
Homeassistant had been working fine but today I realised it became laggy so I looked in the logs and there have been a shitload of errors, one saying “The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly”.
Because there had been a lot of other errors, I wanted to restore a backup, but no backups showed up in Homeassistant! I configured automatic backups once a day, but the destroyed system doesn’t seem to find them…
As Homeassistant is running under proxmox and I also have daily backups of every proxmox-container, I restored one of these, but the above (and all other errors) showed up again!
I restored backups from 2 and 3 days ago, but they always give me the same error!
Is it because of a confusion of the database because of the missing days since the backup?
What can I do? Help!
You can delete the database file (home-assistant_v2.db) before starting up HA. A new one will be created when HA starts. Of course you lose your history, so this is less than ideal if you were counting on HA to maintain your long-term statistics.
Be safe although it seems you have many copies of that .db … back it up first (or rename) then restart.
This is a common warning due to HA not shutting down many machines in the right way.
It simply kills the process at one stage and that is before the DB connection is closed.
Especially RPis get this warning, but it is not exclusive to them.
It is just a warning and often nothing happens.
Rarely a DB might get corrupted and then the corrupted is moved to a backup file and a new one is created.