Re: PKG error 14.3-STABLE, just this morning

On Thu, Dec 18, 2025 at 6:38 AM Karl Denninger <[email protected]> wrote:
>
> It updated the data.pkg file and I'm getting this...
>
> # pkg upgrade
> Updating FreeBSD repository catalogue...
> Fetching data.pkg: 100%   11 MiB  11.1MB/s    00:01
> Processing entries:  99%
> pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path
> pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path
> pkg: sqlite error while executing INSERT OR REPLACE INTO packages (origin, name, version, comment, desc, arch, maintainer, www, prefix, pkgsize, flatsize, licenselogic, cksum, path, manifestdigest, olddigest, vital)VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17) in file update.c:158: not an error
> Processing entries:  99%
> Unable to update repository FreeBSD
> Updating FreeBSD-kmods repository catalogue...
> FreeBSD-kmods repository is up to date.
> Error updating repositories!
> Checking for upgrades (211 candidates): 100%
> Processing candidates (211 candidates): 100%
> Checking integrity... done (0 conflicting)
> Your packages are up to date.
> # uname -v
> FreeBSD 14.3-RELEASE-p5 GENERIC
>

I'm seeing this same situation as of this morning on my FreeBSD 15
boxes (upgraded from 14.3):

 $ sudo pkg upgrade
Updating FreeBSD-ports repository catalogue...
Fetching data.pkg: 100%   10 MiB  10.7MB/s    00:01
Processing entries:  99%
pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL
constraint failed: packages.path
pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL
constraint failed: packages.path
pkg: sqlite error while executing INSERT OR REPLACE INTO packages
(origin, name, version, comment, desc, arch, maintainer, www, prefix,
pkgsize, flatsize, licenselogic, cksum, path, manifestdigest,
olddigest, vital)VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11,
?12, ?13, ?14, ?15, ?16, ?17) in file update.c:158: not an error
Processing entries:  99%
Unable to update repository FreeBSD-ports
Updating FreeBSD-ports-kmods repository catalogue...
FreeBSD-ports-kmods repository is up to date.
Error updating repositories!
Checking for upgrades (1 candidates): 100%
Processing candidates (1 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.

 $ pkg info | grep pkg
pkg-2.4.2                      Package manager
 $ uname -v
FreeBSD 15.0-RELEASE releng/15.0-n280995-7aedc8de6446 GENERIC
 $ freebsd-version -rku
15.0-RELEASE
15.0-RELEASE
15.0-RELEASE-p1

I've run 'pkg install -f pkg' and 'pkg bootstrap -f' to force a
download of the latest version of pkg (no change in version or
behavior) and am using the default repo configuration
(/etc/pkg/FreeBSD.conf):
FreeBSD-ports: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/quarterly",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkg",
  enabled: yes
}

Thanks