Project

General

Custom queries

Profile

Actions
Copy link

Bug #37058

closed

Cleanup orphans task generates inefficient queries consuming resources and taking long time to run

Added by Joniel Pasqualetto over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Katello 4.12.0
Difficulty:
Triaged:
Yes
Bugzilla link:
2258876
Pull request:
https://github.com/Katello/katello/pull/10851
Fixed in Releases:
Katello 4.12.0
Found in Releases:
Red Hat JIRA:

Description

Description of problem:

katello:delete_orphaned_content triggers queries on the DB to identify what are the orphan units to be removed. However, such query is not efficient on systems where table katello_repository_rpms is big.

Query is slow, consumes a lot of cpu and the task may take long time to run.

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

How reproducible:

Always, on big databases.

Steps to Reproduce:

Conditions to reproduce it simply require big tables katello_repository_rpms and katello_rpms

Actual results:

Task works, but may take long time.

Expected results:

Faster execution.

Additional info:

#2

Updated by The Foreman Bot over 1 year ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/10851 added
#3

Updated by The Foreman Bot over 1 year ago

  • Fixed in Releases Katello 4.12.0 added
#4

Updated by Joniel Pasqualetto over 1 year ago

  • Status changed from Ready For Testing to Closed
#5

Updated by Partha Aji over 1 year ago

  • Target version set to Katello 4.12.0
  • Triaged changed from No to Yes
Actions
Copy link

Also available in: Atom PDF