sqlite error: database disk image is malformed (pkg 2.8.1)

From: void <void_at_f-m.fm>
Date: Mon, 10 Aug 2026 01:40:40 UTC
Hi,

Tried to upgrade from latest (today) ports tree

------------ snip ----------------------

root@pkg:/usr/ports/ports-mgmt/pkg# make deinstall reinstall
===>  Deinstalling for pkg
pkg-static: 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( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, NOW(), ?14, ?15, ?16 ) in file pkgdb.c:100: database disk image is malformed
===>   pkg not installed, skipping
===>  Deinstalling for pkg
pkg-static: 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( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, NOW(), ?14, ?15, ?16 ) in file pkgdb.c:100: database disk image is malformed
===>   pkg not installed, skipping
===>  Installing for pkg-2.8.1_1
===>  Checking if pkg is already installed
pkg-static: 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( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, NOW(), ?14, ?15, ?16 ) in file pkgdb.c:100: database disk image is malformed
*** Error code 1

Stop.
make[3]: stopped making "install-message identify-install-conflicts check-already-installed create-manifest fake-pkg security-check" in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make[2]: stopped making "/usr/ports/ports-mgmt/pkg/work/.install_done.pkg._usr_local" in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make[1]: stopped making "deinstall install" in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make: stopped making "deinstall reinstall" in /usr/ports/ports-mgmt/pkg

--