[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

            Bug ID: 297443
           Summary: ports-mgmt/pkg pkg cannot update anything pkg-static:
                    sqlite error while executing PRAGMA errors
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: [email protected]
          Reporter: [email protected]
          Assignee: [email protected]
             Flags: maintainer-feedback?([email protected])

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

-- 
You are receiving this mail because:
You are the assignee for the bug.