koji

#1752 'koji list-pkgs --tag=x' returns bogus package ownership data in 1.19.0
Closed: Fixed by tkopecek. Opened by jforaker.

Closed: Fixed
Reopen Issue

After upgrading to 1.19.0, we found that listing the packages on a tag showed all of the packages being owned by only 1-2 random users, which was not at all accurate. Inspection of the SQL database however showed the underlying ownership data to be reasonable. Code inspection then revealed what appears to be a typo in readPackageList() introduced by the recent Kerberos support changes:

    q = """
    SELECT %(flist)s
    FROM tag_packages
    JOIN tag on tag.id = tag_packages.tag_id
    JOIN package ON package.id = tag_packages.package_id
    JOIN tag_package_owners ON
        tag_packages.tag_id = tag_package_owners.tag_id AND
        tag_packages.package_id = tag_packages.package_id
    JOIN users ON users.id = tag_package_owners.owner
    WHERE %(cond1)s AND %(cond2)s"""

tag_packages.package_id is being compared against itself, instead of against tag_package_owners.package_id.

Metadata Update from @tkopecek:
- Custom field Size adjusted to small
- Issue priority set to: High (was: Normal)
- Issue set to the milestone: 1.20
- Issue tagged with: bug

Merged #1753

Metadata Update from @tkopecek:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.19.1 (was: 1.20)

Metadata Update from @jcupova:
- Issue tagged with: testing-done

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/1752

Please continue any further discussion there.
Metadata
None

bug testing-done

None
None
Lowest
small
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.