Date: Tue, 18 Nov 2014 16:18:33 -0800 From: "Chris H" <bsd-lists@bsdforge.com> To: "FreeBSD ports" <freebsd-ports@FreeBSD.org>, "FreeBSD STABLE" <freebsd-stable@freebsd.org> Subject: How to recover local.sqlite (pkg(8) problem) Message-ID: <61ee02eda8e8d3c86fadc175453ffb68@ultimatedns.net>
next in thread | raw e-mail | index | archive | help
Greetings, 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 sqlite3 local.sqlite followed by read pkg.sql and quit went w/o issue. But issuing pkg info emitted several error messages. Which appeared to be from sqlite3(8). 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. --Chris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?61ee02eda8e8d3c86fadc175453ffb68>