[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 . . . === Mark Millard marklmi at yahoo.com
