[Bug 297443] ports-mgmt/pkg pkg cannot update anything pkg-static: sqlite error while executing PRAGMA errors

From: <bugzilla-noreply_at_freebsd.org>
Date: Tue, 11 Aug 2026 17:00:41 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297443

--- Comment #2 from void@f-m.fm ---
Hi,

I think the pkg version is 2.8.3

 strings /usr/local/sbin/pkg-static | grep /work/pkg-
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/libder/libder/libder_type.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/libder/libder/libder_write.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/libder/libder/libder_read.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/fetch/common.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/libder/libder/libder_obj.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/linenoise/stringbuf.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/picosat/picosat.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/libder/libder/libder_private.h
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/libpkg/xmalloc.h
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.8.1/external/linenoise/linenoise.c

% strings /usr/local/sbin/pkg | grep /work/pkg-
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.7.5/external/libder/libder/libder_read.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.7.5/external/libder/libder/libder_type.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.7.5/external/libder/libder/libder_write.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.7.5/external/libder/libder/libder_obj.c
/wrkdirs/usr/ports/ports-mgmt/pkg/work/pkg-2.7.5/external/libder/libder/libder_private.h

I don't know why there's this mix...

I initially ran pkg update against the local poudriere. Then I got these
errors. Then took the poudriere out of the equation, and tried to upgrade pkg
via the ports tree, which builds fine but fails when pkg-static is called. Then
I set the working repo as above to pkg.f.o/latest, did a pkg bootstrap -f, same
errors and here we are.

Note this is -current built and installed from sources (
https://lists.freebsd.org/archives/freebsd-current/2026-July/010542.html )

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