On Oct 4, 2025, at 11:16, Mark Millard <[email protected]> wrote: > [Note: I do not see this in my amd64 main 16 environment.] > > > Context (evidence of FreeBSD:16:aarch64 status) . . . > > # uname -apKU > FreeBSD aarch64-main-pbase 16.0-CURRENT FreeBSD 16.0-CURRENT > main-n280461-506b36c4fdde GENERIC-NODEBUG arm64 aarch64 1600000 1600000 > > # file `which uname` `which sh` `which pkg` /usr/local/sbin/pkg `which > pkg-static` > /usr/bin/uname: ELF 64-bit LSB pie executable, ARM aarch64, > version 1 (FreeBSD), dynamically linked, interpreter /libexec/ld-elf.so.1, > for FreeBSD 16.0 (1600000), FreeBSD-style, stripped > /bin/sh: ELF 64-bit LSB pie executable, ARM aarch64, > version 1 (FreeBSD), dynamically linked, interpreter /libexec/ld-elf.so.1, > for FreeBSD 16.0 (1600000), FreeBSD-style, stripped > /usr/sbin/pkg: ELF 64-bit LSB pie executable, ARM aarch64, > version 1 (FreeBSD), dynamically linked, interpreter /libexec/ld-elf.so.1, > for FreeBSD 16.0 (1600000), FreeBSD-style, stripped > /usr/local/sbin/pkg: ELF 64-bit LSB executable, ARM aarch64, version 1 > (FreeBSD), dynamically linked, interpreter /libexec/ld-elf.so.1, for FreeBSD > 16.0 (1600000), FreeBSD-style, with debug_info, not stripped > /usr/local/sbin/pkg-static: ELF 64-bit LSB executable, ARM aarch64, version 1 > (FreeBSD), statically linked, for FreeBSD 16.0 (1600000), FreeBSD-style, with > debug_info, not stripped > > # pkg info pkg > pkg: Warning: Major OS version upgrade detected. Running "pkg bootstrap -f" > recommended > pkg-2.3.1 > Name : pkg > Version : 2.3.1 > Installed on : Sat Sep 13 00:20:45 2025 PDT > Origin : ports-mgmt/pkg > Architecture : FreeBSD:16:aarch64 > Prefix : /usr/local > Categories : ports-mgmt > Licenses : BSD2CLAUSE > Maintainer : [email protected] > WWW : https://github.com/freebsd/pkg > Comment : Package manager > Options : > DOCS : on > Shared Libs required: > libarchive.so.7 > libc.so.7 > libcrypto.so.35 > libelf.so.2 > libjail.so.1 > libm.so.5 > libssl.so.35 > libthr.so.3 > libutil.so.10 > libz.so.6 > Shared Libs provided: > libpkg.so.4 > Annotations : > FreeBSD_version: 1600000 > build_timestamp: 2025-09-13T05:18:13+00:00 > built_by : poudriere-git-3.4.99.20250724 > port_checkout_unclean: no > port_git_hash : e8009782a2b6 > ports_top_checkout_unclean: yes > ports_top_git_hash: 7e86a0d71167 > repo_type : binary > repository : main-aarch64-default > Flat size : 51.6MiB > Description : > Package management tool > > # pkg-static repos -e > pkg-static: Warning: Major OS version upgrade detected. Running "pkg > bootstrap -f" recommended > FreeBSD-base: { > url : > "pkg+http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest";, > enabled : yes, > priority : 0, > mirror_type : "SRV", > signature_type : "FINGERPRINTS", > fingerprints : "/usr/share/keys/pkg" > } > > > Oddity . . . > > # pkg rquery -r FreeBSD-base -C -x %n-%v ^ > pkg: Warning: Major OS version upgrade detected. Running "pkg bootstrap -f" > recommended > pkg: repository FreeBSD-base contains packages for wrong OS version: > FreeBSD:16:aarch64 > > > With debug output . . . > > # pkg -dddd rquery -r FreeBSD-base -C -x %n-%v ^ > pkg: Warning: Major OS version upgrade detected. Running "pkg bootstrap -f" > recommended > DBG(1)[80439]> PkgRepo: verifying update for FreeBSD-base > DBG(4)[80439]> (db) running: 'SELECT count(name) FROM sqlite_master WHERE > type='table' AND name='repodata';' > DBG(4)[80439]> (db) running: 'select count(key) from repodata WHERE key = > "packagesite" and value = > 'pkg+http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest'' > DBG(4)[80439]> (db) running: 'WITH flavors AS (SELECT package_id, > value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag ON > pkg_annotation.tag_id = tag.annotation_id LEFT JOIN annotation value ON > pkg_annotation.value_id = value.annotation_id WHERE tag.annotation = > 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid, version, > comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, > pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD-base' AS dbname > 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 > ORDER BY p.name;' > DBG(1)[80439]> Pkgrepo, begin update of '/var/db/pkg/repos/FreeBSD-base/db' > DBG(1)[80439]> (fetch) Request to fetch > pkg+http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest/meta.conf > DBG(2)[80439]> (fetch) curl_open > DBG(1)[80439]> (fetch) Fetch: fetcher used: pkg+http > DBG(2)[80439]> (fetch) curl> fetching > http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest/meta.conf > > DBG(1)[80439]> (fetch) Request to fetch > pkg+http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest/data.pkg > DBG(2)[80439]> (fetch) curl_open > DBG(1)[80439]> (fetch) Fetch: fetcher used: pkg+http > DBG(2)[80439]> (fetch) curl> fetching > http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest/data.pkg > > DBG(1)[80439]> PkgRepo: extracting data of repo FreeBSD-base > DBG(1)[80441]> PkgRepo: extracting signature of repo in a sandbox > DBG(4)[80439]> (db) executing 'CREATE TABLE packages (id INTEGER PRIMARY > KEY,origin TEXT,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT > NULL,desc TEXT NOT NULL,osversion TEXT,arch TEXT NOT NULL,maintainer TEXT NOT > NULL,www TEXT,prefix TEXT NOT NULL,pkgsize INTEGER NOT NULL,flatsize INTEGER > NOT NULL,licenselogic INTEGER NOT NULL,cksum TEXT NOT NULL,path TEXT NOT > NULL,pkg_format_version INTEGER,manifestdigest TEXT NULL,olddigest TEXT > NULL,dep_formula TEXT NULL,vital INTEGER NOT NULL DEFAULT 0);CREATE TABLE > deps (origin TEXT,name TEXT,version TEXT,package_id INTEGER REFERENCES > packages(id) ON DELETE CASCADE ON UPDATE CASCADE,UNIQUE(package_id, > name));CREATE TABLE categories (id INTEGER PRIMARY KEY, name TEXT NOT NULL > UNIQUE );CREATE TABLE pkg_categories (package_id INTEGER REFERENCES > packages(id) ON DELETE CASCADE ON UPDATE CASCADE,category_id INTEGER > REFERENCES categories(id) ON DELETE RESTRICT ON UPDATE > RESTRICT,UNIQUE(package_id, category_id));CREATE TABLE licenses (id INTEGER > PRIMARY KEY,name TEXT NOT NULL UNIQUE);CREATE TABLE pkg_licenses (package_id > INTEGER REFERENCES packages(id) ON DELETE CASCADE ON UPDATE > CASCADE,license_id INTEGER REFERENCES licenses(id) ON DELETE RESTRICT ON > UPDATE RESTRICT,UNIQUE(package_id, license_id));CREATE TABLE option > (option_id INTEGER PRIMARY KEY,option TEXT NOT NULL UNIQUE);CREATE TABLE > option_desc (option_desc_id INTEGER PRIMARY KEY,option_desc TEXT NOT NULL > UNIQUE);CREATE TABLE pkg_option (package_id INTEGER NOT NULL REFERENCES > packages(id) ON DELETE CASCADE ON UPDATE CASCADE,option_id INTEGER NOT NULL > REFERENCES option(option_id) ON DELETE RESTRICT ON UPDATE CASCADE,value TEXT > NOT NULL,PRIMARY KEY(package_id, option_id));CREATE TABLE pkg_option_desc > (package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE ON > UPDATE CASCADE,option_id INTEGER NOT NULL REFERENCES option(option_id) ON > DELETE RESTRICT ON UPDATE CASCADE,option_desc_id INTEGER NOT NULL REFERENCES > option_desc(option_desc_id) ON DELETE RESTRICT ON UPDATE CASCADE,PRIMARY > KEY(package_id, option_id));CREATE TABLE pkg_option_default (package_id > INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE ON UPDATE > CASCADE,option_id INTEGER NOT NULL REFERENCES option(option_id) ON DELETE > RESTRICT ON UPDATE CASCADE,default_value TEXT NOT NULL,PRIMARY > KEY(package_id, option_id));CREATE TABLE shlibs (id INTEGER PRIMARY KEY,name > TEXT NOT NULL UNIQUE );CREATE TABLE pkg_shlibs_required (package_id INTEGER > NOT NULL REFERENCES packages(id) ON DELETE CASCADE ON UPDATE > CASCADE,shlib_id INTEGER NOT NULL REFERENCES shlibs(id) ON DELETE RESTRICT > ON UPDATE RESTRICT,UNIQUE(package_id, shlib_id));CREATE TABLE > pkg_shlibs_provided (package_id INTEGER NOT NULL REFERENCES packages(id) ON > DELETE CASCADE ON UPDATE CASCADE,shlib_id INTEGER NOT NULL REFERENCES > shlibs(id) ON DELETE RESTRICT ON UPDATE RESTRICT,UNIQUE(package_id, > shlib_id));CREATE TABLE annotation (annotation_id INTEGER PRIMARY > KEY,annotation TEXT NOT NULL UNIQUE);CREATE TABLE pkg_annotation (package_id > INTEGER REFERENCES packages(id) ON DELETE CASCADE ON UPDATE RESTRICT,tag_id > INTEGER NOT NULL REFERENCES annotation(annotation_id) ON DELETE CASCADE ON > UPDATE RESTRICT,value_id INTEGER NOT NULL REFERENCES > annotation(annotation_id) ON DELETE CASCADE ON UPDATE RESTRICT,UNIQUE > (package_id, tag_id));CREATE TABLE pkg_conflicts (package_id INTEGER NOT NULL > REFERENCES packages(id) ON DELETE CASCADE ON UPDATE CASCADE,conflict_id > INTEGER NOT NULL,UNIQUE(package_id, conflict_id));CREATE TABLE provides( > id INTEGER PRIMARY KEY, provide TEXT NOT NULL);CREATE TABLE pkg_provides > (package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE ON > UPDATE CASCADE,provide_id INTEGER NOT NULL REFERENCES provides(id) ON DELETE > RESTRICT ON UPDATE RESTRICT,UNIQUE(package_id, provide_id));CREATE TABLE > requires( id INTEGER PRIMARY KEY, require TEXT NOT NULL);CREATE TABLE > pkg_requires (package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE > CASCADE ON UPDATE CASCADE,require_id INTEGER NOT NULL REFERENCES requires(id) > ON DELETE RESTRICT ON UPDATE RESTRICT,UNIQUE(package_id, require_id));PRAGMA > user_version=2014;' > DBG(4)[80439]> (db) executing 'CREATE TABLE IF NOT EXISTS repodata ( key > TEXT UNIQUE NOT NULL, value TEXT NOT NULL);' > DBG(4)[80439]> (db) running: 'SELECT count(name) FROM sqlite_master WHERE > type='table' AND name='repodata';' > DBG(4)[80439]> (db) running: 'select count(key) from repodata WHERE key = > "packagesite" and value = > 'pkg+http://pkg.FreeBSD.org/FreeBSD:16:aarch64/base_latest'' > DBG(4)[80439]> (db) running: 'WITH flavors AS (SELECT package_id, > value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag ON > pkg_annotation.tag_id = tag.annotation_id LEFT JOIN annotation value ON > pkg_annotation.value_id = value.annotation_id WHERE tag.annotation = > 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid, version, > comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, > pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD-base' AS dbname > 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 > ORDER BY p.name;' > DBG(4)[80439]> (db) executing 'PRAGMA journal_mode=TRUNCATE;' > DBG(4)[80439]> (db) executing 'PRAGMA synchronous=FULL' > DBG(4)[80439]> (db) executing 'PRAGMA foreign_keys=on' > DBG(4)[80439]> (db) executing 'PRAGMA mmap_size=268435456;' > DBG(4)[80439]> (db) executing 'CREATE TABLE IF NOT EXISTS repo_update (n > INT);' > DBG(1)[80439]> Pkgrepo, reading new metadata > DBG(4)[80439]> (db) executing 'PRAGMA mmap_size = 209715200;' > DBG(4)[80439]> (db) executing 'PRAGMA page_size = 4096;' > DBG(4)[80439]> (db) executing 'PRAGMA foreign_keys = OFF;' > DBG(4)[80439]> (db) executing 'PRAGMA journal_mode = TRUNCATE;' > DBG(4)[80439]> (db) executing 'PRAGMA synchronous = FULL;' > DBG(4)[80439]> (db) running: 'SAVEPOINT REPO' > DBG(2)[80439]> (manifest) Parsing from buffer > DBG(3)[80439]> (manifest) found key: 'name' > DBG(3)[80439]> (manifest) found key: 'origin' > DBG(3)[80439]> (manifest) found key: 'version' > DBG(3)[80439]> (manifest) found key: 'comment' > DBG(3)[80439]> (manifest) found key: 'maintainer' > DBG(3)[80439]> (manifest) found key: 'www' > DBG(3)[80439]> (manifest) found key: 'abi' > DBG(3)[80439]> (manifest) found key: 'arch' > DBG(3)[80439]> (manifest) found key: 'prefix' > DBG(3)[80439]> (manifest) found key: 'sum' > DBG(3)[80439]> (manifest) found key: 'flatsize' > DBG(3)[80439]> (manifest) found key: 'path' > DBG(3)[80439]> (manifest) found key: 'repopath' > DBG(3)[80439]> (manifest) found key: 'licenselogic' > DBG(3)[80439]> (manifest) found key: 'licenses' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (manifest) found key: 'pkgsize' > DBG(3)[80439]> (manifest) found key: 'desc' > DBG(3)[80439]> (manifest) found key: 'categories' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (manifest) found key: 'annotations' > DBG(3)[80439]> (manifest) parsing object > DBG(2)[80439]> (manifest) Parsing from buffer > DBG(3)[80439]> (manifest) found key: 'name' > DBG(3)[80439]> (manifest) found key: 'origin' > DBG(3)[80439]> (manifest) found key: 'version' > DBG(3)[80439]> (manifest) found key: 'comment' > DBG(3)[80439]> (manifest) found key: 'maintainer' > DBG(3)[80439]> (manifest) found key: 'www' > DBG(3)[80439]> (manifest) found key: 'abi' > DBG(3)[80439]> (manifest) found key: 'arch' > DBG(3)[80439]> (manifest) found key: 'prefix' > DBG(3)[80439]> (manifest) found key: 'sum' > DBG(3)[80439]> (manifest) found key: 'flatsize' > DBG(3)[80439]> (manifest) found key: 'path' > DBG(3)[80439]> (manifest) found key: 'repopath' > DBG(3)[80439]> (manifest) found key: 'licenselogic' > DBG(3)[80439]> (manifest) found key: 'licenses' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (manifest) found key: 'pkgsize' > DBG(3)[80439]> (manifest) found key: 'desc' > DBG(3)[80439]> (manifest) found key: 'deps' > DBG(3)[80439]> (manifest) parsing object > DBG(2)[80439]> (manifest) Found FreeBSD-zfs > DBG(3)[80439]> (package) add a new dependency origin: base, name: FreeBSD-zfs > DBG(3)[80439]> (manifest) found key: 'categories' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (manifest) found key: 'shlibs_required' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libbsdxml.so.4:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libc.so.7:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libcrypto.so.35:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libgcc_s.so.1:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libgeom.so.5:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libm.so.5:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libmd.so.7:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libpam.so.6:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > librt.so.1:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libthr.so.3:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libutil.so.10:32 > DBG(3)[80439]> (package) added shlib deps for FreeBSD-zfs-lib32 on > libz.so.6:32 > DBG(3)[80439]> (manifest) found key: 'shlibs_provided' > DBG(3)[80439]> (manifest) parsing array > DBG(3)[80439]> (package) added shlib provide libavl.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libbe.so.1:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libicp.so.3:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libnvpair.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libspl.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libtpool.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libumem.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libuutil.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzdb.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzfs.so.4:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzfs_core.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzfsbootenv.so.1:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzpool.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (package) added shlib provide libzutil.so.2:32 for > FreeBSD-zfs-lib32 > DBG(3)[80439]> (manifest) found key: 'annotations' > DBG(3)[80439]> (manifest) parsing object > pkg: repository FreeBSD-base contains packages for wrong OS version: > FreeBSD:16:aarch64 > DBG(4)[80439]> (db) executing 'CREATE INDEX packages_origin ON > packages(origin COLLATE NOCASE);CREATE INDEX packages_name ON packages(name > COLLATE NOCASE);CREATE INDEX packages_uid_nocase ON packages(name COLLATE > NOCASE, origin COLLATE NOCASE);CREATE INDEX packages_version_nocase ON > packages(name COLLATE NOCASE, version);CREATE INDEX packages_uid ON > packages(name, origin);CREATE INDEX packages_version ON packages(name, > version);CREATE UNIQUE INDEX packages_digest ON packages(manifestdigest);' > DBG(4)[80439]> (db) running: 'ROLLBACK TO SAVEPOINT REPO' > DBG(4)[80439]> (db) running: 'RELEASE SAVEPOINT REPO' > > > > For reference, from the amd64 main 16 context that works: > (after "curl> fetching > http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest/data.pkg"; > things are different) > > # pkg -dddd rquery -r FreeBSD-base -C -x %n-%v ^ > pkg: Warning: Major OS version upgrade detected. Running "pkg bootstrap -f" > recommended > DBG(1)[37710]> PkgRepo: verifying update for FreeBSD-base > DBG(4)[37710]> (db) running: 'SELECT count(name) FROM sqlite_master WHERE > type='table' AND name='repodata';' > DBG(4)[37710]> (db) running: 'select count(key) from repodata WHERE key = > "packagesite" and value = > 'pkg+http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest'' > DBG(4)[37710]> (db) running: 'WITH flavors AS (SELECT package_id, > value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag ON > pkg_annotation.tag_id = tag.annotation_id LEFT JOIN annotation value ON > pkg_annotation.value_id = value.annotation_id WHERE tag.annotation = > 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid, version, > comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, > pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD-base' AS dbname > 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 > ORDER BY p.name;' > DBG(1)[37710]> Pkgrepo, begin update of '/var/db/pkg/repos/FreeBSD-base/db' > DBG(1)[37710]> (fetch) Request to fetch > pkg+http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest/meta.conf > DBG(2)[37710]> (fetch) curl_open > DBG(1)[37710]> (fetch) Fetch: fetcher used: pkg+http > DBG(2)[37710]> (fetch) curl> fetching > http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest/meta.conf > > DBG(1)[37710]> (fetch) Request to fetch > pkg+http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest/data.pkg > DBG(2)[37710]> (fetch) curl_open > DBG(1)[37710]> (fetch) Fetch: fetcher used: pkg+http > DBG(2)[37710]> (fetch) curl> fetching > http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest/data.pkg > > DBG(4)[37710]> (db) running: 'PRAGMA user_version;' > DBG(4)[37710]> (db) executing 'PRAGMA foreign_keys = ON;' > DBG(4)[37710]> (db) executing 'PRAGMA mmap_size=268435456;' > DBG(4)[37710]> (db) running: 'SELECT count(name) FROM sqlite_master WHERE > type='table' AND name='repodata';' > DBG(4)[37710]> (db) running: 'select count(key) from repodata WHERE key = > "packagesite" and value = > 'pkg+http://pkg.FreeBSD.org/FreeBSD:16:amd64/base_latest'' > DBG(4)[37710]> (db) running: 'WITH flavors AS (SELECT package_id, > value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag ON > pkg_annotation.tag_id = tag.annotation_id LEFT JOIN annotation value ON > pkg_annotation.value_id = value.annotation_id WHERE tag.annotation = > 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid, version, > comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, > pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD-base' AS dbname > 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 > ORDER BY p.name;' > DBG(4)[37710]> (db) executing 'PRAGMA journal_mode=TRUNCATE;' > DBG(4)[37710]> (db) executing 'PRAGMA synchronous=FULL' > DBG(4)[37710]> (db) executing 'PRAGMA foreign_keys=on' > DBG(4)[37710]> (db) executing 'PRAGMA mmap_size=268435456;' > DBG(4)[37710]> (db) running: 'WITH flavors AS (SELECT package_id, > value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag ON > pkg_annotation.tag_id = tag.annotation_id LEFT JOIN annotation value ON > pkg_annotation.value_id = value.annotation_id WHERE tag.annotation = > 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid, version, > comment, prefix, desc, arch, maintainer, www, licenselogic, flatsize, > pkgsize, cksum, manifestdigest, path AS repopath, 'FreeBSD-base' AS dbname > 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 REGEXP '^' OR p.name || '-' || version REGEXP '^') ORDER BY > p.name;' > FreeBSD-acct-16.snap20251001102954 > . . .
This appears to be tied in some way to how old the initiating environment was: after updating the environment to where FreeBSD-*-16.snap20251005084412 was the most recent involved, the rquery: # pkg rquery -r FreeBSD-base -C -x %n-%v ^ works just fine. === Mark Millard marklmi at yahoo.com
