[Bug 292332] ports-mgmt/pkg sqlite error on ARM64

From: <bugzilla-noreply_at_freebsd.org>
Date: Wed, 14 Jan 2026 19:42:49 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292332

Torfinn Ingolfsen <tingox+freebsd@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tingox+freebsd@gmail.com

--- Comment #4 from Torfinn Ingolfsen <tingox+freebsd@gmail.com> ---
(In reply to staf wagemakers from comment #0)
Indeed.

root@devpi5:~ # freebsd-version -ku
14.3-RELEASE-p5
14.3-RELEASE-p7
root@devpi5:~ # uname -a
FreeBSD devpi5 14.3-RELEASE-p5 FreeBSD 14.3-RELEASE-p5 GENERIC arm64

root@devpi5:~ # pkg -vv | grep url
libcurl                 : libcurl/8.16.0 OpenSSL/3.0.16 zlib/1.3.1
    url             :
"pkg+https://pkg.FreeBSD.org/FreeBSD:14:aarch64/quarterly",
    url             :
"pkg+https://pkg.FreeBSD.org/FreeBSD:14:aarch64/kmods_quarterly_3",

root@devpi5:~ # pkg update
Updating FreeBSD repository catalogue...
Fetching data.pkg: 100%   10 MiB  10.4MB/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!

root@devpi5:/tmp # fetch -qo -
'http://pkg.freebsd.org/FreeBSD:14:aarch64/quarterly/data.pkg' | tar -xf - -O
data | jq -r '.packages[] | select(has("path") | not) | .name'
CuraEngine-debuginfo

-- 
You are receiving this mail because:
You are the assignee for the bug.