GNU bug report logs - #36687
guix gc: error: executing SQLite statement: database disk image is malformed

Previous Next

Full log

Message #26 received at 36687 <at> debbugs.gnu.org (full text, mbox):

From: pkill9 <pkill9 <at> runbox.com>
To: 36687 <at> debbugs.gnu.org
Subject: guix gc: error: executing SQLite statement: database disk image is
 malformed
Date: Sat, 30 Dec 2023 02:25:49 +0000

[Message part 1 (text/plain, inline)]

Hi, I fixed this issue using sqlite3's built-in recover command:

sudo mv /var/guix/db/db.sqlite /var/guix/db/db.sqlite.bak
sqlite3 /var/guix/db/db.sqlite.bak ".recover" | sudo sqlite3 
/var/guix/db/db.sqlite

Solution was found at 
<https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/57872238#57872238>

[Message part 2 (text/html, inline)]

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.