From nobody Sat Oct 4 18:16:32 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 4cfDJR3LRyz69WCW for ; Sat, 04 Oct 2025 18:16:55 +0000 (UTC) (envelope-from marklmi@yahoo.com) Received: from sonic304-24.consmr.mail.gq1.yahoo.com (sonic304-24.consmr.mail.gq1.yahoo.com [98.137.68.205]) (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 4cfDJQ1W2zz3gKT for ; Sat, 04 Oct 2025 18:16:54 +0000 (UTC) (envelope-from marklmi@yahoo.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=yahoo.com header.s=s2048 header.b=SpZ4m0tx; dmarc=pass (policy=reject) header.from=yahoo.com; spf=pass (mx1.freebsd.org: domain of marklmi@yahoo.com designates 98.137.68.205 as permitted sender) smtp.mailfrom=marklmi@yahoo.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1759601807; bh=bkQcOMF62siEJR1DP0cmMdHe0rEgwq2Hu/I/9Kouoak=; h=From:Subject:Date:To:References:From:Subject:Reply-To; b=SpZ4m0tx9umJ+OJGy2N/ZDq8wSc3bXDc32X/AsmV4HJj9HMSK3OQu1MO7rty7+bFZnctGSIcAzt1bvAxI+NVwCAxcMfkKCiia711PFhWO/EY7718xmsOpsm35UcIEhAHi/jsiPF0RhW7VDt7Yw82DdnW65DehX9rdy2n8JgsM41k7H+W+KoMEf0x+0yEzeIs9o2OGi7xOE5qNeNUTtgjheudU/qJBWGu5azX8Cd8nNVfVPa5SKxgknBfFNvz4+pIcvQobPixkfoS+AhrMru8wMPIqz+wrw/+krgaZPnApLsRuwm9aVD7AglT/URlM4jsj6XPDrObUNeUKwJHhvpDvg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1759601807; bh=zS68dP+/EO/fWbfESftouF/eSS08eWlMNUDk7a53OyS=; h=X-Sonic-MF:From:Subject:Date:To:From:Subject; b=mP/1Ue10pi0y2FxflK+JEIJMBM1igDfGTKI2dPvVmEBZB1qJ18CqVa41+OGmU/DMuMRQyn7S1pxcBuRx/mImNMOSeKloon7aVvSS19ANGHhvydOGEE1m6SztcmeQLigtv/Nv3mJcHDiWQzTY3Y0O9b87znCCGkExOoZiAgBbZFBvFYpzvqsqQrlOaVo4EAE43xdXD4qgH2rC/LPGzptyQLMPg5DLyM2zbaMT/1lh7eLDr3x948btJzUbp/EAP3Qc9qxSb/vt9T3iJ4YKMCpRerLt5fTbJPWI9Y6kQBz441JunIV6q+tfptPhp7GysrWjfhj8RYiFtxCFgLE/ltb0Ew== X-YMail-OSG: teCPcL0VM1mtiHZmFUK2MMEZNK538uRPztDzq7Ue8UuC9zwTnxNTF5wlaT_gi_8 xHqfbre1nqIfIR024mjqT49ylITh8SyaL3jR8_1mR34cZuvrrhHrwqXC0iv_O9NebDbQbzTWEcKb UZJK6H1OQsR99_0qnyvqeuIOQubruOPweA.0J5d6FW4IFIm8ccxFYZ1TnR5RNBrircldWRW8guid qEjn.jxw5E3XD9_aY.VuHuKMoFL6TnhB0WiwN_6XEagprhnH5TQfT7i3VYpmfSCY_i4EIVXVIMMe z0juyvvYfeyVKvs4huiROn_Wz.tL3sO81oG..ovfEB8iZq5ckpSRfv5JYG0JcyQOzM8jrUMLYpYl 0uTD4uq9m4z3YLONeInNQDW0gCLqAuNkWAElmOuAt79c0xC4yCQpfJPufzkBJunGmRSyhJLJFiNH SC_rZQ1COv7nab_g1zjuZi.wYu4V0U8FkupCTJVVXKSMTgFi3i7dVsuqB43zRuLYDJ3ppX_YnAX5 XAZoU3OKTWaWRgd48obRGZKVxiiapLKbxODdipmvY4nEiYjvs815MNVRA6qaifZrzSWp_LAn7WxS zOjzbvlAnpYfx8ABSyi5mFzBbFkthiAmoQ7NMEdutkq2DUAM0n6IlfTZo5FE_YhD3oHbYNQwfBv0 FegBKWTDneTGKk7.KKA1G4jH.LEaLsxkiOM_aSiSXPRR7gbuSm6yG_AGTFMIx3pYJStLtkVg1chy S_PHPF4YfQVgA5GVH8yJoIAnbxhk3AxUfHd3l6QTGV.jT5QVMbsZEUOo8AALmYIT_1XnjxHefeRV VtjOMBbUhiGTJBZoE6bxM48vU0feXtF_XZ6Qu4q_0SX4avVdv_l4sIPPZ3UAZx50MhoVmXincJj8 eJkX1UiFlDWqfZk12dRFpFWqv7FjmCV0NemX0xX.X19Zg20J.wXide8D8DdkUJuh8K4tnuV_5B3O vmvNg6Gp2GPJED4OeX0JxDJRAQARlEgFEWHWJwvdfjb8d5rKME4N3oNcwg5.51IAVZ7W3.Sh.cEk esX1oy9ORVdK2o_jbuAISxLlmBtT87sMlr3IejE9YsUHvrM3FPtoKWQIRfW23azL.hc6oPUwc9ye 2JPv.k3lLmCDQuhfq6PW8vvodly0VRnEFhUnDelMU6HNkCREM3wGDCGWRWYFCoLubNDN.rfpQ.bZ jqDmNJUHXisphy3.4TuXr.MBVpwh4HahZGBZOQarh8bDb9dHkpZpVQxa8vKORq3_Rff4om5bNg3D q.aSIEYSf7p1kSlx7aPrXISAHyBCLA3j47wyX4vaCpCzWS0VlhvSjaDIDS_hZktE6eVerwKkA.om Al17wpwMve5JXVKP7DU8jRqnI5g7i3QfFtTkMaufGoFPOFKb2D86HUx3zLCFRB1CKWSDT.7OP9dy PpJ5TKgQprteUoqrRb4kYB.aCjeXwDlhjG64VnF0VOmEV5C4eTiHaKld8EBMAcCyUrgiw8BMLBCT VZGh4ZqNMsm6CD8OjnDCNssoR2xWcA0af8wj2ag_.U4ruO_W7vmhvZcSxGOyg1t4at2_L0m0oHW9 OXEmfGk8fkf.qUsEyed5qzQAenjEmv19JzIvD44Yc2w8gBq77YqPJhaKbbERtK3wyiKgRFXzWB19 5uRaRzAIrvyi_q7s0qKT.yctLkacISfwVeeQDOwzc6n2h4je5XdBKB1fhR0rvRai2wXVrLXx687l JcOMpZmN7tpZ08jYr_x5PKxSmfZjFhNLNso4vwU4Z2KWjB_Rgnbc0iSutktzNp7sYLcT6hmAxHZW cGdMkd5AyMoJizAVEkovWzrTr.6EmADIwIOAsdGXD8TW5lNGqGh10TVyz.RdRRIFNPKzqmba.GgT lRKjB1uEOk7scn4folwXXaxWFpd8qzJ8gkACCD_p1enGC6FWbMiAQn6D.QNnBc0O9VNa.IyP1OAV uz.2x3ww71RGp1Ma8xCZW1mCeTcXPdYq.hR0xkh9363Yf6nXokZm5IlRUGbB2gn.cJk1tpcoBLVd tamKq7SABVWSyXL8gXiohe5Nett7x5jRHr665KacbiGEJHDhNyKpv3kwLCHeZcj27vKuytk3hEqY G4TvATjrN5ZLRjk2E3dGYh9f4mfliqr9_TPb.ZBNKbXKyi7CarWF4YhKrTG.u0XErErl1q5aGgFH DPuYcBpZVyBamq_LfWJVsBsNq78xGt_Vp3n4T65OofMSK8Pe9kDCWyp4QrRSnSgWAJ.oSDN_ZMqU TAhbQU6W_RDlieEATB9JwmEiAZKIiAG.KY5VlgmdlyniYMCcGAxGR9LnY.jyjlWwcK1j70pBryms KVA-- X-Sonic-MF: X-Sonic-ID: f4192e3c-0862-47ed-8e59-27bf690167fc Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.gq1.yahoo.com with HTTP; Sat, 4 Oct 2025 18:16:47 +0000 Received: by hermes--production-gq1-66b66ffd5-rbd2r (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID e510abfc697f409f7b95417fb016f865; Sat, 04 Oct 2025 18:16:43 +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: pkg rquery -r FreeBSD-base failure on aarch64 system: "pkg: repository FreeBSD-base contains packages for wrong OS version: FreeBSD:16:aarch64" Message-Id: Date: Sat, 4 Oct 2025 11:16:32 -0700 To: FreeBSD-pkgbase@freebsd.org, Baptiste Daroussin , Lexi Winter X-Mailer: Apple Mail (2.3826.700.81) References: X-Spamd-Bar: --- X-Spamd-Result: default: False [-3.62 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-0.99)[-0.994]; NEURAL_HAM_SHORT(-0.62)[-0.623]; 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.68.205:from]; RCVD_IN_DNSWL_NONE(0.00)[98.137.68.205:from] X-Rspamd-Queue-Id: 4cfDJQ1W2zz3gKT [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`=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 # 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: {=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" } 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=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 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=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' 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 ^=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 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 =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 . . . =3D=3D=3D Mark Millard marklmi at yahoo.com