pkgng: sqlite: database is locked

Baptiste Daroussin bapt at FreeBSD.org
Tue Dec 11 18:37:11 UTC 2012


On Tue, Dec 11, 2012 at 07:32:03PM +0100, Mathias Picker wrote:
> Am Dienstag, den 11.12.2012, 19:02 +0100 schrieb Olli Hauer:
> > On 2012-12-11 15:13, Mathias Picker wrote:
> > > I'm getting sqlite: database is locked errors with pkg. For deinstalls
> > > (portmaster updates) and fresh port installs with make install. The
> > > latest is
> > > 
> > > ===>   Registering installation for MuSE-0.9.2_14
> > > Installing MuSE-0.9.2_14... done
> > > pkg: sqlite: database is locked
> > > 
> > > which results in muse not being registered in the pkg database...
> > > 
> > > How can I investigate this further? This persists between reboots, and
> > > for fresh pkg runs. 
> > > 
> > > I'm hesitating to upgrade all the changes after the ports freeze has
> > > been lifted...
> > > 
> > > I'm using a FreeBSD-stable and have changed to pkgng maybe two weeks
> > > ago. At the first portmaster -a after the upgrade, I think everything
> > > went smooth, and then more and more of these errors popped up.
> > > Everything is build using gcc.
> > > 
> > > mp# uname -a
> > > FreeBSD mp.virtual-earth.de 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #28
> > > r243882: Wed Dec  5 18:28:39 CET 2012
> > > mathiasp at mp.virtual-earth.de:/usr/obj/usr/src/sys/GENERIC  amd64
> > > 
> > > mp# pkg -v
> > > 1.0.3
> > > 
> > > Any help apreciated,
> > > 
> > > Mathias
> > > 
> > 
> > Hi Mathias,
> > 
> > maybe you could find with one of the commands the process which
> > locks the database.
> > 
> > #> fstat /var/db/pkg/pkgdb.db /var/db/pkg/local.sqlite
> > #> sockstat | grep -e local.sqlite -e pkgdb.db
> 
> OK:
> mp# fstat /var/db/pkg/pkgdb.db /var/db/pkg/local.sqlite
> USER     CMD          PID   FD MOUNT      INUM MODE         SZ|DV R/W
> NAME
> mp# sockstat | grep -e local.sqlite -e pkgdb.db
> mp# 
> 
> I retried the muse install which gave me an error before, now it works
> fine?? Maybe it's only after portmaster runs?
> 
> Maybe a pkg invocation which does not release the lock? I will look into
> this again.
> 

The lock is always release at the end of the pkg invocation, the only way to get
there is multiple pkg running at the same time and even there the lock should
stay for long.

If you manage to reproduce I'd be very intersted in the way how to reproduce
and/or the debug information :)

regards,
Bapt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 196 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20121211/e19f7ba5/attachment.sig>


More information about the freebsd-ports mailing list