Description of problem: Unable to delete a GPG key that is associated with a product. Version-Release number of selected component (if applicable): katello-selinux-1.4.3-1.git.4.99dc194.el6.noarch katello-qpid-broker-key-pair-1.0-1.noarch katello-all-1.4.2-1.git.983.e3af4c9.el6.noarch katello-cli-common-1.4.2-1.git.137.fea0d84.el6.noarch katello-configure-1.4.3-1.git.67.f71e590.el6.noarch signo-katello-0.0.9-1.el6.noarch katello-glue-pulp-1.4.2-1.git.983.e3af4c9.el6.noarch katello-candlepin-cert-key-pair-1.0-1.noarch katello-certs-tools-1.4.2-1.el6.noarch katello-common-1.4.2-1.git.983.e3af4c9.el6.noarch katello-glue-candlepin-1.4.2-1.git.983.e3af4c9.el6.noarch katello-1.4.2-1.git.983.e3af4c9.el6.noarch katello-repos-1.4.2-1.el6.noarch katello-cli-1.4.2-1.git.137.fea0d84.el6.noarch katello-glue-elasticsearch-1.4.2-1.git.983.e3af4c9.el6.noarch katello-qpid-client-key-pair-1.0-1.noarch How reproducible: Everytime Steps to Reproduce: 1. provider create --name FirstProv --org ACME_Corporation 2. product create --name FirstProd --provider FirstProv --org ACME_Corporation 3. gpg_key create --name FirstKey --org ACME_Corporation 4. product update --name FirstProd --gpgkey FirstKey --org ACME_Corporation 5. repo create --name FirstRepo --org ACME_Corporation --product FirstProd --url $repoURL 6. gpg_key delete --name FirstKey --org ACME_Corporation Actual results: ERROR: update or delete on table "gpg_keys" violates foreign key constraint "products_gpg_key_id_fk" on table "products" DETAIL: Key (id)=(1) is still referenced from table "products". Expected results: Successful gpg key deletion
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release.
fixed in 6a40eba9618409b004807484fdb0dcf1a6d9f60a
# VERIFIED automation passes ok now on this. checked against: === candlepin-0.8.25-1.el6sam.noarch candlepin-cert-consumer-demeter.usersys.redhat.com-1.0-1.noarch candlepin-scl-1-5.el6_4.noarch candlepin-scl-quartz-2.1.5-5.el6_4.noarch candlepin-scl-rhino-1.7R3-1.el6_4.noarch candlepin-scl-runtime-1-5.el6_4.noarch candlepin-selinux-0.8.25-1.el6sam.noarch candlepin-tomcat6-0.8.25-1.el6sam.noarch createrepo-0.9.9-21.2.pulp.el6sat.noarch elasticsearch-0.19.9-8.el6sat.noarch katello-1.4.6-40.el6sat.noarch katello-agent-1.4.4-3.el6sat.noarch katello-all-1.4.6-40.el6sat.noarch katello-candlepin-cert-key-pair-1.0-1.noarch katello-certs-tools-1.4.4-1.el6sat.noarch katello-cli-1.4.3-24.el6sat.noarch katello-cli-common-1.4.3-24.el6sat.noarch katello-common-1.4.6-40.el6sat.noarch katello-configure-1.4.7-6.el6sat.noarch katello-configure-foreman-1.4.7-6.el6sat.noarch katello-foreman-all-1.4.6-40.el6sat.noarch katello-glue-candlepin-1.4.6-40.el6sat.noarch katello-glue-elasticsearch-1.4.6-40.el6sat.noarch katello-glue-pulp-1.4.6-40.el6sat.noarch katello-qpid-broker-key-pair-1.0-1.noarch katello-qpid-client-key-pair-1.0-1.noarch katello-selinux-1.4.4-4.el6sat.noarch m2crypto-0.21.1.pulp-8.el6sat.x86_64 mod_wsgi-3.4-1.pulp.el6sat.x86_64 pulp-katello-plugins-0.2-1.el6sat.noarch pulp-nodes-common-2.3.0-0.22.beta.el6sat.noarch pulp-nodes-parent-2.3.0-0.22.beta.el6sat.noarch pulp-puppet-plugins-2.3.0-0.22.beta.el6sat.noarch pulp-rpm-handlers-2.3.0-0.22.beta.el6sat.noarch pulp-rpm-plugins-2.3.0-0.22.beta.el6sat.noarch pulp-selinux-2.3.0-0.22.beta.el6sat.noarch pulp-server-2.3.0-0.22.beta.el6sat.noarch python-isodate-0.5.0-1.pulp.el6sat.noarch python-oauth2-1.5.170-3.pulp.el6sat.noarch python-pulp-agent-lib-2.3.0-0.22.beta.el6sat.noarch python-pulp-bindings-2.3.0-0.22.beta.el6sat.noarch python-pulp-common-2.3.0-0.22.beta.el6sat.noarch python-pulp-puppet-common-2.3.0-0.22.beta.el6sat.noarch python-pulp-rpm-common-2.3.0-0.22.beta.el6sat.noarch python-qpid-0.18-5.el6_4.noarch qpid-cpp-client-0.14-22.el6_3.x86_64 qpid-cpp-client-ssl-0.14-22.el6_3.x86_64 qpid-cpp-server-0.14-22.el6_3.x86_64 qpid-cpp-server-ssl-0.14-22.el6_3.x86_64 ruby193-rubygem-foreman-katello-engine-0.0.17-6.el6sat.noarch ruby193-rubygem-katello-foreman-engine-0.0.12-3.el6sat.noarch ruby193-rubygem-katello_api-0.0.3-4.el6sat.noarch ruby193-rubygem-ldap_fluff-0.2.2-2.el6sat.noarch signo-katello-0.0.23-2.el6sat.noarch
This was verified and delivered with MDP2. Closing it out.
This was delivered and verified with MDP2. Closing the bug.