From: <pkill9@runbox.com>
To: 33862 <33862@debbugs.gnu.org>
Subject: bug#33862: "guix gc" failing to complete
Date: Sat, 06 Apr 2019 11:44:06 +0100 (BST) [thread overview]
Message-ID: <E1hCinu-0007hg-9t@rmmprod05.runbox> (raw)
In-Reply-To: <GA8iS1aNem02oYkFHr8_hBiLm8tRWKPIlQOgnexihwSTg-QQ_dnKrQkKEBhsi3iFL7cEn0mGXkLIjzXHSv5EKT8F4CNtLndnoMN4kS0q2es=@protonmail.com>
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) suggested:
$ cp /var/guix/db/db.sqlite /tmp/
$ sqlite3 /tmp/db.sqlite
sqlite> .tables
DerivationOutputs FailedPaths Refs ValidPaths
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 = old.id and reference = old.id;
end;
next prev parent reply other threads:[~2019-04-06 10:45 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2018-12-24 22:33 bug#33862: "guix gc" failing to complete Ethan O'Quin
2018-12-25 7:51 ` Danny Milosavljevic
2019-04-06 10:44 ` pkill9 [this message]
2020-12-19 0:09 ` zimoun
2021-01-11 15:27 ` zimoun
2021-02-09 17:59 ` zimoun
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://guix.gnu.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=E1hCinu-0007hg-9t@rmmprod05.runbox \
--to=pkill9@runbox.com \
--cc=33862@debbugs.gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).