From nobody Mon Jan 12 01:23:24 2026 X-Original-To: pkg@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4dqF4t42Qvz6NpFD for ; Mon, 12 Jan 2026 01:23:26 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R13" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4dqF4t3LTzz4PF4 for ; Mon, 12 Jan 2026 01:23:26 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1768181006; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=BNV6J5sLl2YdwGcsCTiGreLu6Y8LL9CzXLjTIbIuFKg=; b=SmbFeJxYN0kShNj1CywtP6K30o2xzSvNxRwNh4g5kjFA/1TB6+DGZstQc8ELSQVVaCkj78 5gxhZNAzrjYbJAEWyl4lJFwxk+fu7/qFw3BWTGutGoXm7w9k1a1qLdejk719m4j3YfNECg hUphXutgu0ohKZBi3wZ58DHfEe8z3sd60Y6I3YEQYtTfnvaYbsMe8wYVTIcHv35YH/OQki uTqTLjCdx9NCr8YU82X2tn+rL6xrnEQFzqIuU5ayhWItFUh9vKwZxqHQTyN+iB0eUjZB3S PrIVi5EiW1ZzhNbyv7UIK8uFtC1tOPxUOAZktM5ulqa3QE34DiqEEC/H3CJY4Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1768181006; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=BNV6J5sLl2YdwGcsCTiGreLu6Y8LL9CzXLjTIbIuFKg=; b=FkKZD6VR3lJRsD/dkqlN4WT5h2Csd6xemDKW6p6b9/0gBl0WIQvi8LpXR5CHW14oafTaeZ zCqKxIXnPt0KHaxQ6lWYFkWm3hVURRygabX/o8hgDlofjYuLSJk1aamgH8Mnx+kfieDPbt 3WLGIRjP1/7XGhJbC7M11cGwicEAW8cQQ2ekF3umAUt/NkbGRFFZNgP6cQgEopB+/mD62r AKvcSP1rDXGD7JDhbzqL0rvdYolqk2EcPVHDeXVVckTXcpCGb4I+/zFW5EIW1tfIwcjMO4 qEDWndSCl4zb0GzjNThB7TBAwxSbUcO7Iej1EYIyVx7rjEdHC5X75I4Vf2mfYg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1768181006; a=rsa-sha256; cv=none; b=ETjrls3RLL1Ta7cFox+iDTSSBfFx0opFkezUfd9uahL58GbFn4wH2XZzTOuArh81dWjcLM 1v/AdXkpkbxE5RmlVXc+seNTkAnR/983bZcCDslLzvRoZDtOKVC4kTTH1ZHRmG7Duh7UF8 TuVk7HJwaklKFA4XdnDsD8F+dfMcDcpU8pj3khy92lulnUvSpsdY61X54cC/sK2EhhKtFo 2nVlrlHQTVImTnEsM5J72ETW9/mdwHp2fflIbmW8xKJjw/GN/qmabh9Z12Vjlyi3jiDJie JGtAgcTL1LjY2nRXlA12DjLPh1lsW+Czo0evKWRbdwyOMzsaXF1WH5YyNzZtyQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4dqF4t2s6kz14d3 for ; Mon, 12 Jan 2026 01:23:26 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 60C1NQ6Q060260 for ; Mon, 12 Jan 2026 01:23:26 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 60C1NQRj060259 for pkg@FreeBSD.org; Mon, 12 Jan 2026 01:23:26 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 292214] ports-mgmt/pkg sqlite error Date: Mon, 12 Jan 2026 01:23:24 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: dan.with@protonmail.com X-Bugzilla-Status: Closed X-Bugzilla-Resolution: FIXED X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D292214 --- Comment #15 from Dan With --- Sorry for the late reply, Mark. I'm definitely using arm64 (quarterly). It = was a fresh VM install on my laptop late last week. I was a little surprised th= at I was getting that error on a fresh install--that's why I updated this thread after searching for bugs. Here is my default /etc/pkg/FreeBSD.conf FreeBSD-ports: { url: "pkg+https://pkg.FreeBSD.org/${ABI}/quarterly", mirror_type: "srv", signature_type: "fingerprints", fingerprints: "/usr/share/keys/pkg", enabled: yes } FreeBSD-ports-kmods: { url: "pkg+https://pkg.FreeBSD.org/${ABI}/kmods_quarterly_${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 } =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D I haven't modified anything from the default install. --=20 You are receiving this mail because: You are the assignee for the bug.= From nobody Mon Jan 12 01:49:51 2026 X-Original-To: pkg@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4dqFgN3M8wz6NqYb for ; Mon, 12 Jan 2026 01:49:52 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R13" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4dqFgN2pGJz4Q8C for ; Mon, 12 Jan 2026 01:49:52 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1768182592; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=lms9Q1poYxAs7wk5X/vM56To5K5+qrr/VBmvaAbUSrk=; b=T1V+pSeOb//VeehelQqnJU7qaCmqTBMHzh6+PtppNZPic3xlKsMwxw4hfxbIkFDUqAZpeK 3TLP70TpijnSdaWXqFEHICuJB1cGzdWQtXQ8lPRdvLf2HCUr1g2j3kcI7chV7lgZ1QA0Vh 4U0QDEsPch3nJO2sFhkOrsp8dI1HX5WvGoNn3Jrm67uxyipRyJIUnneG6ZfyIqAWuve79h xp+rYBND44v/mj02GAhdDkc3KqDF3336KXAiYIoy871yIGb1ZojCGZNRVBsjV0rt2QgV9F 3Ud8sj+jFtmbf/93I820TPtiSJoYy+i/uSftUrKjoUwHrAYwoTpyb381+2Z+RA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1768182592; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=lms9Q1poYxAs7wk5X/vM56To5K5+qrr/VBmvaAbUSrk=; b=Own83j28R+suQJ/X39cw9X8u5v92Bxgi3xisvUqNjm6AQexbG9lkaSa1bADz/tyB0eXzQr HGLhCCfmXyeWZcrDj2CFl86WCUJt5YbZ0+hpr7A7TKWxiXaUuIeM3NFT3OTFvodVPWIxzm MBaH6nHhznz1ChoWr7WH6t/5k73IAPw0f55M5DYTf8R6uE3ZqX1LkIJlYPan4DuUKUsbYV UobzokXGbNYHZu4kxXV6GTKpCNjJJWSkGRzB3RzJILlN5bKKxSlkB+PISjVTcRo6NjMdPA vPMvC2iLKMYgFmUPYfOBdmY3PfXEhpHmPm8SyiLFXAZt0HydPGVbkTIdNE6e/g== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1768182592; a=rsa-sha256; cv=none; b=FR4pBq5EEpuhcGEUgfzgyW3gY3cYO8IK2+LuJhEdpQjJMn4ywQnKJoAlnQ8EwQXq8o4xvg iSu3l2EtyABYYlj7+j+xwiayPlaoc5Sx74JvL/qfieXgsraGzTC6lHl7+jmjGpbZDAHV1T LbEL0tXhQsjP3X8CvWuwwA6O3uDgugIqFH0uSPdvUtQK7sL4H9xD+nOK7LL3ZiI5VbAwCB DM+Uxr/mT+OHPbjsM5x8jZsmupLld8vUbkVsch07CGt6gbTogPoCvpiAeFqnEr3Osfe61i uAglxIFefEAFz9kXj7K/EeIo4AEy3rsfEmPe9zK41PTgVtnNWvw2oc8vqo7OKg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4dqFgN2PjBz15PF for ; Mon, 12 Jan 2026 01:49:52 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 60C1nqrp096745 for ; Mon, 12 Jan 2026 01:49:52 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 60C1nqpg096744 for pkg@FreeBSD.org; Mon, 12 Jan 2026 01:49:52 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 292214] ports-mgmt/pkg sqlite error Date: Mon, 12 Jan 2026 01:49:51 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: dan.with@protonmail.com X-Bugzilla-Status: Closed X-Bugzilla-Resolution: FIXED X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D292214 --- Comment #16 from Dan With --- 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 NU= LL constraint failed: packages.path pkg-static: sqlite error while executing grmbl in file update.c:154: NOT NU= LL constraint failed: packages.path pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages (origin, name, version, comment, desc, arch, maintainer, www, prefix, pkgsi= ze, 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, flats= ize, 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, flats= ize, 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 # --=20 You are receiving this mail because: You are the assignee for the bug.=