emefff
January 14, 2024, 1:59pm
5
In the meantime I dowloaded the db file and tried the following on the host machine:
@eddriesen thanks for this! Unfortunately like some others, I was getting a 0 byte fixed database with this method. Using the newer sqlite3 (v3.29.0+) .recover command though, I managed to retrieve a sizable amount. Leaving this here for others (and myself inevitably) in the future:
sqlite3 ./home-assistant_v2.db ".recover" | sqlite3 ./home-assistant_v2.db.fix
mv ./home-assistant_v2.db ./home-assistant_v2.db.broken
mv ./home-assistant_v2.db.fix ./home-assistant_v2.db
I cannot even execute the first command successfully
sqlite3 ./home-assistant_v2.db ".recover" | sqlite3 ./home-assistant_v2.db.fix
it leads to an ‘out of memory’ error. Then I tried the same on a machine with 384GB RAM and got the same error. What a load of crap. This is getting ridiculous.