• Re: PKG error 14.3-STABLE, just this morning

    From Michael Proto@mike@jellydonut.org to muc.lists.freebsd.stable on Tue Jan 6 18:44:17 2026
    From Newsgroup: muc.lists.freebsd.stable

    On Thu, Dec 18, 2025 at 6:38rC>AM Karl Denninger <karl@denninger.net> 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
    --
    Posted automagically by a mail2news gateway at muc.de e.V.
    Please direct questions, flames, donations, etc. to news-admin@muc.de
    --- Synchronet 3.21a-Linux NewsLink 1.2