Re: Recover from a corrupt pkg DB

From: Piotr Smyrak <ps.ports_at_smyrak.com>
Date: Tue, 30 Aug 2022 17:26:32 UTC 
On Tue, 30 Aug 2022 09:36:52 -0700
Kevin Oberman <rkoberman@gmail.com> wrote:

> I had a crash while building ffmpeg on a new system. The build had not
> begun, so I don't think ffmpeg is really an issue. portmaster(8) was
> walking the dependency tree when the system panicked and, after a
> reboot and full fsck, I get the error:
> pkg: sqlite error while executing PRAGMA user_version; in file
> pkgdb.c:2357: database disk image is malformed
> 
> Is there any way to rebuild the DB or, if not, how do I remove it and
> start from scratch?

The DB is located in /var/db/pkg.

-- 
 Piotr Smyrak