From owner-freebsd-current@FreeBSD.ORG Thu Apr 11 08:44:11 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 56DA646E; Thu, 11 Apr 2013 08:44:11 +0000 (UTC) (envelope-from lars@netapp.com) Received: from mx12.netapp.com (mx12.netapp.com [216.240.18.77]) by mx1.freebsd.org (Postfix) with ESMTP id 10C8CAE7; Thu, 11 Apr 2013 08:44:11 +0000 (UTC) X-IronPort-AV: E=Sophos;i="4.87,454,1363158000"; d="scan'208";a="39414989" Received: from smtp1.corp.netapp.com ([10.57.156.124]) by mx12-out.netapp.com with ESMTP; 11 Apr 2013 01:44:03 -0700 Received: from vmwexceht03-prd.hq.netapp.com (vmwexceht03-prd.hq.netapp.com [10.106.76.241]) by smtp1.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id r3B8i16H016710; Thu, 11 Apr 2013 01:44:03 -0700 (PDT) Received: from VMWEXCEHT06-PRD.hq.netapp.com (10.106.77.104) by vmwexceht03-prd.hq.netapp.com (10.106.76.241) with Microsoft SMTP Server (TLS) id 14.2.342.3; Thu, 11 Apr 2013 01:44:02 -0700 Received: from SACEXCMBX01-PRD.hq.netapp.com ([169.254.2.71]) by vmwexceht06-prd.hq.netapp.com ([10.106.77.104]) with mapi id 14.02.0342.003; Thu, 11 Apr 2013 01:44:02 -0700 From: "Eggert, Lars" To: Baptiste Daroussin Subject: Re: newnfs pkgng database corruption? Thread-Topic: newnfs pkgng database corruption? Thread-Index: AQHONb70L4N2OxTqe06kCtiGiwd7apjPjVcAgAACBgCAAOyyAIAAf2iAgAAsIgCAAAOwAA== Date: Thu, 11 Apr 2013 08:44:01 +0000 Message-ID: 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> In-Reply-To: <20130411083050.GD95891@ithaqua.etoilebsd.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.53.51] Content-Type: text/plain; charset="us-ascii" Content-ID: <56EF7777CE31FF4FA703DF46C573A1ED@tahoe.netapp.com> Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 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:44:11 -0000 Hi, On Apr 11, 2013, at 10:30, Baptiste Daroussin wrote: > First, I think you can recover your database. that would be great. > 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 That step doesn't quite work: [root@stanley /usr/home/elars/local/db]# echo '.dump' | pkg shell backup.sq= lite | 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 [root@stanley /usr/home/elars/local/db]# ll local.sqlite=20 -rw-r--r-- 1 root wheel 0 Apr 11 10:42 local.sqlite I can send you the database off-list, if you like. > I think the corruption you get are due to the synchronous pragma. I need = to dig > in that direction. Thanks for looking into this! Lars=