From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: bug#33862: "guix gc" failing to complete Date: Tue, 25 Dec 2018 08:51:05 +0100 Message-ID: <20181225085105.6c1c36b9@scratchpost.org> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/M+f1uDuN+fDy/WFuxFyKVb."; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([208.118.235.92]:36262) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gbhVW-000659-UE for bug-guix@gnu.org; Tue, 25 Dec 2018 02:52:10 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gbhVR-0002z4-WB for bug-guix@gnu.org; Tue, 25 Dec 2018 02:52:06 -0500 Received: from debbugs.gnu.org ([208.118.235.43]:40153) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1gbhVR-0002ys-Ss for bug-guix@gnu.org; Tue, 25 Dec 2018 02:52:01 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1gbhVR-0005lt-NK for bug-guix@gnu.org; Tue, 25 Dec 2018 02:52:01 -0500 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: 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: Ethan O'Quin Cc: 33862@debbugs.gnu.org --Sig_/M+f1uDuN+fDy/WFuxFyKVb. Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi, On Mon, 24 Dec 2018 22:33:47 +0000 Ethan O'Quin wrote: > Every time I run "guix gc" the process fails with: >=20 > "guix gc: error: build failed: executing SQLite statement: FOREIGN KEY co= nstraint failed" >=20 > This occurs every time "guix gc" is run, although it progresses for a mom= ent before it fails. >=20 > The issue was encountered on guix 0.16.0-7.6f1e0bb on GuixSD as of Decemb= er 24, although I have encountered it repeatedly back to some time in Octob= er, possibly earlier. Try # guix gc --verify If that doesn't work, then $ cp /var/guix/db/db.sqlite /tmp/ $ sqlite3 /tmp/db.sqlite sqlite> .tables sqlite> .schema Refs Do you see a foreign key here with "on delete restrict", Refs.reference ? sqlite> .schema DerivationOutputs No "on delete restrict" here? sqlite> .schema FailedPaths No "on delete restrict" here? sqlite> .schema ValidPaths No "on delete restrict" here? Also, is there a hash value somewhere in the error messages? --Sig_/M+f1uDuN+fDy/WFuxFyKVb. Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlwh4WkACgkQ5xo1VCww uqVFNQf+PsRFbw5rwfOB5dYH1/CeJQmWxhIaQD+xjfNenkOw1gBpeieaIKy2vdrp 6mxgJYzN8ry4iN23H2NwtzHYT3Phqi6i2TfDpJZ0A3yIkhkTwZjPEQzXIIyrDcYU 3R1zQIOfG2e+WhILR5uSZKsfS+fjkR83/XfUDNaKIkVXbLfq4t2inMc7XpnpTvQ8 EewR4sZbWtWZjgnPNmZ755rOilbCS/jHYyq0rWs06Qjh64tNm1w1vm68xyA+hI3j hW76yK3HU27wepSGmfx13Q681RimASVJfyF7XxJgVCQgH6EDrKJ+HtgqKwhBiqJq CqfGN8ge5BG6WsT2t73ysWzqatwvMg== =VLTg -----END PGP SIGNATURE----- --Sig_/M+f1uDuN+fDy/WFuxFyKVb.--