Bug 2112368

Summary:	Remove orphans task going to the paused state with error "Cannot delete some instances of model 'Repository' because they are referenced through protected foreign keys" on Red Hat Satellite 6.11
Product:	Red Hat Satellite	Reporter:	Odilon Sousa <osousa>
Component:	Pulp	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	CLOSED ERRATA	QA Contact:	Lai <ltran>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.11.0	CC:	ahumbe, dalley, dkliban, ggainey, JONATHAN.SATTELBERGER, osousa, rchan, saydas
Target Milestone:	6.11.2	Keywords:	Regression, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	tfm-pulpcore-python-pulp-rpm-3.17.7-2.el7pc	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	2109254	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:

Description Odilon Sousa 2022-07-29 14:05:55 UTC

+++ This bug was initially created as a clone of Bug #2109254 +++

Description of problem:

The task 'Actions::Katello::OrphanCleanup::RemoveOrphans' is going to the paused state instead of finishing successfully.


Version-Release number of selected component (if applicable):
Satellite 6.11

How reproducible:
100%

Steps to Reproduce:
1. Enable and sync repositories on the Satellite server.
2. Sync Library env with Capsule server.
2. Remove some of the synced repositories.
3. Run orphan cleanup command foreman-rake katello:delete_orphaned_content RAILS_ENV=production

Actual results:
The task goes to the paused state with error message:

Katello::Errors::Pulp3Error

("Cannot delete some instances of model 'Repository' because they are referenced through protected foreign keys: 'Addon.repository', 'RpmRepository.repository_ptr'.", {})

Expected results:
The task should complete successfully without any issues.

Additional info:
https://community.theforeman.org/t/katello-4-3-0-rake-katello-delete-orphaned-content-error/27898

--- Additional comment from  on 2022-07-20T18:58:25Z 


The issue seems to have been addressed in pulp_rpm  via:

Katello 4.3.0 rake katello:delete_orphaned_content fails with error · Issue #2459 · pulp/pulp_rpm
https://github.com/pulp/pulp_rpm/issues/2459

Fix a bug preventing orphan cleanup for some subrepos by dralley · Pull Request #2619 · pulp/pulp_rpm
https://github.com/pulp/pulp_rpm/pull/2619


Going through the PR, It seems like the issue is supposed to be fixed in  pulp_rpm 3.17.7 and 3.14.16


Looping @dalley here ..

Comment 4 Lai 2022-08-10 20:41:43 UTC

Steps to retest:
1. Enable and sync repositories on the Satellite server.
2. Sync Library env with Capsule server.
2. Remove some of the synced repositories.
3. Run orphan cleanup command foreman-rake katello:delete_orphaned_content RAILS_ENV=production

Expected:
Orphan cleanup should finish successfully

Actual:
Orphan cleanup finishes successfully

Verified on 6.11.2 snap 1 with python38-pulp-rpm-3.17.7-2.el8pc.noarch

Comment 9 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