Re: Erorr upgrading pkg to 2.8.0

On 7/25/26 11:18, Xavier Humbert wrote:
> Hi,
> 
> I got an error while upgrading pkg from 2.7.5 to 2.8.0_1 :

This note looks like it is likely more appropriate for the freebsd-pkg@
list, which I've CC'd.

> 
> [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
> 


-- 
===
Mark Millard
marklmi at yahoo.com