Re: pkg rquery -r FreeBSD-base failure on aarch64 system: "pkg: repository FreeBSD-base contains packages for wrong OS version: FreeBSD:16:aarch64"
Date: Sun, 05 Oct 2025 23:00:57 UTC
On Oct 4, 2025, at 11:16, Mark Millard <marklmi@yahoo.com> 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 : pkg@FreeBSD.org
> 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