Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 11 Dec 2012 19:32:03 +0100
From:      Mathias Picker <Mathias.Picker@virtual-earth.de>
To:        freebsd-ports@freebsd.org
Subject:   Re: pkgng: sqlite: database is locked
Message-ID:  <1355250723.48552.32.camel@mp>
In-Reply-To: <50C7751D.9010107@FreeBSD.org>
References:  <1355235219.48552.9.camel@mp>  <50C7751D.9010107@FreeBSD.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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@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@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-ports
> To unsubscribe, send any mail to "freebsd-ports-unsubscribe@freebsd.org"





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1355250723.48552.32.camel>