From nobody Tue Jan 28 14:57:34 2025 X-Original-To: pkg@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 4Yj7gL3NGZz5lZ8k for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Yj7gL2gH3z3dpR for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1738076254; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Sj8J2tFV+Afz1XMSlD59qJECYa4FGOyXmTfax1JTiY8=; b=s6NHfiXGYFdkyi9F/Tj0ik8f3jgoW4eQDhIs2PiCbL3i1ydaQ4FnV9/1pKdlOpqUojVNVp Tc/rn96y2IGJiLvbzQoNT6vaFDZgiOTst4BWoNL6b6xI4Gwoy502ZIRnmIFlKNDEPhLNXw fw4EQp6RLgy+R8hs19bdeCEi0/PEC17N0SpYu1o4dulX0uMHg7yR7IBwE5KAiPpnRSY+UY zWu26ZpavZJfL8Ggy3EM5wYnNScEqSzMg0O9uMH84+c85GrOt23fF9pvcOLx0uSnXUtHo/ 1aKUoNDE8Ck7+JHP07rJnrIOIcChSoTlJX2novtbwef+GmzOr+qsPyCwKAbHPQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1738076254; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Sj8J2tFV+Afz1XMSlD59qJECYa4FGOyXmTfax1JTiY8=; b=bhnfqfbXmgEqgg1lJjaTKd97S6nvxPC5oUZl24PqX6blHo+KzRmmSzFbMkXgoUC3ggDO1w ytWibNXDbuNeQn+ryqEGtsajyrwIeBNWlH0y4xztpGYBu127FXZvp9tQK867jNOLEULvFc mfdTKJNU9l9D+WwE0arrbQ/ob9CvdCa3qDc1TBABdSebDi0RmugIa2xgNDxqFtZ2TBp+wk QLf6KA/7+W+Xen6WL3VOjkXA/jbSZ2HReq9drNlxRf9uS4Hk+93PfpCH57ciIvLI0355Aa l9Njb8w2lTyZvHCeG/tAYuokjk5zhNewqShcsqacTuUvkzWumpHny8A0Zk201Q== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1738076254; a=rsa-sha256; cv=none; b=jdYSHpw1Qz4QgwqhHWGtOhrZmG21YFUTMdhkNPgbN3PnYda31CpXNV6IcFUWBT9qPhvNvS Zt7Q1pHMhzj0gsB8NswYpjXMswLsoQUty0PgkcFDaWdNDMrR6QCup4o+hADUqT3+odIfOH ZwSDIwK/TRTXGRbmjWplYGUfU4fkt0F3p2/Qcs3IU4kWr/m4/Be7x9cufZURy5XjTqJS3s 5OhgTPXm+YUoDxHv0N+RJo7G2SMRrjcEFIMdTyJrWkZsPT4beIXjlTLGyRidwO3wL89Xfo T/X96B3S8UtBqAc31cmMeoFal5H67gFf1IN95iLLOFMZv/dOAG0gQ6MxJJV8mw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4Yj7gL2FfNz4Yc for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 50SEvY83037961 for ; Tue, 28 Jan 2025 14:57:34 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 50SEvYlT037960 for pkg@FreeBSD.org; Tue, 28 Jan 2025 14:57:34 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: maintainer-feedback requested: [Bug 284411] ports-mgmt/pkg: alias 'prime-origins' - introduced pipe fails Date: Tue, 28 Jan 2025 14:57:34 +0000 X-Bugzilla-Type: request X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? Message-ID: In-Reply-To: References: X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@FreeBSD.org MIME-Version: 1.0 Bugzilla Automation has asked freebsd-pkg (Nobody) for maintainer-feedback: Bug 284411: ports-mgmt/pkg: alias 'prime-origins' - introduced pipe fails https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D284411 --- Description --- Reference forum starts at: https://forums.freebsd.org/threads/pkg-2-0-0-problems.96540/page-4#post-687= 722 Using 14.2R and the 'latest' repository, using the pkg alias: prime-origins: "query -e '%a =3D 0' '%o' | sort -u", as defined in /usr/local/etc/pkg.conf introduces a pipe; it seems for the first time. Related commits: https://github.com/freebsd/pkg/commit/e52fcfac6b1a02b046da36b1d324fb84e5a00= bb1 https://github.com/freebsd/pkg/commit/cce9724f190a1dbedac66cbdac2c1031c22cb= 864 The implementation of the pipe fails to work using pkg(8) 1.21.3 and, confi= rmed in the forum, for 2.0.4. The command sequence below details the unexpected empty result of=20 pkg prim-origins and its likely cause in the underlying query by using debug level 4. Also shown that using the previous non-pipe variant of the alias and uapply= ing the pipe externally gets the exepected result. An empty line was added in t= he debug output to indicate the first immediate occurrence in a 'LEFT JOIN'.=20 --- [0-0] # pkg -v 1.21.3 [1-0] # pkg -vv | sed -n -e '/DEBUG/ p' -e '/^Repositories:/,$ p' DBG(1)[2298]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2298]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD DBG(1)[2298]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2298]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2298]> PkgConfig: overwriting repository FreeBSD DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD DBG(1)[2298]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD-kmods DEBUG_SCRIPTS =3D false; DEBUG_LEVEL =3D 4; Repositories: FreeBSD: { url : "pkg+https://pkg.freebsd.org/FreeBSD:14:amd64/latest", enabled : yes, priority : 0, mirror_type : "SRV", signature_type : "FINGERPRINTS", fingerprints : "/usr/share/keys/pkg" } FreeBSD-kmods: { url : "pkg+https://pkg.freebsd.org/FreeBSD:14:amd64/kmods_latest_2", enabled : yes, priority : 0, mirror_type : "SRV", signature_type : "FINGERPRINTS", fingerprints : "/usr/share/keys/pkg" } [2-0] # pkg alias prime-origins DBG(1)[2301]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2301]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD DBG(1)[2301]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2301]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2301]> PkgConfig: overwriting repository FreeBSD DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD DBG(1)[2301]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD-kmods prime-origins 'query -e '%a =3D 0' '%o' | sort -u' [3-0] # pkg prime-origins DBG(1)[2305]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2305]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD DBG(1)[2305]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2305]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2305]> PkgConfig: overwriting repository FreeBSD DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD DBG(1)[2305]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD-kmods DBG(4)[2305]> Pkgdb: running: 'PRAGMA user_version;' DBG(4)[2305]> Pkgdb: executing 'PRAGMA foreign_keys =3D ON;' DBG(4)[2305]> Pkgdb: executing 'PRAGMA mmap_size=3D268435456;' DBG(4)[2305]> Pkgdb: 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,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.package_= id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id=20=20= =20=20 LEFT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D '|' = COLLATE NOCASE OR p.name || '-' || version =3D '|' COLLATE NOCASE) AND (automatic= =3D0) ORDER BY p.name;' DBG(4)[2305]> Pkgdb: 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,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.package_= id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id LE= FT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D 'sort' C= OLLATE NOCASE OR p.name || '-' || version =3D 'sort' COLLATE NOCASE) AND (automati= c=3D0) ORDER BY p.name;' DBG(4)[2305]> Pkgdb: 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,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.package_= id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id LE= FT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D '-u' COL= LATE NOCASE OR p.name || '-' || version =3D '-u' COLLATE NOCASE) AND (automatic= =3D0) ORDER BY p.name;' [4->1<] # --- Combining the 'core' of prime-origins with the pipe used outside of the ali= as works fine: [20-0] # pkg alias ppp ppp 'query -e '%a =3D 0' '%o'' [21-0] # pkg ppp | sort -u misc/freebsd-doc-nl x11/xorg [22-0] #