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

DoneSubmitted by Benjamin Slade.
Details
2 participants
  • Ludovic Courtès
  • Benjamin Slade
Owner
unassigned
Severity
normal
B
B
Benjamin Slade wrote on 6 Aug 2018 22: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 whenI 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 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 19 Aug 2018 16: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 ‘guixgc’ fail like this?
Does ‘guix gc --verify’ (not ‘--verify=xyz’) fail as well?
Thanks for your report,Ludo’.
B
B
Benjamin Slade wrote on 21 Aug 2018 06: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 samemachine.
> 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 failedwith that message always failed with that message. I *think* (but am notcertain) that `guix gc --verify` may have not given any output, butrunning it in any case did not affect `guix gc` producing the errormessage.
I don't know if it was connected, but I also found that `/gnu` wastrying to use more than twice the number of available inodes.
[On my new install, I have not had these issues, though `/gnu` does seemto 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 12: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 problemcomes 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’sworrying, or at least, I’ve never run out of inodes, even on machineswith very large stores such as the build farm.
Thank you,Ludo’.
L
L
Ludovic Courtès wrote on 21 Aug 2018 12:32
control message for bug #32377
(address . control@debbugs.gnu.org)
87d0ucovrm.fsf@gnu.org
tags 32377 unreproducibleclose 32377
?
Your comment

This issue is archived.

To comment on this conversation send email to 32377@debbugs.gnu.org