Bug 1196742
| Summary: | Loading Activation keys list slow | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Peter Vreman <peter.vreman> |
| Component: | Content Management | Assignee: | Walden Raines <walden> |
| Status: | CLOSED ERRATA | QA Contact: | Tazim Kolhar <tkolhar> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.8 | CC: | bbuckingham, cwelton, jmontleo, tkolhar |
| Target Milestone: | Unspecified | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://projects.theforeman.org/issues/9580 | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-08-12 05:27:58 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: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1122832 | ||
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release. Created redmine issue http://projects.theforeman.org/issues/9580 from this bug After applying the patch from the PR and including also the changes to show.json.rabl from #7813 and #7885 the API and WebUI is still slow, although the response size has decreased by factor 10.
# time curl -K /opt/hoici/etc/sat6/curl-hoici.conf "-HContent-Type: application/json" "-d{\"per_page\":9999}" -XGET https://localhost/katello/api/v2/organizations/4/activation_keys > act.json
real 0m17.419s
user 0m0.180s
sys 0m0.046s
# ls -l act.json
-rw-r--r-- 1 root root 48178 Mar 2 12:44 act.json
Moving to POST since upstream bug http://projects.theforeman.org/issues/9580 has been closed ------------- Walden Raines Applied in changeset commit:katello|2f7e0e560b95b6c6082a35a5f6b5e9ab1230d516. VERIFIED:
# rpm -qa | grep foreman
rubygem-hammer_cli_foreman_tasks-0.0.3.3-1.el6_6sat.noarch
foreman-proxy-1.7.2.3-1.el6_6sat.noarch
foreman-ovirt-1.7.2.10-1.el6_6sat.noarch
ruby193-rubygem-foreman-tasks-0.6.12.1-1.el6_6sat.noarch
rubygem-hammer_cli_foreman_bootdisk-0.1.2.5-1.el6_6sat.noarch
ruby193-rubygem-foreman_abrt-0.0.5-2.el6_6sat.noarch
foreman-compute-1.7.2.10-1.el6_6sat.noarch
foreman-libvirt-1.7.2.10-1.el6_6sat.noarch
ruby193-rubygem-foreman_discovery-2.0.0.6-1.el6_6sat.noarch
rubygem-hammer_cli_foreman-0.1.4.6-1.el6_6sat.noarch
foreman-selinux-1.7.2.8-1.el6_6sat.noarch
foreman-gce-1.7.2.10-1.el6_6sat.noarch
ruby193-rubygem-foreman_docker-1.2.0.3-1.el6_6sat.noarch
ruby193-rubygem-foreman-redhat_access-0.0.9-1.el6_6sat.noarch
qe-sat6-rhel66.usersys.redhat.com-foreman-client-1.0-1.noarch
qe-sat6-rhel66.usersys.redhat.com-foreman-proxy-client-1.0-1.noarch
foreman-debug-1.7.2.10-1.el6_6sat.noarch
foreman-vmware-1.7.2.10-1.el6_6sat.noarch
ruby193-rubygem-foreman_bootdisk-4.0.2.8-1.el6_6sat.noarch
qe-sat6-rhel66.usersys.redhat.com-foreman-proxy-1.0-2.noarch
foreman-1.7.2.10-1.el6_6sat.noarch
ruby193-rubygem-foreman_hooks-0.3.7-2.el6_6sat.noarch
rubygem-hammer_cli_foreman_discovery-0.0.1.2-1.el6_6sat.noarch
ruby193-rubygem-foreman_gutterball-0.0.1.9-1.el6_6sat.noarch
foreman-postgresql-1.7.2.10-1.el6_6sat.noarch
time curl -k -K /opt/hoici/etc/sat6/curl-hoici.conf "-HContent-Type: application/json" "-d{\"per_page\":9999}" -XGET https://qe-sat6-rhel66.usersys.redhat.com/katello/api/v2/organizations/4/activation_keys > act.json
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 58 0 58 0 17 351 102 --:--:-- --:--:-- --:--:-- 891
real 0m0.179s
user 0m0.055s
sys 0m0.073s
This bug is slated to be released with Satellite 6.1. 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/RHSA-2015:1592 |
Description of problem: The Activion keys list is slow. It contains also a lot of not relevant data for the Katello users. E.g. the fields productAttributes and providedProducts are 33% of the data returned: # time curl -K /opt/hoici/etc/sat6/curl-hoici.conf "-HContent-Type: application/json" "-d{\"per_page\":9999}" -XGET https://localhost/katello/api/v2/organizations/4/activation_keys > act.json real 0m17.244s user 0m0.125s sys 0m0.041s # ls -l act.json -rw-r--r-- 1 root root 484619 Feb 26 16:06 act.json # hoi-json act.json --get ALL | wc -l 14412 # hoi-json act.json --get ALL | egrep -v '(productAttributes|providedProducts)' | wc -l 5786 Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Create 50 Activation keys 2. List activation keys 3. Actual results: Slow and big response in 20+ seconds Expected results: Result in 3 seconds and small response body with relevant data Additional info: Similiar to the BZ1177609 and BZ1161636