Bug 1187696
| Summary: | hammer content-host list by erratum id failed | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | sthirugn <sthirugn> | ||||
| Component: | Hammer | Assignee: | Stephen Benjamin <stbenjam> | ||||
| Status: | CLOSED WORKSFORME | QA Contact: | sthirugn <sthirugn> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | Nightly | CC: | bbuckingham, sthirugn | ||||
| Target Milestone: | Unspecified | Keywords: | Triaged | ||||
| Target Release: | Unused | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2015-03-26 08:19:40 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | |||||||
| Bug Blocks: | 1130651, 1188301 | ||||||
| Attachments: |
|
||||||
Created attachment 986087 [details]
foreman-debug
Created attachment 986090 [details]
error log
I can't reproduce this: [root@prometheus ~]# hammer content-host list --erratum-id=31d45294-ccaf-42f5-b3d9-ddcbec43b50f --organization-id 2 -------------------------------------|------------------|------------------- ID | NAME | INSTALLABLE ERRATA -------------------------------------|------------------|------------------- d22349bd-575e-4541-ae87-540adce7425e | asgard.bitbin.de | 12 -------------------------------------|------------------|------------------- Can you confirm this is still an issue? |
Description of problem: hammer content-host list by erratum id failed Version-Release number of selected component (if applicable): * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.38-1.el6.noarch * candlepin-common-1.0.18-1.el6.noarch * candlepin-selinux-0.9.38-1.el6.noarch * candlepin-tomcat6-0.9.38-1.el6.noarch * elasticsearch-0.90.10-7.el6.noarch * foreman-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-compute-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-gce-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-libvirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-ovirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-postgresql-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-proxy-1.8.0-0.develop.201501280951gite1bc928.el6.noarch * foreman-release-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-selinux-1.8.0-0.develop.201412151103gite2863e4.el6.noarch * foreman-vmware-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * katello-2.1.0-1.201411061509gitb0b8f43.el6.noarch * katello-certs-tools-2.0.1-1.el6.noarch * katello-default-ca-1.0-1.noarch * katello-installer-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-installer-base-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-repos-2.1.1-1.el6.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.39-8.el6.x86_64 * openldap-devel-2.4.39-8.el6.x86_64 * pulp-docker-plugins-0.2.1-0.2.beta.el6.noarch * pulp-katello-0.3-3.el6.noarch * pulp-nodes-common-2.5.1-1.el6.noarch * pulp-nodes-parent-2.5.1-1.el6.noarch * pulp-puppet-plugins-2.5.1-1.el6.noarch * pulp-puppet-tools-2.5.1-1.el6.noarch * pulp-rpm-plugins-2.5.1-1.el6.noarch * pulp-selinux-2.5.1-1.el6.noarch * pulp-server-2.5.1-1.el6.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-ldap_fluff-0.3.3-1.el6.noarch * ruby193-rubygem-net-ldap-0.10.0-1.el6.noarch * ruby193-rubygem-runcible-1.3.0-1.el6.noarch How reproducible: Always Steps to Reproduce: hammer> content-host list --erratum-id=6b3f8b99-f4a5-42fa-82af-1e04b28d8f4e --organization-id=1 PGError: ERROR: column reference "uuid" is ambiguous LINE 1: SELECT uuid FROM "katello_systems" INNER JOIN "katello_syste... ^ : SELECT uuid FROM "katello_systems" INNER JOIN "katello_system_errata" ON "katello_system_errata"."system_id" = "katello_systems"."id" INNER JOIN "katello_errata" ON "katello_errata"."id" = "katello_system_errata"."erratum_id" WHERE "katello_errata"."id" IN (SELECT "katello_errata"."id" FROM "katello_errata" WHERE "katello_errata"."uuid" IN ('6b3f8b99-f4a5-42fa-82af-1e04b28d8f4e')) Actual results: as shown above Expected results: content-host list by erratum-id should work fine Additional info: