From owner-freebsd-current@FreeBSD.ORG Thu Apr 11 08:30:55 2013 Return-Path: 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 3DAA6C4 for ; Thu, 11 Apr 2013 08:30:55 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: from mail-we0-x22c.google.com (mail-we0-x22c.google.com [IPv6:2a00:1450:400c:c03::22c]) by mx1.freebsd.org (Postfix) with ESMTP id C85ACA39 for ; Thu, 11 Apr 2013 08:30:54 +0000 (UTC) Received: by mail-we0-f172.google.com with SMTP id r3so1039675wey.3 for ; Thu, 11 Apr 2013 01:30:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:sender:date:from:to:cc:subject:message-id:references :mime-version:content-type:content-disposition:in-reply-to :user-agent; bh=abrAvPGevANUKYoEC9d73qBpn5I1FOjGrf7p12vLMio=; b=mN23qk7ILXsrHl5ZQfvBT2CVLn0bMu2/318ktcyBxFOsBEPVLPyY2+zD9l1wFSFw/T 7kOmvFXbu2NUr9cF3OkGWPGMot6Bg6szxugYsqDhlefwFNqkHBIy79l6LQ8JuYM+K6CF A9dMIFcN0H53cDSbRCeG2MT0tGQAvI9qOKcyYhMbQqtOMn11/imc68IlQqFyUo6aQIwB NaIEFA4wC1bwiZrpUDAZYthvAG3H2uKalH5RJ1Pe3aTuIMsRgr3YRHi2uq9U26gya7LB nCsiQouopQbcLSD78VOK7JLl0S1H0S+9m0w6h5MHPQO6ESHAttssLHYgqDHk2YE9P8TD iwqQ== X-Received: by 10.180.79.227 with SMTP id m3mr8557196wix.12.1365669053865; Thu, 11 Apr 2013 01:30:53 -0700 (PDT) Received: from ithaqua.etoilebsd.net (ithaqua.etoilebsd.net. [37.59.37.188]) by mx.google.com with ESMTPS id n2sm1608924wiy.6.2013.04.11.01.30.52 (version=TLSv1 cipher=RC4-SHA bits=128/128); Thu, 11 Apr 2013 01:30:53 -0700 (PDT) Sender: Baptiste Daroussin Date: Thu, 11 Apr 2013 10:30:50 +0200 From: Baptiste Daroussin To: "Eggert, Lars" Subject: Re: newnfs pkgng database corruption? Message-ID: <20130411083050.GD95891@ithaqua.etoilebsd.net> References: <4C9A5BAE-8607-4E3A-8E69-E3993EA9873F@netapp.com> <20130410080228.GB74304@ithaqua.etoilebsd.net> <2F60DB6E-768F-426C-9BE6-737B144D4776@netapp.com> <20130410221652.GB95891@ithaqua.etoilebsd.net> <33784095-E88E-4069-84E9-3A477483EC2E@netapp.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="tNQTSEo8WG/FKZ8E" Content-Disposition: inline In-Reply-To: <33784095-E88E-4069-84E9-3A477483EC2E@netapp.com> User-Agent: Mutt/1.5.21 (2010-09-15) 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 11 Apr 2013 08:30:55 -0000 --tNQTSEo8WG/FKZ8E Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Apr 11, 2013 at 05:52:52AM +0000, Eggert, Lars wrote: > Hi, >=20 > On Apr 11, 2013, at 0:16, Baptiste Daroussin wrote: > > Will you be able to test it? >=20 > yes. (But I will be traveling for the next two weeks and so the turnaroun= d may be a bit longer than normal.) >=20 > Lars First, I think you can recover your database. Can you try the following command: # mv /var/db/pkg/local.sqlite /var/db/pkg/backup.sqlite # echo '.dump' | pkg shell /var/db/pkg/backup.sqlite | pkg shell # echo 'pragma user_config=3D12;' | pkg shell This should give you again a working database I hope :) I think the corruption you get are due to the synchronous pragma. I need to= dig in that direction. regards, Bapt --tNQTSEo8WG/FKZ8E Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iEYEARECAAYFAlFmdLoACgkQ8kTtMUmk6EyyiACfXxz7JotkRRDyLHedE4iOmMbT T4gAmwVK1rKM8pRwUP1rqKvB/K3GnqLA =GYpY -----END PGP SIGNATURE----- --tNQTSEo8WG/FKZ8E--