pkg: sqlite error while executing INSERT OR REPLACE INTO packages

From: Antonio Olivares <olivares14031_at_gmail.com>
Date: Wed, 26 Jul 2023 18:24:33 UTC
Dear FreeBSD users,

I have updated an old machine from 13.1 to 13.2 RELEASE successfully
updated packages as well.  I ran pkg upgrade and I run into error on
subject line.

How can I fix this?  THanks in advace

root@coolermaster:~ # pkg clean
Nothing to do.
root@coolermaster:~ # pkg update
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
root@coolermaster:~ # pkg upgrade
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (7 candidates): 100%
Processing candidates (7 candidates): 100%
Checking integrity... done (0 conflicting)
The following 3 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
    firefox-esr: 102.13.0,1 -> 102.14.0,1
    llvm13: 13.0.1_3 -> 13.0.1_4
    llvm15: 15.0.7_4 -> 15.0.7_5

Number of packages to be upgraded: 3

Proceed with this action? [y/N]: y
[1/3] Upgrading llvm13 from 13.0.1_3 to 13.0.1_4...
pkg: sqlite error while executing INSERT OR REPLACE INTO packages(
origin, name, version, comment, desc, message, arch, maintainer, www,
prefix, flatsize, automatic, licenselogic, time, manifestdigest,
dep_formula, vital)VALUES( 'devel/llvm13', 'llvm13', '13.0.1_4', 'LLVM
and Clang', 'The LLVM Project is a collection of modular and reusable
compiler and
toolchain technologies.

This port includes Clang (a C/C++/Objective-C compiler), LLD (a linker),
LLDB (a debugger), an OpenMP runtime library, and the LLVM infrastructure
these are built on.

WWW: https://llvm.org/', NULL, 'FreeBSD:13:amd64',
'brooks@FreeBSD.org', 'https://llvm.org/', '/usr/local', 1489141387,
1, 38, NOW(), '2$2$9qhfm9hkp49p6x6rcsnwihbimh7thmks8j88837zpz7qs9jjqogqfp37ge93nogz8bcezexxmd4cn33jcakncm38dgyokdmtrfr6ykn',
NULL, 0 ) in file pkgdb.c:1633: database disk image is malformed
root@coolermaster:~ #

Best Regards,


Antonio