How to recover local.sqlite (pkg(8) problem)
bsd-lists at bsdforge.com
Wed Nov 19 00:17:44 UTC 2014
During the building of a meta-port in the ports tree. My
/var/db/pkg/local.sqlite database became corrupted. I
spent some time, both with the pkg man pages, and with
sqlite3 itself attempting to use one of the backups
created by periodic(8). Located in /var/backups. But all
to no avail. For the record, I used
pkg backup -r /var/backup/pkg.sql.xz, as well as unpacking
a copy of that file, and issuing the same. Moving (renaming)
the corrupted database aside, prior to. I also issued
went w/o issue. But issuing
emitted several error messages. Which appeared to be from
This is on RELENG_9, w/source, and kernel world from about
1 week ago. I know that the backup is in good shape, as I
had been using it w/o issue.
Is this a bug?
Thank you for all your time, and consideration.
More information about the freebsd-stable