Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1161636 - Content View Versions page takes a long time to list
Content View Versions page takes a long time to list
Status: CLOSED ERRATA
Product: Red Hat Satellite 6
Classification: Red Hat
Component: API (Show other bugs)
6.0.8
Unspecified Unspecified
unspecified Severity high (vote)
: Unspecified
: Unused
Assigned To: Justin Sherrill
Kedar Bidarkar
http://projects.theforeman.org/issues...
: Triaged
Depends On:
Blocks: 1122832 1167417
  Show dependency treegraph
 
Reported: 2014-11-07 09:29 EST by Justin Sherrill
Modified: 2017-02-23 15:49 EST (History)
8 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1167417 (view as bug list)
Environment:
Last Closed: 2015-02-20 13:32:10 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2015:0247 normal SHIPPED_LIVE Red Hat Satellite 6 server bug fix update 2015-02-20 18:30:44 EST

  None (edit)
Description Justin Sherrill 2014-11-07 09:29:34 EST
Description of problem:

Having a lot of content view versions of a single content view (~55), each with ~4 repositories totaly 25,000 packages and 50 puppet modules causes the content view versions list to take 2-3 minutes to load


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

How reproducible:
Always

Steps to Reproduce:
1.  Load up a content view with 55 versions of the amount of data mentioned above
2.  Navigate to Content Views > MyView  and wait for the versions list to show


Actual results:
takes 2 -3 minutes

Expected results:
takes ~10 seconds or less


Additional info:
Comment 3 Justin Sherrill 2014-11-21 10:20:55 EST
Reproduced by adding ~100 puppet modules to a content view and published ~30 times.
Comment 4 Justin Sherrill 2014-11-24 11:51:38 EST
Created redmine issue http://projects.theforeman.org/issues/8491 from this bug
Comment 5 Bryan Kearney 2014-12-09 10:04:51 EST
Moving to POST since upstream bug http://projects.theforeman.org/issues/8491 has been closed
-------------
Justin Sherrill
Applied in changeset commit:katello|1ced1c519b6dee549634d81536a6558b66dd88f7.
Comment 9 Bryan Kearney 2015-02-05 16:04:46 EST
Moving to POST since upstream bug http://projects.theforeman.org/issues/8491 has been closed
-------------
Justin Sherrill
Applied in changeset commit:katello|1ced1c519b6dee549634d81536a6558b66dd88f7.
Comment 12 Kedar Bidarkar 2015-02-12 09:10:38 EST
Added 8000 packages and 18 puppet-modules to a Content-View and published this content-view 33 times.

The page now opens up in ~15 secs. 

VERIFIED With Sat6.0.8 build.
Comment 13 jaudet 2015-02-12 13:43:57 EST
This bug is not 100% fixed 

> Expected results:
> takes ~10 seconds or less

However, the results are significantly better than the 2-3 minute wait described in the bug. I double-checked kbidarka's results and did some additional tests of my own. Here's the results:

* ~18 seconds: Content view with 8090 packages and 33 versions. Installed on RHEL 6.6
* ~30-45 seconds: Content view with 5639 packages (250 errata) and 40 versions. Installed on RHEL 7.0.

Some of those differences in timing may arise from differences in underlying hardware, too.

Related to: https://bugzilla.redhat.com/show_bug.cgi?id=1192162
Comment 15 errata-xmlrpc 2015-02-20 13:32:10 EST
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2015:0247

Note You need to log in before you can comment on or make changes to this bug.