From debbugs-submit-bounces@debbugs.gnu.org Fri Jul 19 01:30:24 2019 Received: (at 36687) by debbugs.gnu.org; 19 Jul 2019 05:30:24 +0000 Received: from localhost ([127.0.0.1]:54997 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hoLTM-0007CS-7W for submit@debbugs.gnu.org; Fri, 19 Jul 2019 01:30:24 -0400 Received: from mail-pf1-f171.google.com ([209.85.210.171]:37367) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hoLTL-00078B-05 for 36687@debbugs.gnu.org; Fri, 19 Jul 2019 01:30:23 -0400 Received: by mail-pf1-f171.google.com with SMTP id 19so13653234pfa.4 for <36687@debbugs.gnu.org>; Thu, 18 Jul 2019 22:30:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=LgSNd+KxPVHbbXkBj0rl1m6PUOTjGd1ZJCWkCyrwsgc=; b=kq80Xiq7SiD22rUGfXiaBKwLwuPpSN4b/mG5dU/1aw3I59stAJafk05kcDhEaa/Baa +n0SDxC2kBY77F6/e9Hk7ahHcNHppnK766HAqUIj9g3FnzsS552r9Qdcd/i4/vH0NmvT amyQCo5Ti9Tuc03ALvE6L2o/EXXDbf7R003Qr+xN/RaL3V2GKvI8aCq/mGtL0bQrRzJY pQHQ7C4bsYKvvGlPDwbUL3UncNc2rVEG2FsOiPldhFSWCXR+zv5cfaMWF5NZIf/+gKiZ Kk34sJYHh1EaXtKB66pWK+6X+w3L9Mu0874f3qJwtmAIsW8IkglcY1ReGVb+jcTzJvj7 fsIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=LgSNd+KxPVHbbXkBj0rl1m6PUOTjGd1ZJCWkCyrwsgc=; b=C3fxUe0SEdNOTUYWn44bsaV01pH+vVajyQBPxmb92LwzWWQW7+LtbLhWknlMJ1OZ+X Bi93vVb5LYuS6H52zEwP22c6ucspHfPfRaKRPy5uJFIAC058KOHyhsv7CSwVYBz8tf1f VuLCy/6q9VMHeay6YcUSMiidO9jB7ykG+PwFkzLJaIs2JITEFQYDdkzjKpzIte7X2R4q Zj6cRrUt/Q2QmUOb9eBco7ZaZRt8XlMHg7nzfrOaDkr2ChB4UpFBmPrhLHykVeCQndyS MKoCx76SCeC7iAVwWGr1F+8GvP4VpXn4N1JQgIkJgYVgXQrfHFCp9ETEs2C+bH7qrvCY y0eg== X-Gm-Message-State: APjAAAWQvOfzjmq62bM7JShDFlNkYea06CMpY7fdU4q3LdTHrm2UsXsF Y9uJk/5mYE2vnSERrn/ksy4uJZPP X-Google-Smtp-Source: APXvYqzG2PfpbWRHRd2leMnwY8CMAA3Xbmjp9nvFz7yaYF++5SDGmbZIzYk0RqgTZf7E5Q/3QZCxKw== X-Received: by 2002:a63:b919:: with SMTP id z25mr51581687pge.201.1563514216545; Thu, 18 Jul 2019 22:30:16 -0700 (PDT) Received: from garuda.local ([2601:601:9d80:25b2::d12]) by smtp.gmail.com with ESMTPSA id 85sm30129121pfv.130.2019.07.18.22.30.14 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 18 Jul 2019 22:30:15 -0700 (PDT) From: Chris Marusich To: Ricardo Wurmus Subject: Re: bug#36687: guix gc: error: executing SQLite statement: database disk image is malformed References: <87v9w2ctpm.fsf@gmail.com> <87tvbmgndy.fsf@elephly.net> Date: Thu, 18 Jul 2019 22:30:11 -0700 In-Reply-To: <87tvbmgndy.fsf@elephly.net> (Ricardo Wurmus's message of "Tue, 16 Jul 2019 14:44:09 +0200") Message-ID: <87pnm6egm4.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.1 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 36687 Cc: 36687@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --=-=-= 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----- --=-=-=--