Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 30 Aug 2022 09:36:52 -0700
From:      Kevin Oberman <rkoberman@gmail.com>
To:        FreeBSD Ports ML <freebsd-ports@freebsd.org>
Subject:   Recover from a corrupt pkg DB
Message-ID:  <CAN6yY1vGf=LdXQ4DZjJRxho2t%2BNcGd0jt2-T7nhm84YjtCKN5g@mail.gmail.com>

next in thread | raw e-mail | index | archive | help
--000000000000db27a205e777ff64
Content-Type: text/plain; charset="UTF-8"

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?
-- 
Kevin Oberman, Part time kid herder and retired Network Engineer
E-mail: rkoberman@gmail.com
PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683

--000000000000db27a205e777ff64
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:tahoma,s=
ans-serif;font-size:small"><br clear=3D"all"></div><div style=3D"font-famil=
y:tahoma,sans-serif;font-size:small" class=3D"gmail_default">I had a crash =
while building ffmpeg on a new system. The build had not begun, so I don&#3=
9;t think ffmpeg is really an issue. portmaster(8) was walking the dependen=
cy tree when the system panicked and, after a reboot and full fsck, I get t=
he error:</div><div style=3D"font-family:tahoma,sans-serif;font-size:small"=
 class=3D"gmail_default">pkg: sqlite error while executing PRAGMA user_vers=
ion; in file pkgdb.c:2357: database disk image is malformed</div><div style=
=3D"font-family:tahoma,sans-serif;font-size:small" class=3D"gmail_default">=
<br></div><div style=3D"font-family:tahoma,sans-serif;font-size:small" clas=
s=3D"gmail_default">Is there any way to rebuild the DB or, if not, how do I=
 remove it and start from scratch?<br></div>-- <br><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">Kevin Oberm=
an, Part time kid herder and retired Network Engineer<br>E-mail: <a href=3D=
"mailto:rkoberman@gmail.com" target=3D"_blank">rkoberman@gmail.com</a><br><=
/div><div>PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683</div></=
div></div></div></div></div></div></div></div>

--000000000000db27a205e777ff64--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAN6yY1vGf=LdXQ4DZjJRxho2t%2BNcGd0jt2-T7nhm84YjtCKN5g>