Bug 1489133

Summary: host's tracer list fails with error
Product: Red Hat Satellite Reporter: Brad Buckingham <bbuckingham>
Component: Content ManagementAssignee: Justin Sherrill <jsherril>
Status: CLOSED ERRATA QA Contact: Nikhil Kathole <nkathole>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: ehelms, nkathole, rnuccite
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-21 17:00:29 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
traces list under content host none

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