Re: newnfs pkgng database corruption?

On Thu, Apr 11, 2013 at 05:52:52AM +0000, Eggert, Lars wrote:
> Hi,
> 
> On Apr 11, 2013, at 0:16, Baptiste Daroussin <bapt_at_freebsd.org> wrote:
> > Will you be able to test it?
> 
> yes. (But I will be traveling for the next two weeks and so the turnaround may be a bit longer than normal.)
> 
> Lars

First, I think you can recover your database.

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
# echo 'pragma user_config=12;' | pkg shell

This should give you again a working database I hope :)

I think the corruption you get are due to the synchronous pragma. I need to dig
in that direction.

regards,
Bapt