Date: Mon, 12 Jan 2026 01:49:51 +0000 From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 292214] ports-mgmt/pkg sqlite error Message-ID: <bug-292214-32340-37YKWueSlT@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-292214-32340@https.bugs.freebsd.org/bugzilla/>
index | next in thread | previous in thread | raw e-mail
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=292214 --- Comment #16 from Dan With <dan.with@protonmail.com> --- Additional info for arm64 Quarterly: it appears to be the FreeBSD-ports repo having problems. The kmods and base are fine as of Mon Jan 12 01:28:14 UTC 2026. FreeBSD-ports: { url: "pkg+https://pkg.FreeBSD.org/${ABI}/quarterly", mirror_type: "srv", signature_type: "fingerprints", fingerprints: "/usr/share/keys/pkg", enabled: yes } Output matching original post's problem: root@alderaan-bsd:~ # cd /var/db/pkg root@alderaan-bsd:/var/db/pkg # rm -vfR * local.sqlite repos/FreeBSD-base/db repos/FreeBSD-base/meta repos/FreeBSD-base/lock repos/FreeBSD-base/db-journal repos/FreeBSD-base repos/FreeBSD-ports/db-journal repos/FreeBSD-ports/lock repos/FreeBSD-ports/meta repos/FreeBSD-ports repos/FreeBSD-ports-kmods/db-journal repos/FreeBSD-ports-kmods/db repos/FreeBSD-ports-kmods/meta repos/FreeBSD-ports-kmods/lock repos/FreeBSD-ports-kmods repos root@alderaan-bsd:/var/db/pkg # pkg-static install -f pkg Updating FreeBSD-ports repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 10 MiB 1.7MB/s 00:06 Processing entries: 99% pkg-static: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path pkg-static: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path pkg-static: 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... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 14 KiB 14.5kB/s 00:01 Processing entries: 100% FreeBSD-ports-kmods repository update completed. 61 packages processed. Updating FreeBSD-base repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 78 KiB 80.3kB/s 00:01 Processing entries: 100% FreeBSD-base repository update completed. 489 packages processed. Error updating repositories! pkg-static: Repository FreeBSD-ports cannot be opened. 'pkg update' required Checking integrity... done (0 conflicting) The following 1 package(s) will be affected (of 0 checked): New packages to be INSTALLED: pkg: 2.4.2 [FreeBSD-base] Number of packages to be installed: 1 The process will require 52 MiB more space. Proceed with this action? [y/N]: y [1/1] Installing pkg-2.4.2... [1/1] Extracting pkg-2.4.2: 100% root@alderaan-bsd:/var/db/pkg # pkg update -f Updating FreeBSD-ports repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 10 MiB 1.7MB/s 00:06 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... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 14 KiB 14.5kB/s 00:01 Processing entries: 100% FreeBSD-ports-kmods repository update completed. 61 packages processed. Updating FreeBSD-base repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 78 KiB 80.3kB/s 00:01 Processing entries: 100% FreeBSD-base repository update completed. 489 packages processed. Error updating repositories! root@alderaan-bsd:/var/db/pkg # pkg upgrade Updating FreeBSD-ports repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: 100% 10 MiB 1.5MB/s 00:07 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! pkg: Repository FreeBSD-ports cannot be opened. 'pkg update' required Checking for upgrades (0 candidates): 100% Processing candidates (0 candidates): 100% Checking integrity... done (0 conflicting) Your packages are up to date. root@alderaan-bsd:/var/db/pkg # -- You are receiving this mail because: You are the assignee for the bug.home | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-292214-32340-37YKWueSlT>