From unknown Sat Aug 09 15:18:47 2025 X-Loop: help-debbugs@gnu.org Subject: bug#33862: "guix gc" failing to complete Resent-From: Ethan O'Quin Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Mon, 24 Dec 2018 22:41:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 33862 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 33862@debbugs.gnu.org X-Debbugs-Original-To: "bug-guix@gnu.org" Reply-To: Ethan O'Quin Received: via spool by submit@debbugs.gnu.org id=B.15456912431644 (code B ref -1); Mon, 24 Dec 2018 22:41:02 +0000 Received: (at submit) by debbugs.gnu.org; 24 Dec 2018 22:40:43 +0000 Received: from localhost ([127.0.0.1]:35657 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbYtv-0000QR-67 for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:40:43 -0500 Received: from eggs.gnu.org ([208.118.235.92]:39352) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbYnb-0000HI-OI for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:34:12 -0500 Received: from lists.gnu.org ([208.118.235.17]:60799) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gbYnW-0004OU-Bc for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:34:06 -0500 Received: from eggs.gnu.org ([208.118.235.92]:34959) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gbYnV-0005IR-Gp for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:06 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-0.7 required=5.0 tests=BAYES_40,FREEMAIL_FROM, HTML_MESSAGE,MIME_BASE64_BLANKS,RCVD_IN_DNSWL_LOW autolearn=disabled version=3.3.2 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gbYnQ-0004CG-3A for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:05 -0500 Received: from mail-40136.protonmail.ch ([185.70.40.136]:56508) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gbYnP-0004AM-P2 for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:00 -0500 Date: Mon, 24 Dec 2018 22:33:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=default; t=1545690837; bh=oOQRgPluzfiNERwgeCX6rPYBRxhQHr3CboWcNH3bcgU=; h=Date:To:From:Reply-To:Subject:Feedback-ID:From; b=TaI5C6HU6pnP2Szs4AoGqew0Bi7YoHgKBAKzpGINGeiY68JM/boyZNuodr1GLqV/P fVqgTAM1y8OR4puGFwvlB9d2fItwAz41hznIn/bLCOAIB9yOrNzHLtIfgXpgMD7d8t kEhSpTgJK3dJCvhmvuWpyFKwL4luYn/87LH7JNQk= From: Ethan O'Quin Message-ID: Feedback-ID: BRKJ9Wnlu38t25zvlgYQtURhjh8nlc15uHMgFbNcUtlvgXRcRe8TrG02rN-Ai8d5hDhjO_L7VvrIQGj9_p6O6A==:Ext:ProtonMail MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="b1_1ea9f535e3dc31d31c78c006a3636bbe" X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-Received-From: 185.70.40.136 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Spam-Score: -4.0 (----) X-Mailman-Approved-At: Mon, 24 Dec 2018 17:40:41 -0500 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: -5.0 (-----) This is a multi-part message in MIME format. --b1_1ea9f535e3dc31d31c78c006a3636bbe Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 RXZlcnkgdGltZSBJIHJ1biAiZ3VpeCBnYyIgdGhlIHByb2Nlc3MgZmFpbHMgd2l0aDoKCiJndWl4 IGdjOiBlcnJvcjogYnVpbGQgZmFpbGVkOiBleGVjdXRpbmcgU1FMaXRlIHN0YXRlbWVudDogRk9S RUlHTiBLRVkgY29uc3RyYWludCBmYWlsZWQiCgpUaGlzIG9jY3VycyBldmVyeSB0aW1lICJndWl4 IGdjIiBpcyBydW4sIGFsdGhvdWdoIGl0IHByb2dyZXNzZXMgZm9yIGEgbW9tZW50IGJlZm9yZSBp dCBmYWlscy4KClRoZSBpc3N1ZSB3YXMgZW5jb3VudGVyZWQgb24gZ3VpeCAwLjE2LjAtNy42ZjFl MGJiIG9uIEd1aXhTRCBhcyBvZiBEZWNlbWJlciAyNCwgYWx0aG91Z2ggSSBoYXZlIGVuY291bnRl cmVkIGl0IHJlcGVhdGVkbHkgYmFjayB0byBzb21lIHRpbWUgaW4gT2N0b2JlciwgcG9zc2libHkg ZWFybGllci4= --b1_1ea9f535e3dc31d31c78c006a3636bbe Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdj5FdmVyeSB0aW1lIEkgcnVuICJndWl4IGdjIiB0aGUgcHJvY2VzcyBmYWlscyB3aXRoOjxi cj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PiJndWl4IGdjOiBlcnJvcjogYnVpbGQgZmFpbGVk OiBleGVjdXRpbmcgU1FMaXRlIHN0YXRlbWVudDogRk9SRUlHTiBLRVkgY29uc3RyYWludCBmYWls ZWQiIDxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoaXMgb2NjdXJzIGV2ZXJ5IHRpbWUg Imd1aXggZ2MiIGlzIHJ1biwgYWx0aG91Z2ggaXQgcHJvZ3Jlc3NlcyBmb3IgYSBtb21lbnQgYmVm b3JlIGl0IGZhaWxzLiA8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5UaGUgaXNzdWUgd2Fz IGVuY291bnRlcmVkIG9uIGd1aXggMC4xNi4wLTcuNmYxZTBiYiBvbiBHdWl4U0QgYXMgb2YgRGVj ZW1iZXIgMjQsIGFsdGhvdWdoIEkgaGF2ZSBlbmNvdW50ZXJlZCBpdCByZXBlYXRlZGx5IGJhY2sg dG8gc29tZSB0aW1lIGluIE9jdG9iZXIsIHBvc3NpYmx5IGVhcmxpZXIuPGJyPjwvZGl2Pg== --b1_1ea9f535e3dc31d31c78c006a3636bbe-- From unknown Sat Aug 09 15:18:47 2025 X-Loop: help-debbugs@gnu.org Subject: bug#33862: "guix gc" failing to complete Resent-From: Danny Milosavljevic Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 25 Dec 2018 07:52:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 33862 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ethan O'Quin Cc: 33862@debbugs.gnu.org Received: via spool by 33862-submit@debbugs.gnu.org id=B33862.154572428722130 (code B ref 33862); Tue, 25 Dec 2018 07:52:01 +0000 Received: (at 33862) by debbugs.gnu.org; 25 Dec 2018 07:51:27 +0000 Received: from localhost ([127.0.0.1]:35702 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbhUo-0005kn-SL for submit@debbugs.gnu.org; Tue, 25 Dec 2018 02:51:26 -0500 Received: from dd26836.kasserver.com ([85.13.145.193]:55566) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbhUj-0005kW-3H for 33862@debbugs.gnu.org; Tue, 25 Dec 2018 02:51:21 -0500 Received: from localhost (77.117.255.93.wireless.dyn.drei.com [77.117.255.93]) by dd26836.kasserver.com (Postfix) with ESMTPSA id DC8B63360360; Tue, 25 Dec 2018 08:51:14 +0100 (CET) Date: Tue, 25 Dec 2018 08:51:05 +0100 From: Danny Milosavljevic Message-ID: <20181225085105.6c1c36b9@scratchpost.org> In-Reply-To: References: X-Mailer: Claws Mail 3.17.1 (GTK+ 2.24.32; x86_64-unknown-linux-gnu) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/M+f1uDuN+fDy/WFuxFyKVb."; protocol="application/pgp-signature" X-Spam-Score: -0.7 (/) 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.7 (-) --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.-- From unknown Sat Aug 09 15:18:47 2025 X-Loop: help-debbugs@gnu.org Subject: bug#33862: "guix gc" failing to complete References: In-Reply-To: Resent-From: Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Sat, 06 Apr 2019 10:45:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 33862 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: "33862" <33862@debbugs.gnu.org> Received: via spool by 33862-submit@debbugs.gnu.org id=B33862.15545474501142 (code B ref 33862); Sat, 06 Apr 2019 10:45:01 +0000 Received: (at 33862) by debbugs.gnu.org; 6 Apr 2019 10:44:10 +0000 Received: from localhost ([127.0.0.1]:46607 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hCiny-0000IM-Fr for submit@debbugs.gnu.org; Sat, 06 Apr 2019 06:44:10 -0400 Received: from aibo.runbox.com ([91.220.196.211]:52386) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hCinw-0000IC-Da for 33862@debbugs.gnu.org; Sat, 06 Apr 2019 06:44:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=runbox.com; s=rbselector1; h=Message-Id:Date:Subject:To:From:MIME-Version: Content-Transfer-Encoding:Content-Type; bh=0Y+MMccFQyB18lLhEn9BVIxqVVfMlnmOpXVKqRXQ95A=; b=SQGlvbL8P5EeMlD5Lytd62MFZo DT5hE/Nw70NfEU9Vj3SsL6WPiEkC4MeREu0/MQz7ffjBAGWkynecc+NerM7KyrHenyrvhV+KGUg5h VOPRPDt7+BqTZxEwvASBmeVD1kAVxKrpUyccQ5atH/7DY9ziTu1/Fnp0pOZ1JCLgRHh2LqCuFfryZ l6fQ8VnnGS1FkbvAxkbebnK3oIrewW8p/STpU6yMpU1URWqRLNqBXJujklkEuqDZ+pFm+tnzhrXSH gfoCQPMPMEpajTGsQS1PvaY8NKantyHdiwRpNq1bM5eEEYIPslqMX7GjRXJx3fpdvhjHNUMIw9isy iZMUNTFA==; Received: from [10.9.9.127] (helo=rmmprod05.runbox) by mailtransmit02.runbox with esmtp (Exim 4.86_2) (envelope-from ) id 1hCinu-0002eK-Am for 33862@debbugs.gnu.org; Sat, 06 Apr 2019 12:44:06 +0200 Received: from mail by rmmprod05.runbox with local (Exim 4.86_2) (envelope-from ) id 1hCinu-0007hg-9t for 33862@debbugs.gnu.org; Sat, 06 Apr 2019 12:44:06 +0200 Content-Type: text/plain; charset="utf-8" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [Authenticated user (850733)] by runbox.com with http (RMM6); for <33862@debbugs.gnu.org>; Sat, 06 Apr 2019 10:44:06 GMT From: Date: Sat, 06 Apr 2019 11:44:06 +0100 (BST) X-Mailer: RMM6 Message-Id: X-Spam-Score: -0.4 (/) 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.4 (-) I'm also getting this problem. `guix gc --verify` doesn't fix it for me. Here is the output for each of the commands you (Danny Milosavljevic) sugge= sted: $ cp /var/guix/db/db.sqlite /tmp/ $ sqlite3 /tmp/db.sqlite sqlite> .tables DerivationOutputs FailedPaths Refs ValidPaths=20=20= =20=20=20=20=20 sqlite> .schema Refs CREATE TABLE Refs ( referrer integer not null, reference integer not null, primary key (referrer, reference), foreign key (referrer) references ValidPaths(id) on delete cascade, foreign key (reference) references ValidPaths(id) on delete restrict ); CREATE INDEX IndexReferrer on Refs(referrer); CREATE INDEX IndexReference on Refs(reference); sqlite> .schema DerivationOutputs CREATE TABLE DerivationOutputs ( drv integer not null, id text not null, -- symbolic output id, usually "out" path text not null, primary key (drv, id), foreign key (drv) references ValidPaths(id) on delete cascade ); CREATE INDEX IndexDerivationOutputs on DerivationOutputs(path); sqlite> .schema FailedPaths CREATE TABLE FailedPaths ( path text primary key not null, time integer not null ); sqlite> .schema ValidPaths CREATE TABLE ValidPaths ( id integer primary key autoincrement not null, path text unique not null, hash text not null, registrationTime integer not null, deriver text, narSize integer ); CREATE TRIGGER DeleteSelfRefs before delete on ValidPaths begin delete from Refs where referrer =3D old.id and reference =3D old.id; end;= From unknown Sat Aug 09 15:18:47 2025 X-Loop: help-debbugs@gnu.org Subject: bug#33862: "guix gc" failing to complete Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Sat, 19 Dec 2020 00:16:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 33862 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ethan O'Quin , pkill9@runbox.com, Danny Milosavljevic Cc: 33862@debbugs.gnu.org Received: via spool by 33862-submit@debbugs.gnu.org id=B33862.160833695229379 (code B ref 33862); Sat, 19 Dec 2020 00:16:02 +0000 Received: (at 33862) by debbugs.gnu.org; 19 Dec 2020 00:15:52 +0000 Received: from localhost ([127.0.0.1]:40533 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kqPua-0007dn-3u for submit@debbugs.gnu.org; Fri, 18 Dec 2020 19:15:52 -0500 Received: from mail-wr1-f41.google.com ([209.85.221.41]:44827) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kqPuY-0007dU-8t for 33862@debbugs.gnu.org; Fri, 18 Dec 2020 19:15:50 -0500 Received: by mail-wr1-f41.google.com with SMTP id w5so4340471wrm.11 for <33862@debbugs.gnu.org>; Fri, 18 Dec 2020 16:15:50 -0800 (PST) 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:content-transfer-encoding; bh=ck5c7S05GLsR+38l9ZDgfOUz5XgqO1EE9QzexUcZELs=; b=jtZO9dMeBGSFH6musvxymOkn4RYLbDQmSAV25BSAXLfgcsP20Sjn/+u5hfrCSFX3Oj Y3teW5n1KmjD2BjyjTh7z613gO3hFtmjUgAYP2vxluvYXVYH/51gqDUwnJwqAuXQ8rpY dd9Z+iyPlCK4xy/AXfk5d3GaNG38riqFoXx9OLPFbMwxYHed1lyp0GLRhES7qAKqgthB Ufyr6CVZsaR9iZUqWcjZlBaSQ6Oo4BXLLRV/Tp9vpM1WmenMUmCPF48ZNcCYIYh9K7jo oxFUsqvLVA8M59O5WjZT0+cq7rQvmnWRZ1tI/WcddEh96C7vlvCSw0e9GmBGFOrQCUfj miZA== 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:content-transfer-encoding; bh=ck5c7S05GLsR+38l9ZDgfOUz5XgqO1EE9QzexUcZELs=; b=i7J4cNMxdNGSPW0XqNOIHAQu9dnVFkJsLt4dUQAZiuO2/1alRpQ9ye7hngv8zuc2y+ wNKYlR0pVKAQJrgUjR7wTx2pnZzMuhw+iAz2r/VvsmQ/D5A0QBp6lPMDukeh5GiXUIiK Pupz5X4PouQZ4c0gp6SXGVP2gXp6pexeWs8JrF1gVBOa0iDovSa2y6Rt18t5x8Qohae9 ySLYlZzV3w8+6XhVmN8gMoKLtTxj2KY56pDvkkz2HoOYQBJaUPjsbbpcwI9W4PJgZ/w7 HrMroO7mB8+VjErd88Q/MqQJJxkg/Qbwydq1MMPFSJUcKFUUOdxo2RwHKgulg74u/aUQ I45g== X-Gm-Message-State: AOAM532EbXKd/fREwk5PCnuxrK5rCQ1BSzj2D75IAL5noK9Ie2vhJw4o du7cDKcxq5xRt9chT91UXG7Sja4+p4e7Kw== X-Google-Smtp-Source: ABdhPJwMshTLyN/sr0p7EpLj+44+4abjfK/aTt4N1AlQC0nF2XdacAQ5i3OEPFmMudonNrNmf9gmBg== X-Received: by 2002:adf:d082:: with SMTP id y2mr7079212wrh.301.1608336944535; Fri, 18 Dec 2020 16:15:44 -0800 (PST) Received: from lili ([2a01:e0a:59b:9120:65d2:2476:f637:db1e]) by smtp.gmail.com with ESMTPSA id w13sm15220530wrt.52.2020.12.18.16.15.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Dec 2020 16:15:44 -0800 (PST) From: zimoun References: Date: Sat, 19 Dec 2020 01:09:21 +0100 In-Reply-To: (Ethan O'Quin's message of "Mon, 24 Dec 2018 22:33:47 +0000") Message-ID: <86o8iqslla.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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 (-) Hi, What is the status of the bug#33862 ? On Mon, 24 Dec 2018 at 22:33, Ethan O'Quin w= rote: > Every time I run "guix gc" the process fails with: > > "guix gc: error: build failed: executing SQLite statement: FOREIGN KEY > constraint failed"=20=20 > > This occurs every time "guix gc" is run, although it progresses for a > moment before it fails.=20=20 > > The issue was encountered on guix 0.16.0-7.6f1e0bb on GuixSD as of > December 24, although I have encountered it repeatedly back to some > time in October, possibly earlier. Does the solution Try # guix gc --verify If that doesn't work, then=E2=80=A6=20 work for you? If not, please report what is wrong? Since it is 2years old, I hope you fixed the issue in the meantime. All the best, simon From unknown Sat Aug 09 15:18:47 2025 X-Loop: help-debbugs@gnu.org Subject: bug#33862: "guix gc" failing to complete Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Mon, 11 Jan 2021 15:38:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 33862 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ethan O'Quin Cc: Danny Milosavljevic , pkill9@runbox.com, 33862@debbugs.gnu.org Received: via spool by 33862-submit@debbugs.gnu.org id=B33862.161037947829602 (code B ref 33862); Mon, 11 Jan 2021 15:38:02 +0000 Received: (at 33862) by debbugs.gnu.org; 11 Jan 2021 15:37:58 +0000 Received: from localhost ([127.0.0.1]:57867 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kyzGY-0007hM-9l for submit@debbugs.gnu.org; Mon, 11 Jan 2021 10:37:58 -0500 Received: from mail-wm1-f43.google.com ([209.85.128.43]:40162) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kyzGU-0007gj-RR for 33862@debbugs.gnu.org; Mon, 11 Jan 2021 10:37:55 -0500 Received: by mail-wm1-f43.google.com with SMTP id r4so259462wmh.5 for <33862@debbugs.gnu.org>; Mon, 11 Jan 2021 07:37:54 -0800 (PST) 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:content-transfer-encoding; bh=MhADdaoeTE1h46NWkH5WXckwKGRCT2OYCyte4AYqok0=; b=Hxl10DtHDpbLVAOVeJ4Nd2lQEHIAZVVtLKprnQDKXmOlrOW7PmbFabN4X8B4AsuBAm 85xNGouK7KKqBrICiKEbGX4bzuXUAPXvvMJvmvA35zXyW2yT+QH3Il017O9b0uDd4Uoi HGZq+av/DJiLFXha6tc/qbAJnFDG9eTW0mZWkHHVJbk/9X0yAkq+bdv8VGwkU62ivp0f eHC2lkCZoad/kZJwraExfaKIIlop3OaGem/qmKMJnXW5sxjMzr1As2IfW0dqtMZZSHTY injhPpo/9Rj1RFuNJp8v4jR6EQh1HxtIp8B+QEPFWalso84DOboL5zqkqwyrg+3e7H0u q/aQ== 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:content-transfer-encoding; bh=MhADdaoeTE1h46NWkH5WXckwKGRCT2OYCyte4AYqok0=; b=eP6W/fjumkqEaUBeEX+3wiVwm8hYTk1NNqKlHn8sAJnbnmd38MUtbY01ALNt/+CmKz md7bERDPsee0UhpzIx/tk4v1OLUwfviQeu+iLURN98KjWvQ5qOo7pdeBtvc6iEEs98+J WTHFhQniLZnYVbP7CJTZli+7kqtkUsttOGxfUGCJP/anaYZ+EYtWGy27xOVZza/SNxCK R7tMM6Ez82m3FuWnRYp0T7u8g4vP3YytMDs/lS3UFHo5Vh3F9OJKEut36WrN6KLDD5JN Og3qa6H6O/hVsDnvB2ZJFUIEZkn4H3zu7/qw0BfBIzVRjBnE1uhXFaoxnz5rcVYlGkQe xRFA== X-Gm-Message-State: AOAM532cj9wEymKIHou4xNjiBzE6l0p6/4mLznplBwu8XC6yoqRi9kuu pQ3RTqNLTY4nmdC/nnBdlA00zDlfJ9A= X-Google-Smtp-Source: ABdhPJxO4CrCclOaCmZrbaMZve5O+ZYAlJR8hLiCrQhlGzp/5LdOSI+uUnlDK1JM0uGo1JtmH2q22A== X-Received: by 2002:a1c:2605:: with SMTP id m5mr239686wmm.111.1610379469037; Mon, 11 Jan 2021 07:37:49 -0800 (PST) Received: from lili ([2a01:e0a:59b:9120:65d2:2476:f637:db1e]) by smtp.gmail.com with ESMTPSA id l5sm25185383wrv.44.2021.01.11.07.37.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 11 Jan 2021 07:37:48 -0800 (PST) From: zimoun References: <86o8iqslla.fsf@gmail.com> Date: Mon, 11 Jan 2021 16:27:29 +0100 In-Reply-To: <86o8iqslla.fsf@gmail.com> (zimoun's message of "Sat, 19 Dec 2020 01:09:21 +0100") Message-ID: <86czybsdcu.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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 (-) Hi, On Sat, 19 Dec 2020 at 01:09, zimoun wrote: > On Mon, 24 Dec 2018 at 22:33, Ethan O'Quin = wrote: > > Does the solution > > Try > > # guix gc --verify > > If that doesn't work, then=E2=80=A6=20 > > work for you? If not, please report what is wrong? > > Since it is 2years old, I hope you fixed the issue in the meantime. If no moreinfo, I will close this old issue in the coming days. All the best, simon From unknown Sat Aug 09 15:18:47 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Ethan O'Quin Subject: bug#33862: closed (Re: bug#33862: "guix gc" failing to complete) Message-ID: References: <86ft25azqi.fsf@gmail.com> X-Gnu-PR-Message: they-closed 33862 X-Gnu-PR-Package: guix Reply-To: 33862@debbugs.gnu.org Date: Tue, 09 Feb 2021 18:09:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1612894142-28428-1" This is a multi-part message in MIME format... ------------=_1612894142-28428-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #33862: "guix gc" failing to complete which was filed against the guix package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 33862@debbugs.gnu.org. --=20 33862: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D33862 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1612894142-28428-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 33862-done) by debbugs.gnu.org; 9 Feb 2021 18:08:46 +0000 Received: from localhost ([127.0.0.1]:54522 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l9XRO-0007Nx-6H for submit@debbugs.gnu.org; Tue, 09 Feb 2021 13:08:46 -0500 Received: from mail-wm1-f49.google.com ([209.85.128.49]:56181) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l9XRJ-0007Nd-Ic for 33862-done@debbugs.gnu.org; Tue, 09 Feb 2021 13:08:44 -0500 Received: by mail-wm1-f49.google.com with SMTP id f16so4092090wmq.5 for <33862-done@debbugs.gnu.org>; Tue, 09 Feb 2021 10:08:41 -0800 (PST) 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:content-transfer-encoding; bh=BMcDLtg2qSDqoziFPsdMjAZwh6fMBYGP9XAz3VjxoLw=; b=LKT6tpqTCBXHqYt5RyYfn08osHIhaybr9ausefJyX4e9XdP9GUHNIIlMAc79NDNIix f1nJ6J48n27h9CAd/50lYWZG58xg8Bo/FLrV0crHUqnk/Qqospg3N9KEFZTY4QzacAjm D7yZYf4loqSeC89I3iQU0UhARQHRyLJjMHJWzgks9RZBEt+itCTSswu7lwY1CjRkMAzH KrL1y2NLRHl/FrLT3Y14yi1DP0z7qdJKB8Gqv/ckK6hJZEwO/mqLdicAR+T2NQZpzJ8v joWPyYIRRfPqRzj8m0kdtQbCmcNtLYPKhMCRP9Kp5kejHSfnbaB2IbfE4ejRxEYgGwVQ Citg== 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:content-transfer-encoding; bh=BMcDLtg2qSDqoziFPsdMjAZwh6fMBYGP9XAz3VjxoLw=; b=eNr2PS/oA1rvNOutXt7O7TXPkEE9gXpdMzndy5j6YtAI3m3sioX+jUNFLcRdVkIuqU KTgPg8tG3PfArcJtwvIel8vs1dqmmr8JYVDAFcrvI6jhsbJvONfOF9rHct7gH8yFH/c/ foYd13eFyBG7DG80KkMJifWpc6IWGHwW+1IM0C/+gQ9T9xELhanwKMht+jB4MaHqhMqA 1QaUMZ6HFiyCUzQM3QWesG7bH/g8cOFHoUQFe0WftNDYppZ/OzGyKt2420Un8omfjmTa RC0a9W4nrSkr11V/rdJPWBOUn4TFXmRqqK3SPO7y7tlpA+Iw+wS2RNaUvZnrqx2MPdnq OiXQ== X-Gm-Message-State: AOAM5323F2Zjlhuw5btgNEv+hwLQ7tqNO84qswF/EbuvPC71+HNTsMZE bBIomYroP6lK4fLtdReV9v4Xi59XPdA= X-Google-Smtp-Source: ABdhPJxu8bwzTl0KQcg+/Ec8cnvIlsK01URaRfia0yfsUSUgCMe88N/R6IKgaI1CtAX/S+wlVXfnyw== X-Received: by 2002:a1c:c288:: with SMTP id s130mr4675764wmf.125.1612894115682; Tue, 09 Feb 2021 10:08:35 -0800 (PST) Received: from lili ([2a01:e0a:59b:9120:65d2:2476:f637:db1e]) by smtp.gmail.com with ESMTPSA id r17sm37439193wro.46.2021.02.09.10.08.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 09 Feb 2021 10:08:35 -0800 (PST) From: zimoun To: Ethan O'Quin Subject: Re: bug#33862: "guix gc" failing to complete References: <86o8iqslla.fsf@gmail.com> <86czybsdcu.fsf@gmail.com> Date: Tue, 09 Feb 2021 18:59:49 +0100 In-Reply-To: <86czybsdcu.fsf@gmail.com> (zimoun's message of "Mon, 11 Jan 2021 16:27:29 +0100") Message-ID: <86ft25azqi.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 33862-done Cc: Danny Milosavljevic , 33862-done@debbugs.gnu.org, pkill9@runbox.com 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 (-) Hi, On Mon, 11 Jan 2021 at 16:27, zimoun wrote: > On Sat, 19 Dec 2020 at 01:09, zimoun wrote: >> On Mon, 24 Dec 2018 at 22:33, Ethan O'Quin wrote: > >> >> Does the solution >> >> Try >> >> # guix gc --verify >> >> If that doesn't work, then=E2=80=A6=20 >> >> work for you? If not, please report what is wrong? >> >> Since it is 2years old, I hope you fixed the issue in the meantime. > > If no moreinfo, I will close this old issue in the coming days. No news after 2 years and waiting more than 4 weeks for moreinfo, I am closing now. If I am missing something, feel free to reopen. All the best, simon ------------=_1612894142-28428-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 24 Dec 2018 22:40:43 +0000 Received: from localhost ([127.0.0.1]:35657 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbYtv-0000QR-67 for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:40:43 -0500 Received: from eggs.gnu.org ([208.118.235.92]:39352) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gbYnb-0000HI-OI for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:34:12 -0500 Received: from lists.gnu.org ([208.118.235.17]:60799) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gbYnW-0004OU-Bc for submit@debbugs.gnu.org; Mon, 24 Dec 2018 17:34:06 -0500 Received: from eggs.gnu.org ([208.118.235.92]:34959) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gbYnV-0005IR-Gp for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:06 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-0.7 required=5.0 tests=BAYES_40,FREEMAIL_FROM, HTML_MESSAGE,MIME_BASE64_BLANKS,RCVD_IN_DNSWL_LOW autolearn=disabled version=3.3.2 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gbYnQ-0004CG-3A for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:05 -0500 Received: from mail-40136.protonmail.ch ([185.70.40.136]:56508) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gbYnP-0004AM-P2 for bug-guix@gnu.org; Mon, 24 Dec 2018 17:34:00 -0500 Date: Mon, 24 Dec 2018 22:33:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=default; t=1545690837; bh=oOQRgPluzfiNERwgeCX6rPYBRxhQHr3CboWcNH3bcgU=; h=Date:To:From:Reply-To:Subject:Feedback-ID:From; b=TaI5C6HU6pnP2Szs4AoGqew0Bi7YoHgKBAKzpGINGeiY68JM/boyZNuodr1GLqV/P fVqgTAM1y8OR4puGFwvlB9d2fItwAz41hznIn/bLCOAIB9yOrNzHLtIfgXpgMD7d8t kEhSpTgJK3dJCvhmvuWpyFKwL4luYn/87LH7JNQk= To: "bug-guix@gnu.org" From: Ethan O'Quin Subject: "guix gc" failing to complete Message-ID: Feedback-ID: BRKJ9Wnlu38t25zvlgYQtURhjh8nlc15uHMgFbNcUtlvgXRcRe8TrG02rN-Ai8d5hDhjO_L7VvrIQGj9_p6O6A==:Ext:ProtonMail MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="b1_1ea9f535e3dc31d31c78c006a3636bbe" X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-Received-From: 185.70.40.136 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Spam-Score: -4.0 (----) X-Debbugs-Envelope-To: submit X-Mailman-Approved-At: Mon, 24 Dec 2018 17:40:41 -0500 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: , Reply-To: Ethan O'Quin Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.0 (-----) This is a multi-part message in MIME format. --b1_1ea9f535e3dc31d31c78c006a3636bbe Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 RXZlcnkgdGltZSBJIHJ1biAiZ3VpeCBnYyIgdGhlIHByb2Nlc3MgZmFpbHMgd2l0aDoKCiJndWl4 IGdjOiBlcnJvcjogYnVpbGQgZmFpbGVkOiBleGVjdXRpbmcgU1FMaXRlIHN0YXRlbWVudDogRk9S RUlHTiBLRVkgY29uc3RyYWludCBmYWlsZWQiCgpUaGlzIG9jY3VycyBldmVyeSB0aW1lICJndWl4 IGdjIiBpcyBydW4sIGFsdGhvdWdoIGl0IHByb2dyZXNzZXMgZm9yIGEgbW9tZW50IGJlZm9yZSBp dCBmYWlscy4KClRoZSBpc3N1ZSB3YXMgZW5jb3VudGVyZWQgb24gZ3VpeCAwLjE2LjAtNy42ZjFl MGJiIG9uIEd1aXhTRCBhcyBvZiBEZWNlbWJlciAyNCwgYWx0aG91Z2ggSSBoYXZlIGVuY291bnRl cmVkIGl0IHJlcGVhdGVkbHkgYmFjayB0byBzb21lIHRpbWUgaW4gT2N0b2JlciwgcG9zc2libHkg ZWFybGllci4= --b1_1ea9f535e3dc31d31c78c006a3636bbe Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdj5FdmVyeSB0aW1lIEkgcnVuICJndWl4IGdjIiB0aGUgcHJvY2VzcyBmYWlscyB3aXRoOjxi cj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PiJndWl4IGdjOiBlcnJvcjogYnVpbGQgZmFpbGVk OiBleGVjdXRpbmcgU1FMaXRlIHN0YXRlbWVudDogRk9SRUlHTiBLRVkgY29uc3RyYWludCBmYWls ZWQiIDxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoaXMgb2NjdXJzIGV2ZXJ5IHRpbWUg Imd1aXggZ2MiIGlzIHJ1biwgYWx0aG91Z2ggaXQgcHJvZ3Jlc3NlcyBmb3IgYSBtb21lbnQgYmVm b3JlIGl0IGZhaWxzLiA8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5UaGUgaXNzdWUgd2Fz IGVuY291bnRlcmVkIG9uIGd1aXggMC4xNi4wLTcuNmYxZTBiYiBvbiBHdWl4U0QgYXMgb2YgRGVj ZW1iZXIgMjQsIGFsdGhvdWdoIEkgaGF2ZSBlbmNvdW50ZXJlZCBpdCByZXBlYXRlZGx5IGJhY2sg dG8gc29tZSB0aW1lIGluIE9jdG9iZXIsIHBvc3NpYmx5IGVhcmxpZXIuPGJyPjwvZGl2Pg== --b1_1ea9f535e3dc31d31c78c006a3636bbe-- ------------=_1612894142-28428-1--