database disk image is malformed sqlite repair

I ran a “pragma integrity_check ” on it and several findings were returned: So I decided to go the hard, not that quick way to keep my database (took me 10 to 15 minutes, saving many days of data): So currently that´s not a reliable backup and restore progress at all. You never know when you´ll need to restore a snapshot, that´s what backups are for: being prepared for the worst case.

Especially when you´re not yet into putting medium and long-term data in e. I was really wondering how everyone can accept the “just delete that damn sqlite db and your good to go!” workaround so all history data is gone.įor me personal it´s just not acceptable to loose all my history data every now and then.

The “solution” (in my opinion a workaround, at best) proposed in almost all those topics: delete the database, start from scratch. 16:08:43 ERROR (SyncWorker_6) Error executing query: (sqlite3.DatabaseError) database disk image is malformedĪs I was searching the HA community I quickly discovered this is a common issue, there are lots of topics related to this problem, seems to be a MASSIVE one. : (sqlite3.DatabaseError) database disk image is malformed Either during backup (creating the snapshot) or restore process. I tested it several times, in every test case the SQLite database got corrupted.

This leads so error messages and not functional Home Assistant (history graphs not generated/shown, sensor state changes aren´t stored etc.). The home-assistant_v2.db from a restored snapshot is malformed or corrupted. I restored a snapshot when switching hardware / sd card (HASS OS on Pi 2 B 32 bit to HASS OS on Pi 3 B+ 64 bit).

Database disk image is malformed sqlite repair