From mboxrd@z Thu Jan 1 00:00:00 1970 From: Chris Marusich Subject: bug#36687: guix gc: error: executing SQLite statement: database disk image is malformed Date: Thu, 18 Jul 2019 22:30:11 -0700 Message-ID: <87pnm6egm4.fsf@gmail.com> References: <87v9w2ctpm.fsf@gmail.com> <87tvbmgndy.fsf@elephly.net> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:59135) by lists.gnu.org with esmtp (Exim 4.86_2) (envelope-from ) id 1hoLU1-0006Vj-SQ for bug-guix@gnu.org; Fri, 19 Jul 2019 01:31:07 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hoLTz-0000Q5-Kf for bug-guix@gnu.org; Fri, 19 Jul 2019 01:31:05 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:46176) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1hoLTy-0000P8-IA for bug-guix@gnu.org; Fri, 19 Jul 2019 01:31:03 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1hoLTy-0007DN-DB for bug-guix@gnu.org; Fri, 19 Jul 2019 01:31:02 -0400 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: <87tvbmgndy.fsf@elephly.net> (Ricardo Wurmus's message of "Tue, 16 Jul 2019 14:44:09 +0200") List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org Sender: "bug-Guix" To: Ricardo Wurmus Cc: 36687@debbugs.gnu.org --=-=-= Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Ricardo Wurmus writes: > Chris Marusich writes: > >> My disk was filling up, so I tried to run "guix gc", but I got an error >> instead: >> >> --8<---------------cut here---------------start------------->8--- >> $ guix gc -C 25GiB >> ... >> deleting `/gnu/store/n0gyzfw77ik35ld9d0d4737w88f11m4b-profile.drv' >> deleting `/gnu/store/fl7w0dlki7c906isiiflf9ka4c49zcmi-ca-certificate-bun= dle.drv' >> deleting `/gnu/store/ipn4xvvb3wrbx4lhzwdyyylvj42vyg6f-xdg-desktop-databa= se.drv' >> guix gc: error: executing SQLite statement: database disk image is malfo= rmed >> --8<---------------cut here---------------end--------------->8--- >> >> What does this mean? > > I think this means that the database has been corrupted. I ran it a second time. It printed more messages, but curiously it errored out after saying that it deleted another xdg-desktop-database.drv: =2D-8<---------------cut here---------------start------------->8--- $ guix gc -C 25GiB ... deleting `/gnu/store/d5z2lazx11qz571mwy59gwlqxidj0h4r-gtk-im-modules.drv' deleting `/gnu/store/gc36aax38fs194ll5s17j8a8l8arm09a-gtk-icon-themes.drv' deleting `/gnu/store/hbxvgm2pc6f6jn2fai30izc7f5kd25qd-gtk-im-modules.drv' deleting `/gnu/store/hrc7yacy4ckmp3zi5pgmzd5ciqzv40ih-xdg-desktop-database.= drv' guix gc: error: executing SQLite statement: database disk image is malformed =2D-8<---------------cut here---------------end--------------->8--- I ran it a third time, and it printed: =2D-8<---------------cut here---------------start------------->8--- $ guix gc -C 25GiB finding garbage collector roots... deleting garbage... deleting `/gnu/store/1dqflkm3029ncacx5vl9r95ldfcfs3m0-pugixml-1.9.drv' guix gc: error: executing SQLite statement: database disk image is malformed =2D-8<---------------cut here---------------end--------------->8--- I ran it a fourth time, and it printed: =2D-8<---------------cut here---------------start------------->8--- $ guix gc -C 25GiB ... deleting `/gnu/store/w0nbsjjb1pj9pi1aim1qcbjq93zss9pn-libwpd-0.10.2.drv' deleting `/gnu/store/ywdgn73h9kdfcvs6cr1nfjqqj245p788-librevenge-0.0.4.drv' deleting `/gnu/store/ryawkapgxirj6yp54zb5vak027xxk2i1-cppunit-1.14.0.drv' deleting `/gnu/store/g2p20iss1r58r4ch2qggzyqn9d5q4kaf-cppunit-1.14.0.tar.gz= .drv' guix gc: error: executing SQLite statement: database disk image is malformed =2D-8<---------------cut here---------------end--------------->8--- I wonder what has brought my installation into this state. I can't think of a way to fix it since I don't even know what caused it, so I will probably re-install Guix to work around the issue, but before I do that, is there anything we can check to understand why the database corruption has occurred? For the record, I do sometimes abruptly power off my machine, and it does rarely abruptly crash (I think I have reported this when it occurs, but I can't be sure). In such cases, when booting, I see messages telling me that the system is recovering the journal from my ext4 file system, and I do not recall ever seeing an error from that process, but who knows what mischief I've been causing to my system over the years. =2D-=20 Chris --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEy/WXVcvn5+/vGD+x3UCaFdgiRp0FAl0xVWMACgkQ3UCaFdgi Rp0MkA//Z97cWkEVwi+5qbpcNNGq886118WNDdIrClciHClxeHRmGE88B3nVaJ68 6nkCk9hdyYj647o3qqz7WVubqQRbMct2G0bz66uKTcebwIaDEW4grWzM85bQgQ8F Bs4PzmobYZ7morhGdgwgA32KhRfuxwkM1the0iasJnAgQ7VNMkCNnsFQkqubOQ41 CmpbZkcJvX1IWYhYjkb2jvExcumV+oZwvEX64oT1EOQYXGj9Qs4whAJkIwY26w8/ wUcYIXxxxQ7q1DDvOgxz0bLA8Hay1vv6WYXZ2gIkgJWGV+md2/CZIuSO1+cpIr4s q67bRd4v/5HtRnsdnynDWYXYFnxj/yBayb/8mzSVXRwWxqQZ5hnL3gagYfl4CvXz HrgiVXyoYkpJjdNjcySw1zQSgHK05dACfPPDDl+mejlbw5QddUmNLHqOiLcF893N VMmwBR1Pt/J7/tV5rNKpYNqa8/5zQ08niB4gAn/70DHfNI7XOshhdGvV41PQwjjw Rwsb31EGddQkDutlBpX+BtnyypC0Yiw4lL3Mse3y8tu9DxDgyXSKlIdzKvcwntKX q3GXJpDLaDcLUKhoaSFePLN0euHoIaQRgpdNjqQ+93Y+rg5JQC59UJcDCAUJ/gxm g3iVvJiS/fLSPKgRhuepWRoCspIkL4J2rk9Er75NGXsFgil6Qig= =evKQ -----END PGP SIGNATURE----- --=-=-=--