Red Hat Satellite generates inefficient queries consuming resources and taking long time to run when trying to cleanup orphans
Issue
-
The task
Actions::Katello::OrphanCleanup::RemoveOrphanedContentUnits
runs automaticaly and is located in/etc/cron.d/katello
. -
The script for initiating the removal of orphaned content is scheduled in the crontab:
00 22 * * 0 root foreman-rake katello:delete_orphaned_content RAILS_ENV=production >/dev/null 2>&1
-
This script, which deletes the orphaned contents, generates inefficient queries, consumes resources, and takes a long time to run.
Environment
Red Hat Satellite 6.14.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.