newnfs pkgng database corruption?

[Baptiste Daroussin]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 196 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-current/attachments/20130411/71810843/attachment.sig>