GNU bug report logs - #32377
guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 32377 in the body.
You can then email your comments to 32377 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Benjamin Slade <slade <at> jnanam.net>
To: bug-guix <at> gnu.org
Subject: guix gc -> build failed: executing SQLite statement: FOREIGN KEY
 constraint failed
Date: Mon, 06 Aug 2018 14:10:45 -0600

I'm running the latest GuixSD, and when I run:

`guix gc`

I get the error:
build failed: executing SQLite statement: FOREIGN KEY constraint failed

I've tried running both:

guix gc --verify=repair,contents

&

guix gc --verify=repair

and these complete without error messages, but I get the same error when
I try to run `guix gc` afterwards..

So I don't seem to be able to free up space.

(Please cc me on any replies, as I'm not subscribed to bug-guix <at> gnu.org)

Thank you,
-- 
Dr Benjamin Slade - Uni of Utah, https://slade.jnanam.net
 https://babbagefiles.xyz
  `(pgp_fp: ,(21BA 2AE1 28F6 DF36 110A 0E9C A320 BBE8 2B52 EE19))
    '(sent by mu4e on Emacs running under GNU/Linux . https://gnu.org )
       `(Choose Linux ,(Choose Freedom) . https://linux.com )

Message #8 received at 32377 <at> debbugs.gnu.org (full text, mbox):

From: ludo <at> gnu.org (Ludovic Courtès)
To: Benjamin Slade <slade <at> jnanam.net>
Cc: 32377 <at> debbugs.gnu.org
Subject: Re: bug#32377: guix gc -> build failed: executing SQLite statement:
 FOREIGN KEY constraint failed
Date: Sun, 19 Aug 2018 16:08:08 +0200

Hello,

Benjamin Slade <slade <at> jnanam.net> skribis:

> I'm running the latest GuixSD, and when I run:
>
> `guix gc`
>
> I get the error:
> build failed: executing SQLite statement: FOREIGN KEY constraint failed

That happens with ‘guix gc’ without any options?  Do all runs of ‘guix
gc’ fail like this?

Does ‘guix gc --verify’ (not ‘--verify=xyz’) fail as well?

Thanks for your report,
Ludo’.

Message #11 received at 32377 <at> debbugs.gnu.org (full text, mbox):

From: Benjamin Slade <slade <at> jnanam.net>
To: Ludovic Courtès <ludo <at> gnu.org>
Cc: 32377 <at> debbugs.gnu.org
Subject: Re: bug#32377: guix gc -> build failed: executing SQLite statement:
 FOREIGN KEY constraint failed
Date: Mon, 20 Aug 2018 22:15:26 -0600

Hello,

I have since re-installed Guix on a different (larger) drive on the same
machine.

 > That happens with ‘guix gc’ without any options?  Do all runs of ‘guix
 > gc’ fail like this?

 > Does ‘guix gc --verify’ (not ‘--verify=xyz’) fail as well?

I tried various combinations/option of `guix gc`; whatever ones failed
with that message always failed with that message. I *think* (but am not
certain) that `guix gc --verify` may have not given any output, but
running it in any case did not affect `guix gc` producing the error
message.

I don't know if it was connected, but I also found that `/gnu` was
trying to use more than twice the number of available inodes.

[On my new install, I have not had these issues, though `/gnu` does seem
to use a worrying number of inodes:

Filesystem               Inodes   IUsed    IFree IUse% Mounted on
/dev/sda2               6553600 4052120  2501480   62% /

versus lots of free space remaining:

Filesystem             Type      Size  Used Avail Use% Mounted on
/dev/sda2              ext4       98G   40G   54G  43% /

]

 —Ben


On 2018-08-19T08:08:08-0600, Ludovic Courtès <ludo <at> gnu.org> wrote:

 > Hello,

 > Benjamin Slade <slade <at> jnanam.net> skribis:

 > > I'm running the latest GuixSD, and when I run:
 > >
 > > `guix gc`
 > >
 > > I get the error:
 > > build failed: executing SQLite statement: FOREIGN KEY constraint failed


--
Benjamin Slade - https://babbagefiles.xyz
  `(pgp_fp: ,(21BA 2AE1 28F6 DF36 110A 0E9C A320 BBE8 2B52 EE19))
    '(sent by mu4e on Emacs running under GNU/Linux . https://gnu.org )
       `(Choose Linux ,(Choose Freedom) . https://linux.com )

Message #14 received at 32377 <at> debbugs.gnu.org (full text, mbox):

From: ludo <at> gnu.org (Ludovic Courtès)
To: Benjamin Slade <slade <at> jnanam.net>
Cc: 32377 <at> debbugs.gnu.org
Subject: Re: bug#32377: guix gc -> build failed: executing SQLite statement:
 FOREIGN KEY constraint failed
Date: Tue, 21 Aug 2018 12:31:52 +0200

Hi,

Benjamin Slade <slade <at> jnanam.net> skribis:

> I have since re-installed Guix on a different (larger) drive on the same
> machine.

Alright.

>  > That happens with ‘guix gc’ without any options?  Do all runs of ‘guix
>  > gc’ fail like this?
>
>  > Does ‘guix gc --verify’ (not ‘--verify=xyz’) fail as well?
>
> I tried various combinations/option of `guix gc`; whatever ones failed
> with that message always failed with that message. I *think* (but am not
> certain) that `guix gc --verify` may have not given any output, but
> running it in any case did not affect `guix gc` producing the error
> message.

OK.  I’ll close the bug for now, but please do reopen it if the problem
comes up again.

> I don't know if it was connected, but I also found that `/gnu` was
> trying to use more than twice the number of available inodes.
>
> [On my new install, I have not had these issues, though `/gnu` does seem
> to use a worrying number of inodes:
>
> Filesystem               Inodes   IUsed    IFree IUse% Mounted on
> /dev/sda2               6553600 4052120  2501480   62% /
>
> versus lots of free space remaining:
>
> Filesystem             Type      Size  Used Avail Use% Mounted on
> /dev/sda2              ext4       98G   40G   54G  43% /

Is /gnu a separate file system?  Regardless, I don’t think it’s
worrying, or at least, I’ve never run out of inodes, even on machines
with very large stores such as the build farm.

Thank you,
Ludo’.

Previous Next

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