Bug 1852683

Summary: Activation key page loading is very slow
Product: Red Hat Satellite Reporter: Ranjan Kumar <rankumar>
Component: Activation KeysAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED ERRATA QA Contact: Cole Higgins <chiggins>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.5.0Keywords: Triaged
Target Milestone: 6.9.0   
Target Release: Unused   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-04-21 13:15:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Ranjan Kumar 2020-07-01 05:22:34 UTC 
Description of problem: Listing activation key is slow. Took 3.5m to list 10 activation keys.

#hammer activation-key list --organization RH
---|---------------------------------------|------------------|-----------------------|----------------------
ID | NAME                                  | HOST LIMIT       | LIFECYCLE ENVIRONMENT | CONTENT VIEW         
---|---------------------------------------|------------------|-----------------------|----------------------
62 | KEY-1                                 | 0 of Unlimited   | DEV                   | CV1             
52 | KEY-2                                 | 7 of Unlimited   | DEV                   | CV1       
47 | KEY-3                                 | 8 of Unlimited   | DEV                   | CV2        
27 | KEY-4                                 | 11 of Unlimited  | DEV                   | CV1             
81 | KEY-5                                 | 0 of Unlimited   | DEV                   | CV2     
22 | KEY-6                                 | 0 of Unlimited   | DEV                   | CV1             
82 | KEY-7                                 | 0 of Unlimited   | DEV                   | CV2     
17 | KEY-8                                 | 16 of Unlimited  | DEV                   | CV1             
83 | KEY-9                                 | 0 of Unlimited   | DEV                   | CV2     
12 | KEY-10                                | 70 of Unlimited  | DEV                   | CV1             
---|---------------------------------------|------------------|-----------------------|----------------------
Page 1 of 5 (use --page and --per-page for navigation).

real	3m0.308s
user	00m.917s
sys	0m0.478s

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


How reproducible: Always


Steps to Reproduce:
1. Create 100+ activation and make sure every AK has few product contents.
2. Now try to list AK using hammer or UI


Actual results: Taking a long time to list activation keys


Expected results: AK page should load faster


Additional info:
Comment 4 Ranjan Kumar 2020-07-13 15:23:49 UTC 
Yes, Activation key listing worked fine after applying PR 30270 in Satellite 6.5.
Comment 5 Bryan Kearney 2020-07-17 20:01:48 UTC 
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/30270 has been resolved.
Comment 11 errata-xmlrpc 2021-04-21 13:15:01 UTC 
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 (Moderate: Satellite 6.9 Release), 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/RHSA-2021:1313