Erorr upgrading pkg to 2.8.0

Xavier Humbert <[email protected]> Sat, 25 Jul 2026 20:18:59 +0200
Newsgroups gmane.os.freebsd.devel.ports
Message-ID <[email protected]>
Hi,

I got an error while upgrading pkg from 2.7.5 to 2.8.0_1 :

[root@numenor ports]# portupgrade -v pkg
--->  Upgrade of ports-mgmt/pkg started at: Sat, 25 Jul 2026 16:58:52 +0200
--->  Upgrading 'pkg-2.7.5' to 'pkg-2.8.0_1' (ports-mgmt/pkg)
--->  Build of ports-mgmt/pkg started at: Sat, 25 Jul 2026 16:58:52 +0200
--->  Building '/usr/ports/ports-mgmt/pkg'
===>  Cleaning for pkg-2.8.0_1
[...]
--->  Installation of ports-mgmt/pkg started at: Sat, 25 Jul 2026 
17:02:05 +0200
--->  Installing the new version via the port
===>  Deinstalling for pkg
pkg-static: sqlite error while executing SELECT DISTINCT(p.id), origin, 
p.name, p.name as uniqueid, version, comment, desc, message, arch, 
maintainer, www, prefix, flatsize, licenselogic, automatic, locked, 
time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories 
ON p.id = pkg_categories.package_id LEFT JOIN categories ON 
categories.id = pkg_categories.category_id LEFT JOIN flavors ON 
flavors.package_id = p.id  WHERE (p.name GLOB ?1 OR p.name || '-' || 
version GLOB ?1) ORDER BY p.name in file pkgdb.c:100: no such table: flavors
pkg-static: sqlite error while executing SELECT DISTINCT(p.id), origin, 
p.name, p.name as uniqueid, version, comment, desc, message, arch, 
maintainer, www, prefix, flatsize, licenselogic, automatic, locked, 
time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories 
ON p.id = pkg_categories.package_id LEFT JOIN categories ON 
categories.id = pkg_categories.category_id LEFT JOIN flavors ON 
flavors.package_id = p.id  WHERE (p.name GLOB ?1 OR p.name || '-' || 
version GLOB ?1) ORDER BY p.name in file pkgdb.c:100: no such table: flavors
===>   Deinstalling
No packages matched for pattern 'pkg'

Checking integrity... done (0 conflicting)
1 packages requested for removal: 0 locked, 1 missing
*** Error code 1

Stop.
make[1]: stopped making "deinstall install" in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make: stopped making "reinstall" in /usr/ports/ports-mgmt/pkg
** Command failed [exit code 1]: /usr/bin/script -qa 
/tmp/portupgrade20260725-64472-r9qwx4 env UPGRADE_TOOL=portupgrade 
UPGRADE_PORT=pkg-2.7.5 UPGRADE_PORT_VER=2.7.5 make BATCH=yes reinstall
--->  Updating dependency info
--->  Restoring the old version
Installing pkg-2.7.5...
Extracting pkg-2.7.5: 100%
pkg: warning: database version 42 is newer than libpkg(3) version 39, 
but still compatible

The warning appears then at every upgrade of the ports

What can cause this and how to fix it ?

Thanks,

Regards,

Xavier

-- 
Xavier HUMBERT - Unix/Win/MacOSX Sysadmin/Network Engineer
https://www.amdh.fr