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

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

Dec 17, 2025

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.

 

[Alain De Vos]

Same problem? . No fix ...

 

[Jiri Smejkal]

Yes, we have the same problem.
Fresh install of FREEBSD-15, freebsd-update p1 and package cannot be installed.

pkg update
Updating FreeBSD-ports repository catalogue...
Fetching meta.conf: 100% 179 B 0.2kB/s 00:01
Fetching data.pkg: 100% 10 MiB 2.1MB/s 00:05
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!

 

[Stanford Mings]

Getting the same.

 

[Alain De Vos]

Last news, work in progress, waiting for the fix to be pusht to the mirrors.

 

[Alain De Vos]

It's fixed. Wait one day, until mirrors get updated.

 

[StreamThreader]

I have the same.

 

[StreamThreader]

Updating FreeBSD-ports repository catalogue...
Fetching meta.conf: 100% 179 B 0.2kB/s 00:01
Fetching data.pkg: 100% 10 MiB 10.7MB/s 00:01
Processing entries: 100%
FreeBSD-ports repository update completed. 36390 packages processed.
Updating FreeBSD-ports-kmods repository catalogue...
Fetching data.pkg: 100% 31 KiB 31.3kB/s 00:01
Processing entries: 100%
FreeBSD-ports-kmods repository update completed. 204 packages processed.
Updating FreeBSD-base repository catalogue...
FreeBSD-base repository is up to date.
All repositories are up to date.

It Works, Thanks!