unofficial mirror of bug-guix@gnu.org 
 help / color / mirror / code / Atom feed
* bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed
@ 2018-08-06 20:10 Benjamin Slade
  2018-08-19 14:08 ` Ludovic Courtès
  0 siblings, 1 reply; 4+ messages in thread
From: Benjamin Slade @ 2018-08-06 20:10 UTC (permalink / raw)
  To: 32377

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
 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 )

^ permalink raw reply	[flat|nested] 4+ messages in thread

* bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed
  2018-08-06 20:10 bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed Benjamin Slade
@ 2018-08-19 14:08 ` Ludovic Courtès
  2018-08-21  4:15   ` Benjamin Slade
  0 siblings, 1 reply; 4+ messages in thread
From: Ludovic Courtès @ 2018-08-19 14:08 UTC (permalink / raw)
  To: Benjamin Slade; +Cc: 32377

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

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’.

^ permalink raw reply	[flat|nested] 4+ messages in thread

* bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed
  2018-08-19 14:08 ` Ludovic Courtès
@ 2018-08-21  4:15   ` Benjamin Slade
  2018-08-21 10:31     ` Ludovic Courtès
  0 siblings, 1 reply; 4+ messages in thread
From: Benjamin Slade @ 2018-08-21  4:15 UTC (permalink / raw)
  To: Ludovic Courtès; +Cc: 32377

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 )

^ permalink raw reply	[flat|nested] 4+ messages in thread

* bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed
  2018-08-21  4:15   ` Benjamin Slade
@ 2018-08-21 10:31     ` Ludovic Courtès
  0 siblings, 0 replies; 4+ messages in thread
From: Ludovic Courtès @ 2018-08-21 10:31 UTC (permalink / raw)
  To: Benjamin Slade; +Cc: 32377

Hi,

Benjamin Slade <slade@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’.

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2018-08-21 10:33 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-08-06 20:10 bug#32377: guix gc -> build failed: executing SQLite statement: FOREIGN KEY constraint failed Benjamin Slade
2018-08-19 14:08 ` Ludovic Courtès
2018-08-21  4:15   ` Benjamin Slade
2018-08-21 10:31     ` Ludovic Courtès

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/guix.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).