From owner-freebsd-ports@FreeBSD.ORG Tue Dec 11 18:32:08 2012 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 3F7CA86B for ; Tue, 11 Dec 2012 18:32:08 +0000 (UTC) (envelope-from Mathias.Picker@virtual-earth.de) Received: from www94.your-server.de (www94.your-server.de [213.133.104.94]) by mx1.freebsd.org (Postfix) with ESMTP id E68C58FC15 for ; Tue, 11 Dec 2012 18:32:07 +0000 (UTC) Received: from [92.230.244.199] (helo=[192.168.178.33]) by www94.your-server.de with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.74) (envelope-from ) id 1TiUcg-0004JJ-V7 for freebsd-ports@freebsd.org; Tue, 11 Dec 2012 19:32:07 +0100 Subject: Re: pkgng: sqlite: database is locked From: Mathias Picker To: freebsd-ports@freebsd.org In-Reply-To: <50C7751D.9010107@FreeBSD.org> References: <1355235219.48552.9.camel@mp> <50C7751D.9010107@FreeBSD.org> Content-Type: text/plain; charset="UTF-8" Organization: virtual earth GmbH Date: Tue, 11 Dec 2012 19:32:03 +0100 Message-ID: <1355250723.48552.32.camel@mp> Mime-Version: 1.0 X-Mailer: Evolution 2.32.1 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Authenticated-Sender: Mathias.Picker@virtual-earth.de X-Virus-Scanned: Clear (ClamAV 0.97.5/15722/Tue Dec 11 18:11:13 2012) X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 11 Dec 2012 18:32:08 -0000 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"