Date: Thu, 11 Apr 2013 13:19:02 +0200 From: Baptiste Daroussin <bapt@freebsd.org> To: "Eggert, Lars" <lars@netapp.com> Cc: "current@freebsd.org" <current@freebsd.org> Subject: Re: newnfs pkgng database corruption? Message-ID: <20130411111902.GE95891@ithaqua.etoilebsd.net> In-Reply-To: <B991CCB0-E6A0-4B55-8E91-BEBA7F430C39@netapp.com> 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> <B991CCB0-E6A0-4B55-8E91-BEBA7F430C39@netapp.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--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 <bapt@freebsd.org> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20130411111902.GE95891>