Project

General

Profile

Actions

Bug #16010

closed

"Error: Request Timeout" from hammer when asked to show >400 content hosts

Added by Andrew Kofink over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Web UI
Target version:
Difficulty:
medium
Triaged:
Fixed in Releases:
Found in Releases:

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
--------


Related issues 3 (1 open2 closed)

Related to Foreman - Feature #16646: Allow Foreman controllers to be extended to include fields from external pluginsClosedShimon Shtein09/21/2016Actions
Related to Katello - Bug #18586: Add action scopes to hosts API controller.ClosedShimon Shtein02/21/2017Actions
Blocks Katello - Tracker #15825: Sprint 1 : Content-FocusedNewBrad Buckingham07/24/2016

Actions
Actions #1

Updated by Andrew Kofink over 7 years ago

Actions #2

Updated by The Foreman Bot over 7 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
Actions #3

Updated by Justin Sherrill over 7 years ago

  • translation missing: en.field_release set to 114
  • Difficulty set to medium
Actions #4

Updated by Andrew Kofink over 7 years ago

  • Related to Feature #16646: Allow Foreman controllers to be extended to include fields from external plugins added
Actions #5

Updated by The Foreman Bot over 7 years ago

  • translation missing: en.field_release deleted (114)
Actions #6

Updated by Justin Sherrill over 7 years ago

  • translation missing: en.field_release set to 188
Actions #7

Updated by Andrew Kofink over 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #8

Updated by Andrew Kofink about 7 years ago

  • Related to Bug #18586: Add action scopes to hosts API controller. added
Actions

Also available in: Atom PDF