Re: newnfs pkgng database corruption?

On Thu, Apr 11, 2013 at 08:44:01AM +0000, Eggert, Lars wrote:
> Hi,
> 
> On Apr 11, 2013, at 10:30, Baptiste Daroussin <bapt_at_freebsd.org> wrote:
> > First, I think you can recover your database.
> 
> that would be great.
> 
> > 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
> 
> That step doesn't quite work:
> 
> [root_at_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
> 
> [root_at_stanley /usr/home/elars/local/db]# ll local.sqlite 
> -rw-r--r--  1 root  wheel  0 Apr 11 10:42 local.sqlite
> 
> I can send you the database off-list, if you like.
> 
Yes please.

regards,
Bapt