Description of problem:

While deleting the repository from Satellite 6.14.1
~~~~~~~~~~~
Katello::Errors::CandlepinError: Unable to find content with the ID "XXXX".
~~~~~~~~~~~

A similar BZ 2032040 was reported earlier and it was fixed in 6.13 but it seems in 6.14 also this Bug exists.

Actual results:

1. The content is missing in the Candlepin DB:

1. su - postgres -c "psql candlepin -c \"select uuid, content_id, contentUrl, label, type, vendor from cp2_content where content_id = 'XXXX'\""

uuid | content_id | contenturl | label | type | vendor
----------------------------------+-------
(0 rows)

2. But it's still referenced by some root repositories:

1. # su - postgres -c "psql foreman -c \"select * from katello_root_repositories where content_id = '9134'\""
   id | name | created_at | updated_at | major | minor | gpg_key_id | content_id | arch

   label

   url

   unprotected

   content_type

   product _id

   checksum_type

   pulp_scratchpad_checksum_type

   docker_upstream_name

   download_policy

   verify_ssl_on_sync

   upstream_username

   upstream_password

   deb_releases

   deb_com ponents

   deb_architectures

   ssl_ca_cert_id

   ssl_client_cert_id

   ssl_client_key_id

   ignorable_content

   include_tags

   description

   ansible_collection_requirements

   htt p_proxy_policy

   http_proxy_id

   download_concurrency

   os_versions

   ansible_collection_auth_url

   ansible_collection_auth_token

   upstream_authentication_token

   mirroring_ policy

   retain_package_versions_count

   generic_remote_options

   exclude_tags

   metadata_expire -------------------------------------------------------------------------------------------------------------------------------------------+----

YYY | Red Hat OpenShift Container Platform 4.3 for RHEL 8 x86_64 RPMs | 2020-03-05 07:57:02.695964 | 2023-12-14 12:26:14.188373 | | | | XXXX | noarc
h | Red_Hat_OpenShift_Container_Platform_4_3_for_RHEL_8_x86_64_RPMs | https://cdn.redhat.com/content/dist/layered/rhel8/x86_64/rhocp/4.3/os | f | yum |
30 | | | | on_demand | t | | | |

(1 row)

Expected results:

It should delete the repository without any error.

QE Tracker for https://issues.redhat.com/browse/SAT-22966
Bugzilla: https://bugzilla.redhat.com/show_bug.cgi?id=2261948