From owner-freebsd-current@FreeBSD.ORG Thu Apr 11 11:19:06 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 DFCB8BCC for ; Thu, 11 Apr 2013 11:19:06 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: from mail-wi0-x233.google.com (mail-wi0-x233.google.com [IPv6:2a00:1450:400c:c05::233]) by mx1.freebsd.org (Postfix) with ESMTP id 74FC92EB for ; Thu, 11 Apr 2013 11:19:06 +0000 (UTC) Received: by mail-wi0-f179.google.com with SMTP id hn17so425612wib.6 for ; Thu, 11 Apr 2013 04:19:05 -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=+pwbM+syOtcUXT8Xjjd4B6dh9xomeyeQt/fnRpBFPdc=; b=SNFhEprijeDyj7WP6z+90tEoirDbP6hn1+h8UAZgTnSYGJDyzKT+ltaS2YJoXCZWoN Obhf2iRPtkPicexYUNoWQQ9OSKheuDfo2SPychb4pLdyKiUN2ceL2Dyj4ZS9xGd/Kg5c DuNGeF8QJsUvVrTIyF+bVPCF6fOtWSXHa4NDTkcfCd0quzqoxwzId7ZLYm277NqqnfFk X1imRRbYzDFnFolcFnaTbn3DG0KHH5HBaiCavd7qJTUInth9jncQPOp8nJ5Nqp5Wse7J VdmGMW3r/ca3MW8l5LE00wTlPOHpFA3q2EltzG2+zMmQDdeHYY8xFnpc+8VTXrk1intf i3dQ== X-Received: by 10.194.89.169 with SMTP id bp9mr9889836wjb.57.1365679145469; Thu, 11 Apr 2013 04:19:05 -0700 (PDT) Received: from ithaqua.etoilebsd.net (ithaqua.etoilebsd.net. [37.59.37.188]) by mx.google.com with ESMTPS id fv2sm2775091wib.6.2013.04.11.04.19.04 (version=TLSv1 cipher=RC4-SHA bits=128/128); Thu, 11 Apr 2013 04:19:04 -0700 (PDT) Sender: Baptiste Daroussin Date: Thu, 11 Apr 2013 13:19:02 +0200 From: Baptiste Daroussin To: "Eggert, Lars" Subject: Re: newnfs pkgng database corruption? Message-ID: <20130411111902.GE95891@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> <20130411083050.GD95891@ithaqua.etoilebsd.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="cYtjc4pxslFTELvY" Content-Disposition: inline In-Reply-To: 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 11:19:06 -0000 --cYtjc4pxslFTELvY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Apr 11, 2013 at 08:44:01AM +0000, Eggert, Lars wrote: > Hi, >=20 > On Apr 11, 2013, at 10:30, Baptiste Daroussin wrote: > > First, I think you can recover your database. >=20 > that would be great. >=20 > > Can you try the following command: > >=20 > > # mv /var/db/pkg/local.sqlite /var/db/pkg/backup.sqlite > > # echo '.dump' | pkg shell /var/db/pkg/backup.sqlite | pkg shell >=20 > That step doesn't quite work: >=20 > [root@stanley /usr/home/elars/local/db]# echo '.dump' | pkg shell backup.= sqlite | pkg shell > Error: near line 15927: column path is not unique > Error: near line 15928: column path is not unique > Error: near line 15929: column path is not unique > Error: near line 15930: column path is not unique > Error: near line 15931: column path is not unique > Error: near line 15932: column path is not unique > Error: near line 15933: column path is not unique > Error: near line 15934: column path is not unique > Error: near line 15935: column path is not unique > Error: near line 15936: column path is not unique > Error: near line 15937: column path is not unique >=20 > [root@stanley /usr/home/elars/local/db]# ll local.sqlite=20 > -rw-r--r-- 1 root wheel 0 Apr 11 10:42 local.sqlite >=20 > I can send you the database off-list, if you like. >=20 Yes please. regards, Bapt --cYtjc4pxslFTELvY Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iEYEARECAAYFAlFmnCYACgkQ8kTtMUmk6EwDiwCfSAh+5obx0i0H1K3oKwasIGRZ 2m0An3ZDIUPg7CwhX6BKOo5L78vk8HB8 =qwyF -----END PGP SIGNATURE----- --cYtjc4pxslFTELvY--