Red Hat Satellite generates inefficient queries consuming resources and taking long time to run when trying to cleanup orphans

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content