From nobody Sun Oct 5 23:00:57 2025 X-Original-To: freebsd-pkgbase@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4cfyZ663sXz6BvKc for ; Sun, 05 Oct 2025 23:01:18 +0000 (UTC) (envelope-from marklmi@yahoo.com) Received: from sonic309-21.consmr.mail.gq1.yahoo.com (sonic309-21.consmr.mail.gq1.yahoo.com [98.137.65.147]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4cfyZ43bRjz3QSY for ; Sun, 05 Oct 2025 23:01:16 +0000 (UTC) (envelope-from marklmi@yahoo.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=yahoo.com header.s=s2048 header.b=cpkZUIY3; dmarc=pass (policy=reject) header.from=yahoo.com; spf=pass (mx1.freebsd.org: domain of marklmi@yahoo.com designates 98.137.65.147 as permitted sender) smtp.mailfrom=marklmi@yahoo.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1759705273; bh=bpa8BBwZkozCDLVMx7liIEC2IV0FaTD9nq+5LoQKO18=; h=From:Subject:Date:References:To:In-Reply-To:From:Subject:Reply-To; b=cpkZUIY3EUsswIlFvq/jcaZMKhC5N/30GyWFNRHbZi8oaH3WFuR87qPQC5wXdl5MYVJuJ6gepJQgT2qabxb5UqtXSaBxHLJvY2hLEoBkwdUdcWyonBn33X+8YX0B7+kXJpkQtmpU4RsBdb+OSnVTnu3ZqnIEvxy0hhSNfTIg0ce4iOL2UOk3bTnauY9DO7kf5HoMJGjot3X4BEcURXnOuq97DqJAge1GDOmgN5mS1A6lRd/IW3b/MPwDr2AEULkmsg/qpjHdjQRmGgqoQ3/L20jDaEqZk6fYVdC5uahaqFjBN1jgmxzpZGthMh34V5T9k5WLtdQEWoQJfm5NQgbCNg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1759705273; bh=UJI251AOCKP3+kZ1A8QU8ky/n24N3IcIiKt5kF5yw1f=; h=X-Sonic-MF:From:Subject:Date:To:From:Subject; b=DCfCl+xOcjsoPm4NpPdJI0Iqvqk2BjPmDfPk1jhBUG0l/fZ6P3tJw/UGzN/b7Wl4L4X6EBi9ARlwGqiRsxt5PQGLpabQh8+Y0APCjIJH19lmPMG7PhENDLq24TGBLq0QeDmjIxagw7Dtvb6zWhp1CwU1GyqgULmPJffnTJRUAibBth4zXQh9kcmVn2dWGqb3fwnl8O+rfzcbwxj3NKI8NitR4ZFYqS3Vb0U/8xL7OmAQqX3f5YCPS6xWZUUHyDnhxco5le15ZXLs7O0Qlr1tjpUle2zYBylBihaN+q+ZQnRxMnjAliT6O9OZ+0VJz1ReEyFV0V5/MaYY6LygNoAW0Q== X-YMail-OSG: mZW9uQgVM1lpGMPWGTmCEacvdpz5fdfF8FnjlpnZYHnGCk_t7NbKxegPahZvlQe qYUqkB6U7yywA8i3y7kxpWmLuaqXVA0jezuzTmEFA1C171n1gF8hqFxLWtfmMoH0R3Fa.HVTp5H3 1DvvQDIFmkbkUPE9QR5M_LHZbpc9Cv_hgiY8.aacbbmTx48d2y5kpLrGvls9gv5V5zcc28Vzl4jZ NpdHjcA7zG2bQkhpRbEgnB10Aagbu2qXekDlzFEAPt5yjZllbhYaHIXKlQohYpeRTjflMCs7sLrS fGW34JzTBIx7xQ.FKKp58vSHw9UXB0hBT6dRG.c6uWRDHqc2bPa3vY1xESENhtVwD9SHowcFmWCN Z5lNMdyCrjOlTcDFGGXWgT_3lr3Vc295A4FTcZJsb2xG09cfMNqicTA8E15aKle_9N0zilk_5ULT .npFADIeJdn6Avx.XM4v.QSrf0t3oiIg_w7wo0UNz2TfCTHOLxa5r2ltP_qjiWfg5lnLjJ2XKJCb fFk0O8VuwpY097egE8WSgRdoI._9RfSFb9rMSSVxzbHbY_yQ7jvBTZyu0z7zWmiBg.7xO1Oqp3Zr 5O5mqV4KdEeJsEWpiBLdEVejbODK1MwMu.__VI9IU.aBGzGHZiLft2aT5Xpjv9IPssH46Lz6xyVy Lr8Kq83cJwJxPNJCenxISMe3h1ZS870BBbD9FHkE8fWYUOfcuQTIvecfbFnuGQqBNXowolOsyPbg fLeJSHMQkwhppWL1LcX6hHX3hDkyML10pwRnUewWIf8mOYaRBi2mwE5Hkj0_hUqRjQAlMlOWGXBD zJgxF7Us.0tPLc8HTdTTzJ6xWSvyCL7QSJvwQh6c6aT59kr_Pc62QEy9lLuaY6iEQkmL1o8jYVD5 JbIuOIvexxYMf4A14f.kijDUvnCgLmDg7pLr0aRMjFeiGfDVeQoaLX5Rn6WMoeW8SPi8qDVkonpP d6cyjQHyMlbeerDwEZUio6b9vlbbEZtRe72Px44g1gPQqKfYlqDmcB3qi70XYMuktuFgPlMo1NQO 0HCP_lX0K3VF3U6wiWqTOaBi1W44IzjS3dA3uDwIMKqcarpDYFLsm52YsKzQ2YcpMmhjTY9k7By_ J8w9cHr2A7eJGFwvzEVilt4b2_ECboAs4Ced7xRHnkUVDCqRwaYuW6FwehvVezy6xB15yyhzkXp4 2YV.LE6X07BTCMqnib9FWQ3SMbEoOoIkZ7mwP_dUiDPPuO9pk2imroU1jYCcHVZgLwj95VKuLHP. OxvDD_l3YLGO1Gz760.Wd3Fs7quNWAg82E7JJ9VrwF5_aKF.aeCQDFyDKI1EBTZo9SpqbReEKPit TQ7cQ3wDDSaqBBtrxc4wgqJdQsorQENRLHlrToKuNUUgN.9ipx03ngBAlTdUkPoFr0B0rCqanWIj NbnT1TLkficZWnNZSLlglkGoCm0VK.f.eAzzrRgjao56ESu4IorJ4VPQrHmkTfk1.K3HUP9LN64R U_XNlc2puXeaHZs5KxWlGPLWIhQMgJPMtadWdkYw_CKi.bCif8USL62OXyefL7R9yLoKURk5TaQJ etzaZ4NxQQAKV0is9OALS5tbTR51qFC8dUHv.eNou90bqqccUVNudwQMFXEEotTsJEA27p_Cn09q LhGdvSQLXVmE486CIKQCDF9TJmOoJUzS89OYcdDJwZ2CymLdaVGgBI3vCgj9E.PisqhYfSAdoUZP ENkNCjQdcXc0VwFoUUVDiKUGmfxxuWhxvGzCDF7PGyRNtZKMwLYSlsvccOMpcbe1BbqJA.UaenBC mKOAoJt00GJWU5d9BqrBvotq6y7h_sA0rz2i15QcAhKRvQUjUjSYUl.7CPuFaAhhz9tb5KFwazYs gSLfs52TN83Lt5FeiBtT1Ur1VGYzzjaJbClxR_nQ8EmzpYk1T_L3kC9Gy87r7ucSiVlE7yJkq88M nJ9w7q.WxsWi2IL7kOsBqfRww6U_nQh6bjSgwSoUe_BdTPnvoCCA4QEKU0vLcbvuIZxbNtSKY43B tKNdmFkqFQZhr7eak6w.zJj_kYmViKCPQt.GOTuk3hDUvKRn79mUePXEtzSK31GPpcOjoctv.WXh pl3amx3dGRkx8hgOnX146idukBwguzdqCruOkw7VcB19Nr2eXZziKBfpL31M9S7RF2DbThgTjusv eTEN6n..eI_e8DHqneqBIhUOb2RCakKjbGExTcU6p_rVlLLFNs00OpMKIOa3hJ.yasrBo.QHg.Ms 0yR8t8nu007tFSEGoWMTfIguXV_903NUDPOXpfdPx.01jvxgXxJchfEbADOUcnBrgCT2uiVFB1yK gozU- X-Sonic-MF: X-Sonic-ID: 2095d9ff-a3a3-4f68-be21-dab95c4cbddf Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.gq1.yahoo.com with HTTP; Sun, 5 Oct 2025 23:01:13 +0000 Received: by hermes--production-gq1-66b66ffd5-gdrjw (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID ec5ebf18c53c6bddd885b8696f220e7f; Sun, 05 Oct 2025 23:01:08 +0000 (UTC) From: Mark Millard Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable List-Id: Packaging the FreeBSD base system List-Archive: https://lists.freebsd.org/archives/freebsd-pkgbase List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkgbase@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\)) Subject: 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, 5 Oct 2025 16:00:57 -0700 References: To: FreeBSD-pkgbase@freebsd.org, Baptiste Daroussin , Lexi Winter In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3826.700.81) X-Spamd-Bar: --- X-Spamd-Result: default: False [-3.99 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.99)[-0.995]; DMARC_POLICY_ALLOW(-0.50)[yahoo.com,reject]; R_DKIM_ALLOW(-0.20)[yahoo.com:s=s2048]; R_SPF_ALLOW(-0.20)[+ptr:yahoo.com]; MIME_GOOD(-0.10)[text/plain]; FROM_HAS_DN(0.00)[]; DKIM_TRACE(0.00)[yahoo.com:+]; RCVD_TLS_LAST(0.00)[]; ARC_NA(0.00)[]; TO_DN_SOME(0.00)[]; MIME_TRACE(0.00)[0:+]; DWL_DNSWL_NONE(0.00)[yahoo.com:dkim]; FREEMAIL_FROM(0.00)[yahoo.com]; RCPT_COUNT_THREE(0.00)[3]; ASN(0.00)[asn:36647, ipnet:98.137.64.0/20, country:US]; RCVD_VIA_SMTP_AUTH(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[yahoo.com]; MLMMJ_DEST(0.00)[FreeBSD-pkgbase@freebsd.org]; APPLE_MAILER_COMMON(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; RWL_MAILSPIKE_POSSIBLE(0.00)[98.137.65.147:from]; RCVD_IN_DNSWL_NONE(0.00)[98.137.65.147:from] X-Rspamd-Queue-Id: 4cfyZ43bRjz3QSY On Oct 4, 2025, at 11:16, Mark Millard wrote: > [Note: I do not see this in my amd64 main 16 environment.] >=20 >=20 > Context (evidence of FreeBSD:16:aarch64 status) . . . >=20 > # uname -apKU > FreeBSD aarch64-main-pbase 16.0-CURRENT FreeBSD 16.0-CURRENT = main-n280461-506b36c4fdde GENERIC-NODEBUG arm64 aarch64 1600000 1600000 >=20 > # file `which uname` `which sh` `which pkg` /usr/local/sbin/pkg `which = pkg-static`=20 > /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 >=20 > # 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 >=20 > # pkg-static repos -e > pkg-static: Warning: Major OS version upgrade detected. Running "pkg = bootstrap -f" recommended > FreeBSD-base: {=20 > 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" > } >=20 >=20 > Oddity . . . >=20 > # 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 >=20 >=20 > With debug output . . . >=20 > # 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=3D'table' AND name=3D'repodata';' > DBG(4)[80439]> (db) running: 'select count(key) from repodata WHERE = key =3D "packagesite" and value =3D = '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 =3D tag.annotation_id LEFT JOIN = annotation value ON pkg_annotation.value_id =3D value.annotation_id = WHERE tag.annotation =3D '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 =3D pkg_categories.package_id LEFT JOIN = categories ON categories.id =3D pkg_categories.category_id LEFT JOIN = flavors ON flavors.package_id =3D 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 >=20 > 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 >=20 > 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=3D2014;' > 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=3D'table' AND name=3D'repodata';' > DBG(4)[80439]> (db) running: 'select count(key) from repodata WHERE = key =3D "packagesite" and value =3D = '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 =3D tag.annotation_id LEFT JOIN = annotation value ON pkg_annotation.value_id =3D value.annotation_id = WHERE tag.annotation =3D '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 =3D pkg_categories.package_id LEFT JOIN = categories ON categories.id =3D pkg_categories.category_id LEFT JOIN = flavors ON flavors.package_id =3D p.id ORDER BY p.name;' > DBG(4)[80439]> (db) executing 'PRAGMA journal_mode=3DTRUNCATE;' > DBG(4)[80439]> (db) executing 'PRAGMA synchronous=3DFULL' > DBG(4)[80439]> (db) executing 'PRAGMA foreign_keys=3Don' > DBG(4)[80439]> (db) executing 'PRAGMA mmap_size=3D268435456;' > 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 =3D 209715200;' > DBG(4)[80439]> (db) executing 'PRAGMA page_size =3D 4096;' > DBG(4)[80439]> (db) executing 'PRAGMA foreign_keys =3D OFF;' > DBG(4)[80439]> (db) executing 'PRAGMA journal_mode =3D TRUNCATE;' > DBG(4)[80439]> (db) executing 'PRAGMA synchronous =3D 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' >=20 >=20 >=20 > 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) >=20 > # pkg -dddd rquery -r FreeBSD-base -C -x %n-%v ^=20 > 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=3D'table' AND name=3D'repodata';' > DBG(4)[37710]> (db) running: 'select count(key) from repodata WHERE = key =3D "packagesite" and value =3D = '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 =3D tag.annotation_id LEFT JOIN = annotation value ON pkg_annotation.value_id =3D value.annotation_id = WHERE tag.annotation =3D '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 =3D pkg_categories.package_id LEFT JOIN = categories ON categories.id =3D pkg_categories.category_id LEFT JOIN = flavors ON flavors.package_id =3D 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 >=20 > 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 >=20 > DBG(4)[37710]> (db) running: 'PRAGMA user_version;' > DBG(4)[37710]> (db) executing 'PRAGMA foreign_keys =3D ON;' > DBG(4)[37710]> (db) executing 'PRAGMA mmap_size=3D268435456;' > DBG(4)[37710]> (db) running: 'SELECT count(name) FROM sqlite_master = WHERE type=3D'table' AND name=3D'repodata';' > DBG(4)[37710]> (db) running: 'select count(key) from repodata WHERE = key =3D "packagesite" and value =3D = '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 =3D tag.annotation_id LEFT JOIN = annotation value ON pkg_annotation.value_id =3D value.annotation_id = WHERE tag.annotation =3D '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 =3D pkg_categories.package_id LEFT JOIN = categories ON categories.id =3D pkg_categories.category_id LEFT JOIN = flavors ON flavors.package_id =3D p.id ORDER BY p.name;' > DBG(4)[37710]> (db) executing 'PRAGMA journal_mode=3DTRUNCATE;' > DBG(4)[37710]> (db) executing 'PRAGMA synchronous=3DFULL' > DBG(4)[37710]> (db) executing 'PRAGMA foreign_keys=3Don' > DBG(4)[37710]> (db) executing 'PRAGMA mmap_size=3D268435456;' > 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 =3D tag.annotation_id LEFT JOIN = annotation value ON pkg_annotation.value_id =3D value.annotation_id = WHERE tag.annotation =3D '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 =3D pkg_categories.package_id LEFT JOIN = categories ON categories.id =3D pkg_categories.category_id LEFT JOIN = flavors ON flavors.package_id =3D 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. =3D=3D=3D Mark Millard marklmi at yahoo.com