[Bug 213611] ports-mgmt/pkg: 1.9.1 pkgdb locking doesn't work on NFS

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=213611

--- Comment #3 from dornergd <gerhard.dorner at hob.de> ---
I have tested pkg 1.9.4 and still get the same error in combination with NFS:
"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 
DBG(1)[22647]> pkg initialized
DBG(4)[22647]> Pkgdb: running 'PRAGMA user_version;'
DBG(4)[22647]> Pkgdb: executing 'PRAGMA foreign_keys = ON;'
DBG(4)[22647]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO mtree(content)
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.

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