newnfs pkgng database corruption?

[Eggert, Lars]

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.

> 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