From owner-freebsd-ports@FreeBSD.ORG  Tue Dec 11 18:32:08 2012
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
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 <freebsd-ports@freebsd.org>; 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 <freebsd-ports@freebsd.org>; 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 <Mathias.Picker@virtual-earth.de>)
 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 <Mathias.Picker@virtual-earth.de>
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 <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=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"