newnfs pkgng database corruption?

[Baptiste Daroussin]

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
-------------- 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/8983dfe2/attachment.sig>