Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 14 Dec 2016 08:40:10 +0000
From:      bugzilla-noreply@freebsd.org
To:        pkg@FreeBSD.org
Subject:   [Bug 213611] ports-mgmt/pkg: 1.9.1 pkgdb locking doesn't work on NFS
Message-ID:  <bug-213611-32340-ZyaSVdwV1M@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-213611-32340@https.bugs.freebsd.org/bugzilla/>
References:  <bug-213611-32340@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D213611

--- Comment #3 from dornergd <gerhard.dorner@hob.de> ---
I have tested pkg 1.9.4 and still get the same error in combination with NF=
S:
"pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1033:
database is locked.

To get more information I activated the debug output:
# pkg -dddd info=20
DBG(1)[22647]> pkg initialized
DBG(4)[22647]> Pkgdb: running 'PRAGMA user_version;'
DBG(4)[22647]> Pkgdb: executing 'PRAGMA foreign_keys =3D ON;'
DBG(4)[22647]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO mtree(cont=
ent)
VALUES(?1)'
...
DBG(4)[22647]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO
requires(require) VALUES(?1)'
DBG(4)[22647]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid,
version, comment, desc, message, arch, maintainer, www, prefix, flatsize,
licenselogic, automatic, locked, time, manifestdigest, vital FROM packages =
AS p
ORDER BY p.name;'
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1033:
database is locked

But when I start "pkg shell" and run the "SELECT"-statement there, I get a =
list
of all my installed packages,

Additional I found out that this problem exists since version 1.9.0.

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-213611-32340-ZyaSVdwV1M>