maintainer-feedback requested: [Bug 297443] ports-mgmt/pkg pkg cannot update anything pkg-static: sqlite error while executing PRAGMA errors

Bugzilla Automation <bugzilla@FreeBSD.org> has asked freebsd-pkg (Nobody)
<pkg@FreeBSD.org> for maintainer-feedback:
Bug 297443: ports-mgmt/pkg pkg cannot update anything pkg-static: sqlite error
while executing PRAGMA errors
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297443



--- Description ---
Hi,

OS: 16.0-CURRENT #0 n287677-5c1461a2b0fd
ports is latest, there is no quarterly for -current



 pkg repos
FreeBSD-base: { 
    url 	    :
"pkg+https://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest",
    enabled	    : no,
    priority	    : 0,
    mirror_type     : "SRV",
    signature_type  : "FINGERPRINTS",
    fingerprints    : "/usr/share/keys/pkg"
  }
FreeBSD-ports: { 
    url 	    : "pkg+https://pkg.FreeBSD.org/FreeBSD:16:amd64/latest",
    enabled	    : yes,
    priority	    : 0,
    mirror_type     : "SRV",
    signature_type  : "FINGERPRINTS",
    fingerprints    : "/usr/share/keys/pkg"
  }
poudriere: { 
    url 	    : "file:///usr/local/poudriere/data/packages/pkg-default",
    enabled	    : no,
    priority	    : 0,
    mirror_type     : "SRV",
    signature_type  : "PUBKEY",
    pubkey	    : "/usr/local/etc/ssl/certs/poudriere.cert"
  }

% doas pkg version
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( ?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

% doas pkg update -f
Updating FreeBSD-ports repository catalogue...
Fetching meta.conf: 100%     168 B   0.2 kB/s	 00:01	  
Fetching data: 100%    12 MiB	3.2 MB/s    00:04    
Processing entries: 100%
FreeBSD-ports repository update completed. 37908 packages processed.
All repositories are up to date.

% doas pkg upgrade
Updating FreeBSD-ports repository catalogue...
FreeBSD-ports repository is up to date.
All repositories are up to date.
pkg: sqlite error while executing PRAGMA journal_mode = WAL; in file
pkgdb.c:2570: database disk image is malformed
pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:2607:
database disk image is malformed

can't update anything.

Installing from ports is broken, too. This happens with any port.

==>  Installing for libiconv-1.18_1
===>  Checking if libiconv 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