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: CLOSED ERRATA QA Contact: addubey
Severity: high Docs Contact:
Priority: high    
Version: 6.11.4CC: addubey, ahumbe, arsingh, dalley, dkliban, ggainey, ipanova, jbhatia, osousa, ramsingh, rchan, saydas, vijsingh, wclark
Target Milestone: 6.14.0Keywords: 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:
: 2239041 (view as bug list) Environment:
Last Closed: 2023-11-08 14:18:30 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:
Attachments:
Description Flags
Hotfix RPM for Satellite/Capsule 6.11.5 on EL8
none
Hotfix RPM for Satellite/Capsule 6.11.5 on EL7 none

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.

Comment 15 wclark 2023-09-07 20:53:00 UTC
Created attachment 1987644 [details]
Hotfix RPM for Satellite/Capsule 6.11.5 on EL8

A hotfix RPM is now available for Satellite/Capsule 6.11.5 on RHEL 8.

Installation instructions:

1. Create a backup or snapshot of the Satellite or Capsule server.

2. Download the hotfix RPM python38-pulpcore-3.16.15-2.HOTFIXRHBZ2169322.el8pc.noarch.rpm from the attachment and copy it to Satellite or Capsule server

3. # dnf install ./python38-pulpcore-3.16.15-2.HOTFIXRHBZ2169322.el8pc.noarch.rpm --disableplugin=foreman-protector

4. # satellite-maintain service restart

Comment 16 wclark 2023-09-07 20:55:12 UTC
Created attachment 1987645 [details]
Hotfix RPM for Satellite/Capsule 6.11.5 on EL7

A hotfix RPM is now available for Satellite/Capsule 6.11.5 on RHEL 7.

Installation instructions:

1. Create a backup or snapshot of the Satellite or Capsule server.

2. Download the hotfix RPM tfm-pulpcore-python3-pulpcore-3.16.15-2.HOTFIXRHBZ2169322.el7pc.noarch.rpm from the attachment and copy it to Satellite or Capsule server

3. # yum install ./tfm-pulpcore-python3-pulpcore-3.16.15-2.HOTFIXRHBZ2169322.el7pc.noarch.rpm --disableplugin=foreman-protector

4. # satellite-maintain service restart

Comment 22 errata-xmlrpc 2023-11-08 14:18:30 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 (Important: Satellite 6.14 security and 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/RHSA-2023:6818