From nobody Tue Jan 06 11:53:21 2026 X-Original-To: ports-bugs@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 4dlqLT2YKYz6NXgH for ; Tue, 06 Jan 2026 11:53:21 +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 4dlqLT1bttz3Gt1 for ; Tue, 06 Jan 2026 11:53:21 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1767700401; 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; bh=Bofd1WP3rD24rcCxOR/TnBOy4ZBgNc+7GYya1tYuJog=; b=wRgmJEQvwgQupwIk/YjU3aqykNONSwArdOhlK9lemIHAXxn4qAbs7H3TuOL5pOR6f/LP8x bFnbQQMrd2JJGHYicDGVqL51rFLxtfPlP0cmNAHkqPiuaUPSr64R12b7b5xPsVRoN0FVls 6jjve+l0TzLPbHe8nABVi1mlgwO2sh2Bgh5K0G8QO0gOQnVr9rmEFGWHdp4UcVpNw+Jvru N4d4ZPqFrNOfRYxbFnZZm3wXDM9qkT7PyWdrZNHlvMm62AhEaEOmbKP6Gd/PMjp5onwM9G oTyuljXtmopOo+MYPkZEckbmw5p5IYFfVL24zKxXIDDlrYzgWkaf+dAcyBbLMA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1767700401; 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; bh=Bofd1WP3rD24rcCxOR/TnBOy4ZBgNc+7GYya1tYuJog=; b=EK905Legvf+BXu3cNhX5WbokiH+IVUgCerJFpk5IMYdgvlO9W4yg2W82jyJESzmc4Javv2 FC4fosEzdEz2UKaagm+Tmgm9JoLFqb8nKQztBX4g4bUvzJ11p2fevZu9wCAZu7zUVy0RA7 +OXbN2AU1mdQZB+8/H2ut/HkGTkc7Hv8DXciskj6j+2LmJpBqyjb2QnzsGADDUek2jbKqP zJT2JIrnznOs95H5nzJ4JJm1wvrF1jAVIsILuITaLIA3+xL6O2KmRycBxpD89rK80g30UZ RziE0xfYcwcCCeMpniHBliFh3nqeni2cQqiHfBxiL/B973t721yfOSSct2uxSw== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1767700401; a=rsa-sha256; cv=none; b=l8K9Oq6QqcZ5HzepyGOXOwDy9Ka/vD2oowN30OM/2JLZl/z0eaWkMPYlUMSRQ/nFPRTN2I /sBaN8lwN3GUiTnETxj4Qymwqoan5oPTE+LyMyZmS6f6XPHkZxp8VLI8QqbNqFu1ojjzil dVruKitWV7hk+TRKcyv3RhZZNx1jazbOqZeuWk8yooU1N+L/m+VIEolxbIzwaPWGuP1KKJ mDwJnpFaFN7DiU6X6c7RYbvI1pIFllU6WNrurBYYJDsGL+/EM8zlxuBNPSncKozDTBc0wi aiV8/2pDz10h9Hs6whQGzzeBhi3LmtMDQNenMkJrWioXSjsQ36McpziKeO6btQ== 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 4dlqLT12kSz14yf for ; Tue, 06 Jan 2026 11:53:21 +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 606BrLNc020866 for ; Tue, 6 Jan 2026 11:53:21 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 606BrLFG020865 for ports-bugs@FreeBSD.org; Tue, 6 Jan 2026 11:53:21 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: ports-bugs@FreeBSD.org Subject: [Bug 292214] ports-mgmt/pkg sqlite error Date: Tue, 06 Jan 2026 11:53:21 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new 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: devosalain@ymail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: 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: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-ports-bugs@freebsd.org Sender: owner-freebsd-ports-bugs@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D292214 Bug ID: 292214 Summary: ports-mgmt/pkg sqlite error Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Many People Priority: --- Component: Individual Port(s) Assignee: pkg@FreeBSD.org Reporter: devosalain@ymail.com Flags: maintainer-feedback?(pkg@FreeBSD.org) Assignee: pkg@FreeBSD.org Script : cd /var/db/pkg rm -vfR * pkg-static install -f pkg pkg update -f pkg upgrade returns : local.sqlite repos/FreeBSD-kmods/lock repos/FreeBSD-kmods/db-journal repos/FreeBSD-kmods/meta repos/FreeBSD-kmods/db repos/FreeBSD-kmods repos/FreeBSD/meta repos/FreeBSD/lock repos/FreeBSD/db-journal repos/FreeBSD repos Updating FreeBSD repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01=20=20=20=20 Fetching data.pkg: 100% 10 MiB 5.3MB/s 00:02=20=20=20=20 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 Updating FreeBSD-kmods repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01=20=20=20=20 Fetching data.pkg: 100% 30 KiB 31.1kB/s 00:01=20=20=20=20 Processing entries: 100% FreeBSD-kmods repository update completed. 204 packages processed. Error updating repositories! pkg-static: Repository FreeBSD cannot be opened. 'pkg update' required pkg-static: No packages available to install matching 'pkg' have been found= in the repositories Updating FreeBSD repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01=20=20=20=20 Fetching data.pkg: 100% 10 MiB 5.3MB/s 00:02=20=20=20=20 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 Updating FreeBSD-kmods repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01=20=20=20=20 Fetching data.pkg: 100% 30 KiB 31.1kB/s 00:01=20=20=20=20 Processing entries: 100% FreeBSD-kmods repository update completed. 204 packages processed. Error updating repositories! Updating FreeBSD repository catalogue... Fetching meta.conf: 100% 179 B 0.2kB/s 00:01=20=20=20=20 Fetching data.pkg: 100% 10 MiB 5.3MB/s 00:02=20=20=20=20 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 Updating FreeBSD-kmods repository catalogue... FreeBSD-kmods repository is up to date. Error updating repositories! pkg: Repository FreeBSD 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. --=20 You are receiving this mail because: You are the assignee for the bug.=