GNU bug report logs - #33862
"guix gc" failing to complete

Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.

Package: guix; Reported by: Ethan O'Quin <ethan.a.oquin@HIDDEN>; dated Mon, 24 Dec 2018 22:41:02 UTC; Maintainer for guix is bug-guix@HIDDEN.

Message received at 33862 <at> debbugs.gnu.org:


Received: (at 33862) by debbugs.gnu.org; 6 Apr 2019 10:44:10 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Sat Apr 06 06:44:10 2019
Received: from localhost ([127.0.0.1]:46607 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1hCiny-0000IM-Fr
	for submit <at> 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 <pkill9@HIDDEN>) id 1hCinw-0000IC-Da
 for 33862 <at> 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 <pkill9@HIDDEN>) id 1hCinu-0002eK-Am
 for 33862 <at> 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 <pkill9@HIDDEN>) id 1hCinu-0007hg-9t
 for 33862 <at> 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 <at> debbugs.gnu.org>; Sat, 06 Apr 2019 10:44:06 GMT
From: <pkill9@HIDDEN>
To: "33862" <33862 <at> debbugs.gnu.org>
Subject: Re: bug#33862: "guix gc" failing to complete
Date: Sat, 06 Apr 2019 11:44:06 +0100 (BST)
X-Mailer: RMM6
Message-Id: <E1hCinu-0007hg-9t@HIDDEN>
X-Spam-Score: -0.4 (/)
X-Debbugs-Envelope-To: 33862
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
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;=




Information forwarded to bug-guix@HIDDEN:
bug#33862; Package guix. Full text available.

Message received at 33862 <at> debbugs.gnu.org:


Received: (at 33862) by debbugs.gnu.org; 25 Dec 2018 07:51:27 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Tue Dec 25 02:51:26 2018
Received: from localhost ([127.0.0.1]:35702 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1gbhUo-0005kn-SL
	for submit <at> 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 <dannym@HIDDEN>) id 1gbhUj-0005kW-3H
 for 33862 <at> 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 <dannym@HIDDEN>
To: Ethan O'Quin <ethan.a.oquin@HIDDEN>
Subject: Re: bug#33862: "guix gc" failing to complete
Message-ID: <20181225085105.6c1c36b9@HIDDEN>
In-Reply-To: <GA8iS1aNem02oYkFHr8_hBiLm8tRWKPIlQOgnexihwSTg-QQ_dnKrQkKEBhsi3iFL7cEn0mGXkLIjzXHSv5EKT8F4CNtLndnoMN4kS0q2es=@protonmail.com>
References: <GA8iS1aNem02oYkFHr8_hBiLm8tRWKPIlQOgnexihwSTg-QQ_dnKrQkKEBhsi3iFL7cEn0mGXkLIjzXHSv5EKT8F4CNtLndnoMN4kS0q2es=@protonmail.com>
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-Debbugs-Envelope-To: 33862
Cc: 33862 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
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 <ethan.a.oquin@HIDDEN> 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.--




Information forwarded to bug-guix@HIDDEN:
bug#33862; Package guix. Full text available.

Message received at submit <at> debbugs.gnu.org:


Received: (at submit) by debbugs.gnu.org; 24 Dec 2018 22:40:43 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Mon Dec 24 17:40:43 2018
Received: from localhost ([127.0.0.1]:35657 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1gbYtv-0000QR-67
	for submit <at> 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 <ethan.a.oquin@HIDDEN>) id 1gbYnb-0000HI-OI
 for submit <at> 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 <ethan.a.oquin@HIDDEN>)
 id 1gbYnW-0004OU-Bc
 for submit <at> 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 <ethan.a.oquin@HIDDEN>) id 1gbYnV-0005IR-Gp
 for bug-guix@HIDDEN; 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 <ethan.a.oquin@HIDDEN>) id 1gbYnQ-0004CG-3A
 for bug-guix@HIDDEN; 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 <ethan.a.oquin@HIDDEN>)
 id 1gbYnP-0004AM-P2
 for bug-guix@HIDDEN; 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@HIDDEN" <bug-guix@HIDDEN>
From: Ethan O'Quin <ethan.a.oquin@HIDDEN>
Subject: "guix gc" failing to complete
Message-ID: <GA8iS1aNem02oYkFHr8_hBiLm8tRWKPIlQOgnexihwSTg-QQ_dnKrQkKEBhsi3iFL7cEn0mGXkLIjzXHSv5EKT8F4CNtLndnoMN4kS0q2es=@protonmail.com>
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 <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Reply-To: Ethan O'Quin <ethan.a.oquin@HIDDEN>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
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--





Acknowledgement sent to Ethan O'Quin <ethan.a.oquin@HIDDEN>:
New bug report received and forwarded. Copy sent to bug-guix@HIDDEN. Full text available.
Report forwarded to bug-guix@HIDDEN:
bug#33862; Package guix. Full text available.
Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Last modified: Mon, 25 Nov 2019 12:00:02 UTC

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