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

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