Bug #16010
closed"Error: Request Timeout" from hammer when asked to show >400 content hosts
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1297683
Description of problem:
time hammer content-host list --organization <orgname>
Error: Request Timeout
real 2m2.340s
user 0m1.179s
sys 0m0.220s
Version-Release number of selected component (if applicable):
satellite 6.1.4
How reproducible:
unknown
(in this environment here with >500 content hosts the issue always exists)
Steps to Reproduce:
1. register more than 500 content hosts
2. hammer content-host list --organization <orgname>
3.
Actual results:
Error: Request Timeout
Expected results:
<result should be displayed>
Additional info:
- using ":request_timeout: 1", the result appears enforcing paging, the result also is displayed. I.e. "hammer content-host list --organization <orgname> --per-page 300". Using "--per-page 500", the timeout is hit again.
- The time for execution suggests that the code contains a bug. From what I understand, this should be a simple database query. Instead it takes a very long time:
--------
[root@sat6 ~]# time hammer content-host list --organization orgname
Error: Request Timeout
real 2m2.340s
user 0m1.179s
sys 0m0.220s
[root@sat6 ~]# time hammer content-host list --organization orgname --per-page 300
...
real 0m49.191s
user 0m5.763s
sys 0m0.240s
[root@sat6 ~]# time hammer content-host list --organization orgname --per-page 400
...
real 1m8.274s
user 0m9.259s
sys 0m0.250s
[root@sat6 ~]# time hammer content-host list --organization orgname --per-page 450
Error: Request Timeout
real 2m1.703s
user 0m1.100s
sys 0m0.105s
[root@sat6 ~]# time hammer content-host list --organization orgname --per-page 500
Error: Request Timeout
real 2m1.365s
user 0m1.040s
sys 0m0.087s
[root@sat6 ~]# time hammer content-host list --organization orgname --search "be*" (this should yield 470 machines)
Error: Request Timeout
real 2m1.184s
user 0m1.021s
sys 0m0.108s
[root@sat6 ~]# time hammer content-host list --organization orgname --search "a*" (this should yield about 25 machines)
...
real 0m4.573s
user 0m1.168s
sys 0m0.137s
--------
Updated by Andrew Kofink about 8 years ago
- Blocks Tracker #15825: Sprint 1 : Content-Focused added
Updated by The Foreman Bot about 8 years ago
- Status changed from New to Ready For Testing
- Assignee set to Andrew Kofink
- Pull request https://github.com/Katello/katello/pull/6236 added
Updated by Justin Sherrill almost 8 years ago
- Translation missing: en.field_release set to 114
- Difficulty set to medium
Updated by Andrew Kofink almost 8 years ago
- Related to Feature #16646: Allow Foreman controllers to be extended to include fields from external plugins added
Updated by The Foreman Bot almost 8 years ago
- Translation missing: en.field_release deleted (
114)
Updated by Justin Sherrill almost 8 years ago
- Translation missing: en.field_release set to 188
Updated by Andrew Kofink almost 8 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|80ebe622e8820a2aa8f9db0c78a90b9369971e6c.
Updated by Andrew Kofink over 7 years ago
- Related to Bug #18586: Add action scopes to hosts API controller. added