pkg: sqlite error while executing grmbl in file update.c

[Ramiro Aceves]

Hello,

I have this error when updating FreeBSD-ports catalogue.

root@freebsd-nuc8i7:~ # pkg update
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.
Updating FreeBSD-base repository catalogue...
FreeBSD-base repository is up to date.
Error updating repositories!
root@freebsd-nuc8i7:~ #

root@freebsd-nuc8i7:~ # pkg search genmon
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
xfce4-genmon-plugin-4.3.0      Generic Monitor Xfce4 panel plugin
root@freebsd-nuc8i7:~ #

root@freebsd-nuc8i7:~ # pkg search genmon
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
xfce4-genmon-plugin-4.3.0      Generic Monitor Xfce4 panel plugin
root@freebsd-nuc8i7:~ # pkg install xfce4-genmon-plugin
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.
Updating FreeBSD-base repository catalogue...
FreeBSD-base repository is up to date.
Error updating repositories!
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    xfce4-genmon-plugin: 4.3.0 [FreeBSD-ports]

Number of packages to be installed: 1

70 KiB to be downloaded.

Proceed with this action? [y/N]: y
pkg: Failed to fetch
https://pkg.FreeBSD.org/FreeBSD:15:amd64/quarterly/All/Hashed/xfce4-genmon-plugin-4.3.0~9e979c42c8.pkg:
Not found
pkg: Failed to fetch
https://pkg.FreeBSD.org/FreeBSD:15:amd64/quarterly/All/Hashed/xfce4-genmon-plugin-4.3.0~9e979c42c8.pkg:
Not found
root@freebsd-nuc8i7:~ #

root@freebsd-nuc8i7:~ # uname -a
FreeBSD freebsd-nuc8i7 15.0-RELEASE FreeBSD 15.0-RELEASE
releng/15.0-n280995-7aedc8de6446 GENERIC amd64

root@freebsd-nuc8i7:~ # pkg -vv | grep -E 'ABI|url'
libcurl                 : libcurl/8.16.0 OpenSSL/3.5.4 zlib/1.3.1
ABI = "FreeBSD:15:amd64";
ALTABI = "freebsd:15:x86:64";
    url             :
"pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/quarterly",
    url             :
"pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/kmods_quarterly_0",
    url             :
"pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/base_release_0",
root@freebsd-nuc8i7:~ #


Thanks in advance.

Ramiro.

[Graham Perrin]

Which version of pkg?

NB <https://www.freshports.org/ports-mgmt/pkg/#packages>

<https://github.com/freebsd/pkg/issues/2584>

<https://lists.freebsd.org/archives/freebsd-pkg/>

[Tomek CEDRO]

On Tue, Jan 6, 2026 at 4:06 PM Ramiro Aceves wrote:
> Hello,
> I have this error when updating FreeBSD-ports catalogue.
> root@freebsd-nuc8i7:~ # pkg update
> 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.
> Updating FreeBSD-base repository catalogue...
> FreeBSD-base repository is up to date.
> Error updating repositories!

> (..)

I had this problem too yesterday and it seems to be fixed now :-)

--
CeDeROM, SQ7MHZ, http://www.tomek.cedro.info

[Simon Wollwage]

Ramiro Aceves <ea1...@gmail.com> writes:

This is already tracked in https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292214

[Ramiro Aceves]

El 6/1/26 a las 19:32, Tomek CEDRO escribió:

Seems to be still broken here.
Regards.
Ramiro, EA4NZ.

[Ramiro Aceves]

El 6/1/26 a las 19:26, Graham Perrin escribió:
> Which version of pkg?

Thanks for answering

root@freebsd-nuc8i7:/home/ramiro # pkg info | grep pkg
FreeBSD-pkg-bootstrap-15.0 pkg(7) bootstrap utility
pkg-2.4.2 Package manager

[Ramiro Aceves]

El 6/1/26 a las 19:37, Simon Wollwage escribió:

> Ramiro Aceves <ea1...@gmail.com> writes:
>
> This is already tracked in https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292214
>
>

Thanks so much, we will wait for the fix.

Regards.

[Tomek CEDRO]

On Tue, Jan 6, 2026 at 11:14 PM Ramiro Aceves <ea1...@gmail.com> wrote:
> El 6/1/26 a las 19:32, Tomek CEDRO escribió:

> > I had this problem too yesterday and it seems to be fixed now :-)
>

> Seems to be still broken here.

Ah I reinstalled pkg 2.5.1 from /usr/ports/ports-mgmt/pkg that worked for me :-)

[Graham Perrin]

On 06/01/2026 23:59, Tomek CEDRO wrote:
> … I reinstalled pkg 2.5.1 from /usr/ports/ports-mgmt/pkg that worked for me :-)

Maybe coincidence. The report in Bugzilla is not yet closed.

<https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292214>

[Simon Wollwage]

Graham Perrin <graham...@gmail.com> writes:

My guess is that it's not fully rolled out to all mirrors yet, so some
people are still affected. I still was until an hour ago.

Simon

[Ramiro Aceves]

El 7/1/26 a las 4:36, Simon Wollwage escribió:

It is working now fine, thanks to all.
Regards.
Ramiro.