Bug 2112400

Summary: Clients can't subscribe to or enable Red Hat repositories after renewing subscriptions
Product: Red Hat Satellite Reporter: Odilon Sousa <osousa>
Component: CandlepinAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED ERRATA QA Contact: Lai <ltran>
Severity: high Docs Contact:
Priority: high    
Version: 6.10.3CC: ahumbe, dhjoshi, JONATHAN.SATTELBERGER, jpasqual, nmoumoul, pbadguja, redakkan, satellite6-bugs, smajumda, wclark, wpinheir, zhunting
Target Milestone: 6.11.2Keywords: PrioBumpGSS, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: candlepin-4.1.14-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 2064979 Environment:
Last Closed: 2022-08-30 19:43:07 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Comment 2 Lai 2022-08-08 18:50:21 UTC
Steps to Retest:
1. Have a valid manifest imported to the Satellite. Enable and sync some Redhat repositories. Create some custom repositories. Create one or more content views and attach some repositories.
2. Go to Web UI -> Content ->  Subscriptions -> Manage Manifest -> click the "Subscription Allocation" link to go to the Customer Portal page.
3. In the Customer Portal, delete all subscriptions allocated to the manifest.
4. Then refresh the manifest using the Satellite Web UI.
5. Run grep for "Removing owner-content references for owner" on /var/log/candlepin/candlepin.log
6. Run su - postgres -c "psql candlepin -c \"select e.name, c.contenturl, c.vendor, c.label  from cp2_environment_content ec left join cp_environment e on e.id = ec.environment_id left join cp2_content c on c.uuid = content_uuid order by e.name, c.vendor, c.label;\""

Expected result:
5. Should return empty
6. Should return only the number of repos that was synced and added to cv

Actual:
5. Did return empty
6. Did return only the number of repos that was synced and added to cv

I also did manifest refresh a few times to ensure the error didn't occur anymore.  Everything seems to check out ok.

Verified on 6.11.2_01 with candlepin-selinux-4.1.14-1.el7sat.noarch on rhel7 and rhel8

Comment 7 errata-xmlrpc 2022-08-30 19:43:07 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 (Satellite 6.11.2 Async Bug Fix Update), 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-2022:6233