GNU bug report logs - #66612
guix locate guild results in sqlite3 attempt to write readonly database

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 66612 in the body.
You can then email your comments to 66612 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: Matt Wette <matt.wette <at> gmail.com>
To: bug-guix <at> gnu.org
Subject: guix locate guild results in sqlite3 attempt to write readonly
 database
Date: Wed, 18 Oct 2023 08:47:01 -0700

[Message part 1 (text/plain, inline)]

`guix locate guild' fails with attempt to write a readonly sqlite3 database

mwette <at> bluefin$ strace -o logx guix locate guild
guix locate: indexing files from /gnu/store...
guix locate: traversing local profile manifests...
Backtrace:
          13 (primitive-load "/home/mwette/.config/guix/current/bin/…")
In guix/ui.scm:
   2323:7 12 (run-guix . _)
  2286:10 11 (run-guix-command _ . _)
In ice-9/boot-9.scm:
  1752:10 10 (with-exception-handler _ _ #:unwind? _ # _)
In guix/scripts/locate.scm:
    621:8  9 (_)
    123:8  8 (call-with-database _ _)
In guix/progress.scm:
    71:36  7 (call-with-progress-reporter _ _)
In srfi/srfi-1.scm:
    634:9  6 (for-each #<procedure 7f179a23ca00 at guix/scripts/loc…> …)
In guix/scripts/locate.scm:
    442:2  5 (_ _)
    286:2  4 (insert-files #<<sqlite-db> pointer: #<pointer 0x1f98f…> …)
In srfi/srfi-1.scm:
    634:9  3 (for-each #<procedure 7f179abb3000 at guix/scripts/loc…> …)
In sqlite3.scm:
   637:15  2 (sqlite-fold #<procedure 7f179a23c5a0 at ice-9/boot-9.…> …)
    166:2  1 (_ _)
In ice-9/boot-9.scm:
  1685:16  0 (raise-exception _ #:continuable? _)

ice-9/boot-9.scm:1685:16: In procedure raise-exception:
Throw to key `sqlite-error' with args `(#f 8 "attempt to write a 
readonly database")'.
indexing 1,654 packages
mwette <at> bluefin$

[logx (text/plain, attachment)]

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

From: Ludovic Courtès <ludo <at> gnu.org>
To: Matt Wette <matt.wette <at> gmail.com>
Cc: 66612 <at> debbugs.gnu.org
Subject: Re: bug#66612: guix locate guild results in sqlite3 attempt to
 write readonly database
Date: Wed, 18 Oct 2023 17:54:54 +0200

Hi,

Matt Wette <matt.wette <at> gmail.com> skribis:

> `guix locate guild' fails with attempt to write a readonly sqlite3 database
>
> mwette <at> bluefin$ strace -o logx guix locate guild
> guix locate: indexing files from /gnu/store...
> guix locate: traversing local profile manifests...

The bug here is that it picked the system-wide database:

  openat(AT_FDCWD, "/var/cache/guix/locate/db.sqlite", O_RDONLY|O_NOFOLLOW|O_CLOEXEC) = 14

but later decided that it was too old and that it needed to be
refreshed.  But of course, that file is read-only for unprivileged
users.

There’s a bug in the file-choosing logic.

To be continued…

Ludo’.

Message #15 received at 66612-done <at> debbugs.gnu.org (full text, mbox):

From: Ludovic Courtès <ludo <at> gnu.org>
To: Matt Wette <matt.wette <at> gmail.com>
Cc: 66612-done <at> debbugs.gnu.org
Subject: Re: bug#66612: guix locate guild results in sqlite3 attempt to
 write readonly database
Date: Wed, 18 Oct 2023 23:13:15 +0200

Fixed in commit d0fed2f4df06446eafcc992f0bc7ea154124fdf4, thanks!

Ludo'.

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

From: Ludovic Courtès <ludo <at> gnu.org>
To: Matt Wette <matt.wette <at> gmail.com>
Cc: 66612 <at> debbugs.gnu.org
Subject: Re: bug#66612: guix locate guild results in sqlite3 attempt to
 write readonly database
Date: Thu, 19 Oct 2023 17:33:15 +0200

Ludovic Courtès <ludo <at> gnu.org> skribis:

> Matt Wette <matt.wette <at> gmail.com> skribis:
>
>> `guix locate guild' fails with attempt to write a readonly sqlite3 database
>>
>> mwette <at> bluefin$ strace -o logx guix locate guild
>> guix locate: indexing files from /gnu/store...
>> guix locate: traversing local profile manifests...
>
> The bug here is that it picked the system-wide database:

The immediate workaround is to run ‘guix locate --update’ once: it’ll
create an up-to-date database under ~/.cache, which will then be used
unconditionally.

Ludo’.

Previous Next

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