guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed

  • Done
  • quality assurance status badge
Details
2 participants
  • Ludovic Courtès
  • Benjamin Slade
Owner
unassigned
Submitted by
Benjamin Slade
Severity
normal

Debbugs page

B
B
Benjamin Slade wrote on 6 Aug 2018 13:10
(address . bug-guix@gnu.org)
87600nfe7u.fsf@jnanam.net
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@gnu.org)

Thank you,
--
Dr Benjamin Slade - Uni of Utah, https://slade.jnanam.net
`(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)
L
L
Ludovic Courtès wrote on 19 Aug 2018 07:08
(name . Benjamin Slade)(address . slade@jnanam.net)(address . 32377@debbugs.gnu.org)
87tvnqh2k7.fsf@gnu.org
Hello,

Benjamin Slade <slade@jnanam.net> skribis:

Toggle quote (7 lines)
> 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’.
B
B
Benjamin Slade wrote on 20 Aug 2018 21:15
(name . Ludovic Courtès)(address . ludo@gnu.org)(address . 32377@debbugs.gnu.org)
87o9dwmk2p.fsf@jnanam.net
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@gnu.org> wrote:

> Hello,

> Benjamin Slade <slade@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)
L
L
Ludovic Courtès wrote on 21 Aug 2018 03:31
(name . Benjamin Slade)(address . slade@jnanam.net)(address . 32377@debbugs.gnu.org)
87efesovs7.fsf@gnu.org
Hi,

Benjamin Slade <slade@jnanam.net> skribis:

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

Alright.

Toggle quote (11 lines)
> > 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.

Toggle quote (14 lines)
> 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’.
L
L
Ludovic Courtès wrote on 21 Aug 2018 03:32
control message for bug #32377
(address . control@debbugs.gnu.org)
87d0ucovrm.fsf@gnu.org
tags 32377 unreproducible
close 32377
?
Your comment

This issue is archived.

To comment on this conversation send an email to 32377@patchwise.org

To respond to this issue using the mumi CLI, first switch to it
mumi current 32377
Then, you may apply the latest patchset in this issue (with sign off)
mumi am -- -s
Or, compose a reply to this issue
mumi compose
Or, send patches to this issue
mumi send-email *.patch