Bug 1140653

Summary:	Deleting a foreman host doesn't clean up subscription usage
Product:	Red Hat Satellite	Reporter:	Stephen Benjamin <stbenjam>
Component:	Subscription Management	Assignee:	Partha Aji <paji>
Status:	CLOSED ERRATA	QA Contact:	Kedar Bidarkar <kbidarka>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	6.0.4	CC:	achan, bbuckingham, jmontleo, jswensso, kbidarka, mmccune, sthirugn
Target Milestone:	Unspecified	Keywords:	Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
URL:	http://projects.theforeman.org/issues/7446
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	Previously, when deleting a host through Foreman, the content host was deleted correctly but the subscription remained in use. The content_host_active record would be deleted however the backend candlepin or pulp consumer information was not. In the current release, this has been remedied and subscriptions are made available again once a host is deleted.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-11-13 22:29:11 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:	1139277

Description Stephen Benjamin 2014-09-11 12:44:54 UTC

Description of problem:
When deleting a host through Foreman, the content host is deleted correctly but the subscription remains in use.


Version-Release number of selected component (if applicable):
6.0.4 GA (and Katello nightly)

How reproducible:
Always

Steps to Reproduce:
1. Provision a Foreman host that will have content
2. Look at 'Red Hat Subscriptions' page counts, and verify some subscriptions are in use
3. Delete the host through "All Hosts" UI
4. Confirm 'Host' and 'Content Host' are removed
5. Reload 'Red Hat Subscriptions' page

Actual results:
Subscription counts aren't updated (even after running katello:reindex)

Expected results:
Subscriptions are correctly made available

Additional info:

Comment 2 Partha Aji 2014-09-15 23:05:33 UTC

Created redmine issue http://projects.theforeman.org/issues/7446 from this bug

Comment 3 Bryan Kearney 2014-09-19 16:05:05 UTC

Moving to POST since upstream bug http://projects.theforeman.org/issues/7446 has been closed
-------------
Partha Aji
Applied in changeset commit:katello|880dc9eaac24e513332abd42a287d7fe6790777e.

Comment 6 Kedar Bidarkar 2014-11-06 11:56:30 UTC

followed the steps to reproduce the bug, as given in the initial bug report.

Moving it to VERIFIED State. 

Build : Satellite-6.0.4-RHEL-6-20141029.5


Installed Packages

    candlepin-0.9.23.1-1.el7.noarch
    candlepin-common-1.0.1-1.el7.noarch
    candlepin-guice-3.0-2_redhat_1.el7.noarch
    candlepin-scl-1-5.el7.noarch
    candlepin-scl-quartz-2.1.5-6.el7.noarch
    candlepin-scl-rhino-1.7R3-3.el7.noarch
    candlepin-scl-runtime-1-5.el7.noarch
    candlepin-selinux-0.9.23.1-1.el7.noarch
    candlepin-tomcat-0.9.23.1-1.el7.noarch
    elasticsearch-0.90.10-6.el7sat.noarch
    katello-1.5.0-30.el7sat.noarch
    katello-certs-tools-1.5.6-1.el7sat.noarch
    katello-default-ca-1.0-1.noarch
    katello-installer-0.0.64-1.el7sat.noarch
    katello-server-ca-1.0-1.noarch
    pulp-katello-0.3-4.el7sat.noarch
    pulp-nodes-common-2.4.3-0.1.beta.el7sat.noarch
    pulp-nodes-parent-2.4.3-0.1.beta.el7sat.noarch
    pulp-puppet-plugins-2.4.3-1.el7sat.noarch
    pulp-puppet-tools-2.4.3-1.el7sat.noarch
    pulp-rpm-plugins-2.4.3-1.el7sat.noarch
    pulp-selinux-2.4.3-1.el7sat.noarch
    pulp-server-2.4.3-1.el7sat.noarch
    python-gofer-qpid-1.3.0-1.el7sat.noarch
    python-isodate-0.5.0-1.pulp.el7sat.noarch
    python-kombu-3.0.15-12.pulp.el7sat.noarch
    python-pulp-bindings-2.4.3-1.el7sat.noarch
    python-pulp-common-2.4.3-1.el7sat.noarch
    python-pulp-puppet-common-2.4.3-1.el7sat.noarch
    python-pulp-rpm-common-2.4.3-1.el7sat.noarch
    python-qpid-0.22-15.el7.noarch
    python-qpid-qmf-0.22-37.el7.x86_64
    qpid-cpp-client-0.22-42.el7.x86_64
    qpid-cpp-server-0.22-42.el7.x86_64
    qpid-cpp-server-linearstore-0.22-42.el7.x86_64
    qpid-java-client-0.22-7.el7.noarch
    qpid-java-common-0.22-7.el7.noarch
    qpid-proton-c-0.7-2.el7.x86_64
    qpid-qmf-0.22-37.el7.x86_64
    qpid-tools-0.22-13.el7.noarch
    ruby193-rubygem-katello-1.5.0-92.el7sat.noarch
    rubygem-hammer_cli_katello-0.0.4-14.el7sat.noarch
    rubygem-smart_proxy_pulp-1.0.1-1.1.el7sat.noarch

Comment 8 errata-xmlrpc 2014-11-13 22:29:11 UTC

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.

https://access.redhat.com/errata/RHBA-2014:1857

Comment 9 Johan Swensson 2014-11-26 15:31:50 UTC

*** Bug 1144619 has been marked as a duplicate of this bug. ***