From owner-freebsd-current@FreeBSD.ORG  Wed Apr 10 23:29:20 2013
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
Delivered-To: current@freebsd.org
Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115])
 by hub.freebsd.org (Postfix) with ESMTP id 3313DAE2
 for <current@freebsd.org>; Wed, 10 Apr 2013 23:29:20 +0000 (UTC)
 (envelope-from rmacklem@uoguelph.ca)
Received: from esa-annu.net.uoguelph.ca (esa-annu.mail.uoguelph.ca
 [131.104.91.36]) by mx1.freebsd.org (Postfix) with ESMTP id F0E6015D
 for <current@freebsd.org>; Wed, 10 Apr 2013 23:29:19 +0000 (UTC)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AqIEAGr0ZVGDaFvO/2dsb2JhbABQgzyDK74ZgSN0gh8BAQEDAQEBASArIAsFFhgCAg0ZAikBCSYGCAcEARwEh20GDKw1kneBI4xBfjQHgi6BEwOUP4JBgSGPbYMnIDKBBTU
X-IronPort-AV: E=Sophos;i="4.87,450,1363147200"; d="scan'208";a="23381259"
Received: from erie.cs.uoguelph.ca (HELO zcs3.mail.uoguelph.ca)
 ([131.104.91.206])
 by esa-annu.net.uoguelph.ca with ESMTP; 10 Apr 2013 19:28:11 -0400
Received: from zcs3.mail.uoguelph.ca (localhost.localdomain [127.0.0.1])
 by zcs3.mail.uoguelph.ca (Postfix) with ESMTP id 343D1B3F4F;
 Wed, 10 Apr 2013 19:28:11 -0400 (EDT)
Date: Wed, 10 Apr 2013 19:28:11 -0400 (EDT)
From: Rick Macklem <rmacklem@uoguelph.ca>
To: Lars Eggert <lars@netapp.com>
Message-ID: <279486232.724924.1365636491154.JavaMail.root@erie.cs.uoguelph.ca>
In-Reply-To: <4C9A5BAE-8607-4E3A-8E69-E3993EA9873F@netapp.com>
Subject: Re: newnfs pkgng database corruption?
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Originating-IP: [172.17.91.203]
X-Mailer: Zimbra 6.0.10_GA_2692 (ZimbraWebClient - IE8 (Win)/6.0.10_GA_2692)
Cc: current@freebsd.org
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
 <freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-current>, 
 <mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
 <mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 10 Apr 2013 23:29:20 -0000

Lars Eggert wrote:
> Hi,
> 
> on a diskless server, I keep the ports tree and pkgng databases on a
> newnfs NFSv4 mount. After a bunch of "portmaster -a" runs, the pkgng
> sqlite database appears to get corrupted. For example, when I try to
> update an existing port, this happens:
> 
> root@five:~ # portmaster ports-mgmt/pkg
> ...
> ===> Registering installation for pkg-1.0.11
> Installing pkg-1.0.11...pkg: sqlite: database disk image is malformed
> (pkgdb.c:925)
> pkg: sqlite: database disk image is malformed (pkgdb.c:1914)
> *** [fake-pkg] Error code 70
> 
Error code 70 is ESTALE (or NFSERR_STALE, if you prefer). The server
replies with that when the file no longer exists.

File locking doesn't stop a file from being removed, as far as I know.

rick

> I have removed all ports and the pkgng databases and reinstalled, but
> the corruption seems to return after a few days or weeks of installing
> and deinstalling ports.
> 
> On another system that has a disk, that corruption of the pkgng
> database has not happened over six months or so. I therefore wonder if
> storing the sqlite database on an NFS-mount is triggering some sort of
> bug, either in pkgng or in newnfs. AFAIK, pkgng is using locks on the
> database quite liberally, could that be where a bug is lurking?
> 
> I'm happy to help debug this, but someone would need to let me know
> what to try.
> 
> Thanks,
> Lars
> _______________________________________________
> freebsd-current@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-current
> To unsubscribe, send any mail to
> "freebsd-current-unsubscribe@freebsd.org"