+++ This bug was initially created as a clone of Bug #1007117 +++ Description of problem: Unable to delete an activation key after using it to register a system Version-Release number of selected component (if applicable): * candlepin-0.8.25-1.el6sam.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 * elasticsearch-0.19.9-8.el6sat.noarch * katello-candlepin-cert-key-pair-1.0-1.noarch * katello-certs-tools-1.4.2-2.el6sat.noarch * katello-cli-1.4.3-10.el6sat.noarch * katello-cli-common-1.4.3-10.el6sat.noarch * katello-common-1.4.3-12.el6sam_splice.noarch * katello-configure-1.4.4-4.el6sat.noarch * katello-glue-candlepin-1.4.3-12.el6sam_splice.noarch * katello-glue-elasticsearch-1.4.3-12.el6sam_splice.noarch * katello-headpin-1.4.3-12.el6sam_splice.noarch * katello-headpin-all-1.4.3-12.el6sam_splice.noarch * katello-selinux-1.4.4-2.el6sat.noarch * thumbslug-0.0.34-1.el6sam.noarch * thumbslug-selinux-0.0.34-1.el6sam.noarch How reproducible: Always Steps to Reproduce: 1. Log in to SAM UI 2. Create an Activation key and attach a subscription to it 3. Register and subscribe a client using this activation key 4. Attempt to remove the activation key Actual results: UI error: ERROR: update or delete on table "activation_keys" violates foreign key constraint "key_pools_activation_key_id_fk" on table "key_pools" DETAIL: Key (id)=(1) is still referenced from table "key_pools". (PGError) Click here for more details. Expected results: Activation key deleted successfully Additional info: --- Additional comment from RHEL Product and Program Management on 2013-09-11 20:01:45 EDT --- This bug report has Keywords: Regression or TestBlocker. Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP. --- Additional comment from on 2013-09-11 20:13:21 EDT --- Correction: Refreshing the page removed the activation key from UI. But trying to create another activation key with the same name errored out saying Validation Failed: Name has already been taken It seems like the previous activation key is partially removed and this is a problem and it needs to be fixed to remove all its references. --- Additional comment from Tom McKay on 2013-09-23 13:28:11 EDT --- Branch: refs/heads/master Home: https://github.com/Katello/katello Commit: eb3248f774bca8a7ecfdc1241ea5952c6caaf768 https://github.com/Katello/katello/commit/eb3248f774bca8a7ecfdc1241ea5952c6caaf768 Author: Tom McKay <thomasmckay> Date: 2013-09-23 (Mon, 23 Sep 2013) --- Additional comment from errata-xmlrpc on 2013-09-24 16:54:42 EDT --- Bug report changed to ON_QA status by Errata System. A QE request has been submitted for advisory RHEA-2013:15469-01 https://errata.devel.redhat.com/advisory/15469 --- Additional comment from on 2013-09-25 10:19:50 EDT --- Verified. Worked fine in both UI and CLI Version Tested: * candlepin-0.8.26-1.el6sam.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.26-1.el6sam.noarch * candlepin-tomcat6-0.8.26-1.el6sam.noarch * elasticsearch-0.19.9-8.el6sat.noarch * katello-candlepin-cert-key-pair-1.0-1.noarch * katello-certs-tools-1.4.2-2.el6sat.noarch * katello-cli-1.4.3-11.el6sat.noarch * katello-cli-common-1.4.3-11.el6sat.noarch * katello-common-1.4.3-16.el6sam_splice.noarch * katello-configure-1.4.4-5.el6sam.noarch * katello-glue-candlepin-1.4.3-16.el6sam_splice.noarch * katello-glue-elasticsearch-1.4.3-16.el6sam_splice.noarch * katello-headpin-1.4.3-16.el6sam_splice.noarch * katello-headpin-all-1.4.3-16.el6sam_splice.noarch * katello-selinux-1.4.4-2.el6sat.noarch * thumbslug-0.0.34-1.el6sam.noarch * thumbslug-selinux-0.0.34-1.el6sam.noarch --- Additional comment from errata-xmlrpc on 2013-10-01 00:25:48 EDT --- Bug report changed to RELEASE_PENDING status by Errata System. Advisory RHEA-2013:15469-02 has been changed to PUSH_READY status. https://errata.devel.redhat.com/advisory/15469 --- Additional comment from errata-xmlrpc on 2013-10-01 07:25:48 EDT --- Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHEA-2013-1390.html
cherry-picked to SATELLITE-6.0.2 branch,
Tested on revision: Katello-Katello-Installation-RegisterRHNClassic-1.1-4.noarch foreman-1.3.0-17.el6sat.noarch katello-cli-1.4.3-20.el6sat.noarch pulp-selinux-2.3.0-0.17.beta.el6sat.noarch openldap-2.4.23-31.el6.x86_64 apr-util-ldap-1.3.9-3.el6_0.1.x86_64 python-ldap-2.3.10-1.el6.x86_64 katello-certs-tools-1.4.4-1.el6sat.noarch pulp-nodes-parent-2.3.0-0.17.beta.el6sat.noarch elasticsearch-0.19.9-8.el6sat.noarch katello-glue-candlepin-1.4.6-31.el6sat.noarch candlepin-tomcat6-0.8.25-1.el6sam.noarch candlepin-cert-consumer-dionysus.usersys.redhat.com-1.0-1.noarch Katello-Katello-Installation-Satellite6Latest-1.0-12.noarch candlepin-scl-rhino-1.7R3-1.el6_4.noarch katello-candlepin-cert-key-pair-1.0-1.noarch katello-qpid-client-key-pair-1.0-1.noarch signo-0.0.22-2.el6sat.noarch foreman-proxy-1.3.0-3.el6sat.noarch foreman-postgresql-1.3.0-17.el6sat.noarch katello-cli-common-1.4.3-20.el6sat.noarch katello-configure-1.4.7-3.el6sat.noarch pulp-server-2.3.0-0.17.beta.el6sat.noarch pulp-nodes-common-2.3.0-0.17.beta.el6sat.noarch pulp-puppet-plugins-2.3.0-0.17.beta.el6sat.noarch candlepin-scl-1-5.el6_4.noarch ruby193-rubygem-net-ldap-0.3.1-3.el6sat.noarch candlepin-selinux-0.8.25-1.el6sam.noarch signo-katello-0.0.22-2.el6sat.noarch katello-selinux-1.4.4-4.el6sat.noarch katello-glue-elasticsearch-1.4.6-31.el6sat.noarch katello-1.4.6-31.el6sat.noarch katello-configure-foreman-1.4.7-3.el6sat.noarch katello-all-1.4.6-31.el6sat.noarch pulp-rpm-handlers-2.3.0-0.17.beta.el6sat.noarch katello-agent-1.4.4-3.el6sat.noarch candlepin-scl-runtime-1-5.el6_4.noarch katello-configure-foreman-proxy-1.4.7-3.el6sat.noarch pulp-rpm-plugins-2.3.0-0.17.beta.el6sat.noarch pulp-katello-plugins-0.2-1.el6sat.noarch candlepin-scl-quartz-2.1.5-5.el6_4.noarch candlepin-0.8.25-1.el6sam.noarch katello-common-1.4.6-31.el6sat.noarch katello-glue-pulp-1.4.6-31.el6sat.noarch katello-foreman-all-1.4.6-31.el6sat.noarch ruby193-rubygem-ldap_fluff-0.2.2-2.el6sat.noarch katello-qpid-broker-key-pair-1.0-1.noarch Katello-Katello-Configuration-KatelloClient-1.1-53.noarch Katello-Katello-Sanity-ImportKeys-1.2-1.noarch The same problem still exists. Steps: 1. create org, custom repo (zoo) 2. create content definition, add zoo repo, publish, promote do 'dev' environment 3. create activation key on 'dev' environment using published view and attach custom product (zoo repo) subscription. 4. register client via rhsm using activation key 5. try to remove activation key in UI. the same foreign key error is shown: "ERROR: update or delete on table "activation_keys" violates foreign key constraint "key_pools_activation_key_id_fk" on table "key_pools" DETAIL: Key (id)=(5) is still referenced from table "key_pools". (PGError)"
@Hayk - I was able to deleted a used activation key. Can you please try steps again? candlepin-0.8.25-1.el6sam.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-31.el6sat.noarch katello-all-1.4.6-31.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-20.el6sat.noarch katello-cli-common-1.4.3-20.el6sat.noarch katello-common-1.4.6-31.el6sat.noarch katello-configure-1.4.7-3.el6sat.noarch katello-configure-foreman-1.4.7-3.el6sat.noarch katello-configure-foreman-proxy-1.4.7-3.el6sat.noarch katello-foreman-all-1.4.6-31.el6sat.noarch katello-glue-candlepin-1.4.6-31.el6sat.noarch katello-glue-elasticsearch-1.4.6-31.el6sat.noarch katello-glue-pulp-1.4.6-31.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.17.beta.el6sat.noarch pulp-nodes-parent-2.3.0-0.17.beta.el6sat.noarch pulp-puppet-plugins-2.3.0-0.17.beta.el6sat.noarch pulp-rpm-plugins-2.3.0-0.17.beta.el6sat.noarch pulp-selinux-2.3.0-0.17.beta.el6sat.noarch pulp-server-2.3.0-0.17.beta.el6sat.noarch python-isodate-0.5.0-1.pulp.el6sat.noarch python-oauth2-1.5.170-3.pulp.el6sat.noarch python-pulp-bindings-2.3.0-0.17.beta.el6sat.noarch python-pulp-common-2.3.0-0.17.beta.el6sat.noarch python-pulp-puppet-common-2.3.0-0.17.beta.el6sat.noarch python-pulp-rpm-common-2.3.0-0.17.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.14-5.el6sat.noarch ruby193-rubygem-katello-foreman-engine-0.0.7-2.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.22-2.el6sat.noarch
Still fails for me. ERROR: update or delete on table "activation_keys" violates foreign key constraint "key_pools_activation_key_id_fk" on table "key_pools" DETAIL: Key (id)=(11) is still referenced from table "key_pools". (PGError) Satellite-6.0.2-RHEL-6-20131016.0/
below are the packages of that system apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.8.25-1.el6sam.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 * elasticsearch-0.19.9-8.el6sat.noarch * foreman-1.3.0-18.el6sat.noarch * foreman-compute-1.3.0-18.el6sat.noarch * foreman-libvirt-1.3.0-18.el6sat.noarch * foreman-postgresql-1.3.0-18.el6sat.noarch * foreman-proxy-1.3.0-3.el6sat.noarch * katello-1.4.6-39.el6sat.noarch * katello-all-1.4.6-39.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-39.el6sat.noarch * katello-configure-1.4.7-5.el6sat.noarch * katello-configure-foreman-1.4.7-5.el6sat.noarch * katello-configure-foreman-proxy-1.4.7-5.el6sat.noarch * katello-foreman-all-1.4.6-39.el6sat.noarch * katello-glue-candlepin-1.4.6-39.el6sat.noarch * katello-glue-elasticsearch-1.4.6-39.el6sat.noarch * katello-glue-pulp-1.4.6-39.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 * openldap-2.4.23-31.el6.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-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-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-ldap_fluff-0.2.2-2.el6sat.noarch * ruby193-rubygem-net-ldap-0.3.1-3.el6sat.noarch * ruby193-rubygem-runcible-1.0.7-1.el6sat.noarch * signo-0.0.22-2.el6sat.noarch * signo-katello-0.0.22-2.el6sat.noarch
actually needs to be MODIFIED since it isn't available in an official SNAP yet
Tested with Satellite-6.0.2-RHEL-6-20131021.0 and the activation key can now be deleted successfully.
This was verified and delivered with MDP2. Closing it out.
This was delivered and verified with MDP2. Closing the bug.