Project

General

Profile

Bug #16010

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

Added by Andrew Kofink about 3 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Web UI
Target version:
Difficulty:
medium
Triaged:
Bugzilla link:
Team Backlog:
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

Related to Foreman - Feature #16646: Allow Foreman controllers to be extended to include fields from external pluginsClosed2016-09-21
Related to Katello - Bug #18586: Add action scopes to hosts API controller.Closed2017-02-21
Blocks Katello - Tracker #15825: Sprint 1 : Content-FocusedNew2016-07-24

Associated revisions

Revision 80ebe622 (diff)
Added by Andrew Kofink almost 3 years ago

Fixes #16010 - Include referenced objects in hosts

This results in a 23% total improvement in rendering time between the
model and view layers for HostsController#index in Katello.

History

#1 Updated by Andrew Kofink about 3 years ago

#2 Updated by The Foreman Bot about 3 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

#3 Updated by Justin Sherrill almost 3 years ago

  • Legacy Backlogs Release (now unused) set to 114
  • Difficulty set to medium

#4 Updated by Andrew Kofink almost 3 years ago

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

#5 Updated by The Foreman Bot almost 3 years ago

  • Legacy Backlogs Release (now unused) deleted (114)

#6 Updated by Justin Sherrill almost 3 years ago

  • Legacy Backlogs Release (now unused) set to 188

#7 Updated by Andrew Kofink almost 3 years ago

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

#8 Updated by Andrew Kofink over 2 years ago

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

Also available in: Atom PDF