pkgng database corrupt, can't seem to fix it.

[wonslung]

I get this error when i try to use pkgng

pkg: sqlite: database disk image is malformed (pkgdb.c:3069)
pkg: Unable to query repository

[bapt]

any details would be great ;)
probably a simple rm /var/db/pkg/repo-* will solve your problem,

otherwise what version of pkg are you using,
can you also add a pkg -vv output to the report

[wonslung]

Thanks, that worked. I found the old issue with that and was just about to post it. Thanks so much.

Thomas Burgess
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)

On Saturday, November 2, 2013 at 6:04 PM, Baptiste Daroussin wrote:

any details would be great ;)
probably a simple rm /var/db/pkg/repo-* will solve your problem,
otherwise what version of pkg are you using,
can you also add a pkg -vv output to the report

—
Reply to this email directly or view it on GitHub (#633 (comment)).

[bapt]

I keep this open as we need to detect and fix this properly

[hamsolodev]

I just came across this also. @bapt 's suggestion to remove /var/db/pkg/repo-* did the trick for me. Corruption happened when I interrupted with C-c during a (seemingly) infinite loop of scrolling messages from 'pkg update'.

[ScottSturdivant]

Same here, I too was impatient and assumed that the scrolling message during the pkg update was an unrecoverable error. It was scrolling with:

pkg: Skipping malformed dependency docbook-xml
pkg: Skipping malformed dependency docbook

After I C-c'd, the db was corrupt and rm'ing /var/db/pkg-repo-* worked.

If when doing the pkg update you get the same stuff scrolling by, be patient, and let it complete!

[hamsolodev]

@SirScott aye, I realised this after I’d deleted /var/db/pkg-repo-* then ran pkg update and saw the same messages again. Patience! All the same, C-c shouldn’t corrupt the pkg db. It was terrifying ;)

[bapt]

Fixed