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 9 years ago. Updated over 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

Also available in: Atom PDF