[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 19:24:29 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297443

--- Comment #3 from Mark Millard <marklmi26-fbsd@yahoo.com> ---
(In reply to void from comment #2)

I'm not aware of anything documenting pkg version compatibility
vs. not. But it seems fairly likely that 2.8.3 might convert
some internal files into formats not handled by old enough
vintages of pkg. Similarly for 2.8.1 --and so on.

I do not know if it ever goes the other way: some old enough
internal files that sufficiently modern pkg or pkg-static does
not handle. I would expect that as part of supporting pkg
being updated, some range of older internal file formats would
be supported, just possibly not all the way back to to 1.0.0
or the like.

So, poudriere(-devel) building and using pkg 2.8.3, the host
using pkg-static 2.8.1 and pkg 2.7.5 may well be sufficient for
there to be such compatibility problems: 2.7.5 would appear to
then need to support 2.8.* (for example) file formats. How the
host got to be mixed may be the actual/original problem and the
rest might just be garbage-in/garbage-out after that,
garabage-out here being explicit error messages.

It seems unlikely that pkg/pkg-static are designed to
deliberately support the odd host combination.

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