Re: Erorr upgrading pkg to 2.8.0

Le 26/07/2026 17:41, Xavier Humbert a écrit :
> 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
>
Obviously I restored the DB from /var/backups/pkg.sql.zst and excluded 
pkg from the update list (generated by portversion -l '<' -c), then 
restarted the upgrade

Xavier

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