Bug 1489133 - host's tracer list fails with error
Summary: host's tracer list fails with error
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Content Management
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: Unspecified
Assignee: Justin Sherrill
QA Contact: Nikhil Kathole
URL:
Whiteboard:
: 1489131 1489132 1489424 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-09-06 18:26 UTC by Brad Buckingham
Modified: 2019-09-26 15:38 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-02-21 17:00:29 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
traces list under content host (601.12 KB, application/octet-stream)
2017-10-24 07:17 UTC, Nikhil Kathole
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 20703 0 None None None 2017-09-08 20:28:28 UTC
Foreman Issue Tracker 21251 0 None None None 2017-10-09 16:08:39 UTC

Description Brad Buckingham 2017-09-06 18:26:31 UTC
Trying to access a host's tracer list results in error:

<pre>
2017-09-01 17:11:28 eb37fa5b [app] [E] NoMethodError: undefined method `order' for #<Array:0x007fc3743750c0>
 | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.4.4/app/controllers/katello/api/v2/api_controller.rb:73:in `scoped_search'
 | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.4.4/app/controllers/katello/api/v2/host_tracer_controller.rb:15:in `index'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/actionpack-4.2.6/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/actionpack-4.2.6/lib/abstract_controller/base.rb:198:in `process_action'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/actionpack-4.2.6/lib/action_controller/metal/rendering.rb:10:in `process_action'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/actionpack-4.2.6/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:117:in `call'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:505:in `call'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:498:in `block (2 levels) in around'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:313:in `block (2 levels) in halting'
 | /usr/share/foreman/app/controllers/api/v2/base_controller.rb:152:in `disable_json_root'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:432:in `block in make_lambda'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:312:in `block in halting'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:497:in `block in around'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:505:in `call'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:498:in `block (2 levels) in around'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:313:in `block (2 levels) in halting'
 | /usr/share/foreman/app/controllers/concerns/application_shared.rb:15:in `set_timezone'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:432:in `block in make_lambda'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:312:in `block in halting'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:497:in `block in 
</pre>

Comment 1 Brad Buckingham 2017-09-06 18:26:35 UTC
Created from redmine issue http://projects.theforeman.org/issues/20831

Comment 2 Brad Buckingham 2017-09-06 18:26:39 UTC
Upstream bug assigned to jsherril

Comment 3 Brad Buckingham 2017-09-06 18:28:48 UTC
*** Bug 1489132 has been marked as a duplicate of this bug. ***

Comment 4 Brad Buckingham 2017-09-06 18:28:58 UTC
*** Bug 1489131 has been marked as a duplicate of this bug. ***

Comment 6 Satellite Program 2017-09-14 20:01:39 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20703 has been resolved.

Comment 7 Brad Buckingham 2017-09-20 15:35:22 UTC
*** Bug 1489424 has been marked as a duplicate of this bug. ***

Comment 8 Nikhil Kathole 2017-10-09 10:45:45 UTC
FailedQA

Version Tested:
Satellite-6.3 Snap 19

steps:

1. Created content host
2. Navigated to Hosts -> Content Hosts 
3. Click on Tasks tab
4. Click on Traces tab

It throws error in production.log as (see attachment)

ActiveRecord::StatementInvalid: PG::Error: ERROR:  column katello_host_tracers.updated does not ex
ist
 | LINE 1: ...E "katello_host_tracers"."host_id" = $1  ORDER BY "katello_h...
 |                                                              ^
 | : SELECT  "katello_host_tracers".* FROM "katello_host_tracers" WHERE "katello_host_tracers"."host_id" = $1  ORDER BY "katello_host_tra
cers"."updated" DESC, katello_host_tracers.id DESC LIMIT 20 OFFSET 0


Additional info : If we directly navigated to Traces tab, it works properly.But navigating from another tab such as tasks, it throws 500 internal server error.

Comment 10 Nikhil Kathole 2017-10-24 07:13:47 UTC
VERIFIED

Version Tested:
Satellite-6.3 Snap 21

steps:

1. Created content host
2. Navigated to Hosts -> Content Hosts 
3. Click on Traces tab

Also tried scenario as per comment #8, found traces tab under content host working.

Comment 11 Nikhil Kathole 2017-10-24 07:17:56 UTC
Created attachment 1342544 [details]
traces list under content host

Comment 12 Bryan Kearney 2018-02-21 17:00:29 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, 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-2018:0336


Note You need to log in before you can comment on or make changes to this bug.