Project

General

Profile

Actions
Copy link

Bug #11447

closed

Fetching product or repo list using sync plans with large number of tasks takes minutes

Added by Justin Sherrill over 8 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Justin Sherrill
Category:
API
Target version:
Katello 2.3.1
Difficulty:
easy
Triaged:
Yes
Bugzilla link:
1253802
Pull request:
https://github.com/Katello/katello/pull/5435
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1253802
Description of problem:

Customer has 5 products enabled with: 46, 5, 2, 2 & 2 repositories in each one. All 5 products are in the same sync plan. There are also 141916 tasks in the ForemanTask::Task table and 549906 locks in the lock table.

Loading the products page takes about 10 minutes. Loading the repositories page for a product takes ~5 minutes

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

How reproducible:
Always

Steps to Reproduce:
1. Populate a satellite with the above stats
2. Visit the products list and the repo list for a product

Actual results:
takes minutes to load

Expected results:
Loads fairly quickly

Additional info:

Actions
Copy link
 #1

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/5435 added
  • Pull request deleted ()
Actions
Copy link
 #2

Updated by Justin Sherrill over 8 years ago

  • Assignee set to Justin Sherrill
  • translation missing: en.field_release set to 77
  • Difficulty set to easy
  • Triaged changed from No to Yes
Actions
Copy link
 #3

Updated by Justin Sherrill over 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF