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