Error while "pkg -v" after FreeBSD 15R got updated to today's patch 1 (P1)

[athan]

The described issue first occurred immediately after FreeBSD 15R was updated to the latest (today's) patch (P1).
The command I used "pkg v -vRL="
After fetching data.pkg and processing entries I've got this:

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

My /etc/pkg/FreeBSD.conf follows (just enabled latest package repo)

#
# To disable a repository, instead of modifying or removing this file,
# create a /usr/local/etc/pkg/repos/FreeBSD.conf file, e.g.:
#
#   mkdir -p /usr/local/etc/pkg/repos
#   echo "FreeBSD-ports: { enabled: no }" > /usr/local/etc/pkg/repos/FreeBSD.conf
#   echo "FreeBSD-ports-kmods: { enabled: no }" >> /usr/local/etc/pkg/repos/FreeBSD.conf
#
# Note that the FreeBSD-base repository is disabled by default.
#

FreeBSD-ports: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/latest",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkg",
  enabled: yes
}
FreeBSD-ports-kmods: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/kmods_latest_${VERSION_MINOR}",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkg",
  enabled: yes
}
FreeBSD-base: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/base_release_${VERSION_MINOR}",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkgbase-${VERSION_MAJOR}",
  enabled: no
}

Any idea?

 

[Charlie_]

C

Post in thread 'Updating error on 15.0p1 (pkgbase)'

Today at 1:39 PM

while updating repos, pkg: sqlite error while executing grmbl in file update.c:171: NOT NULL constraint failed: packages.path #2575

while updating repos, pkg: sqlite error while executing grmbl in file update.c:171: NOT NULL constraint failed: packages.path · Issue #2575 · freebsd/pkg

# pkg update -r FreeBSD-ports Updating FreeBSD-ports repository catalogue... Fetching data.pkg: 100% 10 MiB 2.2MB/s 00:05 Processing entries: 99% pkg: sqlite error while executing grmbl in file upd...

github.com

• Charlie_

• 

 

[athan]

Thanks for pointing that out to me.