Bug 2169322

Summary: Reclaim space for repository fails with Cannot delete some instances of model 'Artifact' because they are referenced through protected foreign keys: 'ContentArtifact.artifact'."
Product: Red Hat Satellite Reporter: Manu Sunil <msunil>
Component: PulpAssignee: satellite6-bugs <satellite6-bugs>
Status: POST --- QA Contact: Satellite QE Team <sat-qe-bz-list>
Severity: high Docs Contact:
Priority: high    
Version: 6.11.4CC: ahumbe, arsingh, dalley, dkliban, ggainey, ipanova, ramsingh, rchan, saydas
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: pulpcore-3.28.6, pulpcore-3.23.11, pulpcore-3.22.10, pulpcore-3.21.13, pulpcore-3.18.23 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 Manu Sunil 2023-02-13 10:11:14 UTC 
Description of problem:

- Reclaim space for repository fails with the following error.

  ~~~
  Task paused with error: "("Cannot delete some instances of model 'Artifact' because they are referenced through protected foreign keys: 'ContentArtifact.artifact'.", {<ContentArtifact: pk=452959ad-c045-4e85-bf9f-6651ba37f57d>})"
  ~~~

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

  tfm-pulpcore-python3-pulpcore-3.16.14-1.el7pc.noarch
  tfm-pulpcore-python3-pulp-rpm-3.17.10-2.el7pc.noarch    
  satellite-6.11.4.1-1.el7sat.noarch

Actual results:


- The reclaim space task on Satellite for a repository fails with the following message

  ~~~
  023-02-10T10:36:24 [E|bac|69a59329] ("Cannot delete some instances of model 'Artifact' because they are referenced through protected foreign keys: 'ContentArtifact.artifact'.",
 {<ContentArtifact: pk=452959ad-c045-4e85-bf9f-6651ba37f57d>}) (Katello::Errors::Pulp3Error)  
  ~~~

Expected results:

- Reclaim space should complete without any errors.
Comment 7 Robin Chan 2023-07-28 18:05:26 UTC 
The Pulp upstream bug status is at closed. Updating the external tracker on this bug.
Comment 8 Robin Chan 2023-07-28 18:05:29 UTC 
All upstream Pulp bugs are at MODIFIED+. Moving this bug to POST.