Home assistant installation broken after blackout

I had an power blackout. After the blackout the most things don’t work anymore.
I can see the integrations in the overview dashboard. But I can’t edit the config, can’t update anything, can’t open comand line and so on.

Following error messages:
opening file editor: Unable to load the panel source: /api/hassio/app/entrypoint.js.
opening terminal: Unable to load the panel source: /api/hassio/app/entrypoint.js.
config check: File configuration.yaml not found.

I have the following confoguration:

  • Core 2024.12.3
  • Supervisor 2024.11.4
  • Operating System 14.0
  • Frontend 20241127.8
    Raspi 5 with SSD

In error log I can find some errors:

Logger: homeassistant.components.recorder.util
Quelle: components/recorder/util.py:299
Integration: Recorder (Dokumentation, Probleme)
Erstmals aufgetreten: 15. Dezember 2024 um 14:56:13 (1 Vorkommnisse)
Zuletzt protokolliert: 15. Dezember 2024 um 14:56:13

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly

Logger: homeassistant.components.recorder.core
Quelle: components/recorder/core.py:882
Integration: Recorder (Dokumentation, Probleme)
Erstmals aufgetreten: 06:45:57 (1 Vorkommnisse)
Zuletzt protokolliert: 06:45:57

Unrecoverable sqlite3 database corruption detected: (sqlite3.DatabaseError) database disk image is malformed [SQL: UPDATE states SET last_reported_ts=? WHERE states.state_id = ?] [parameters: [(1734327935.3376791, 214333), (1734327935.337763, 214334), (1734327935.3378067, 214335), (1734327935.3378437, 214336), (1734327935.3378808, 214337), (1734327935.3379161, 214338), (1734327935.3379507, 214316), (1734327935.3379786, 214339)]] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)

Can you help me to fix that? Is it possible to restore yaml file and so from it’s original version?

Thanks a lot.

I have not had this type of failure in long time. Deleting the SQL home-assistant_v2.db file and rebooting fixed it for me in the past. Just remember your historical logs/data gets deleted doing this.

1 Like

Restore using your most recent backup

I can’t delete files. Terminal or file editor is not working.
There are also no backup. Just startet with that home assistant some days ago.
Is there a way to subsitude files like db or config.yaml with files from a fresh installation?