Bug 2164551

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.12
Product: Red Hat Satellite Reporter: Puja Singh <pujsingh>
Component: PulpAssignee: satellite6-bugs <satellite6-bugs>
Status: NEW --- QA Contact: Satellite QE Team <sat-qe-bz-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.12.0CC: ahumbe, dalley, dkliban, ggainey, rchan
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: UnusedFlags: dalley: needinfo? (pujsingh)
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 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:

Description Puja Singh 2023-01-25 18:03:44 UTC
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.12

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.

Comment 1 Brad Buckingham 2023-01-26 15:09:00 UTC
Can you paste the stack trace of the pulp error observed?

Comment 11 Daniel Alley 2023-08-01 01:00:53 UTC
Reducing priority / sev given the case is closed and we have no reproducer available.