pkgng: sqlite: database is locked

[Mathias Picker]

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.

Thanks, Mathias

> 
> --
> Regards,
> olli
> _______________________________________________
> freebsd-ports at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-ports
> To unsubscribe, send any mail to "freebsd-ports-unsubscribe at freebsd.org"