Bug 1979810 - All Hosts page fails to show with error "comparison of NilClass with String failed"
Summary: All Hosts page fails to show with error "comparison of NilClass with String f...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: RH Cloud - Inventory
Version: 6.9.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: 6.10.0
Assignee: Shimon Shtein
QA Contact: Jameer Pathan
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-07-07 06:50 UTC by Stefan Meyer
Modified: 2023-05-19 10:09 UTC (History)
19 users (show)

Fixed In Version: tfm-rubygem-foreman_rh_cloud-4.0.24.1,foreman-2.5.2.17-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1983978 (view as bug list)
Environment:
Last Closed: 2021-11-16 14:12:23 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github theforeman foreman pull 8675 0 None Merged Fixes #33049 - Properly handle missing status type 2021-09-14 15:29:05 UTC
Github theforeman foreman_rh_cloud pull 597 0 None open Add type property to generated status records 2021-07-19 18:24:32 UTC
Red Hat Knowledge Base (Solution) 6171052 0 None None None 2021-07-07 07:20:42 UTC
Red Hat Product Errata RHSA-2021:4702 0 None None None 2021-11-16 14:12:40 UTC

Description Stefan Meyer 2021-07-07 06:50:48 UTC
Description of problem:
The "All Hosts" page fails to show with error "comparison of NilClass with String failed"

Version-Release number of selected component (if applicable):
- Satellite 6.9.3
- Foreman 2.3.1.21

How reproducible:


Steps to Reproduce:
1. By entering the "Hosts => All Hosts" page


Actual results:
- Error message: comparison of NilClass with String failed 

Expected results:


Additional info:

Comment 1 Stefan Meyer 2021-07-07 06:51:32 UTC
# foreman-rake errors:fetch_log request_id=579edf45
2021-07-07T08:28:08 [I|app|579edf45] Started GET "/hosts" for 192.168.2.75 at 2021-07-07 08:28:08 +0200
2021-07-07T08:28:08 [I|app|579edf45] Processing by HostsController#index as HTML
2021-07-07T08:28:08 [I|app|579edf45]   Rendering hosts/index.html.erb within layouts/application
2021-07-07T08:28:08 [I|app|579edf45] Deface: [WARNING] No :original defined for 'insights_hits_header', you should change its definition to include:
 579edf45 |  :original => '012dc2f9dc4a62278e051225839a380e843351ba' 
2021-07-07T08:28:08 [I|app|579edf45] Deface: [WARNING] No :original defined for 'insights_hits_cells', you should change its definition to include:
 579edf45 |  :original => 'f6bb600dc168b62b20d342123c0130e1aae16473' 
2021-07-07T08:28:08 [I|app|579edf45]   Rendered hosts/_list.html.erb (Duration: 54.2ms | Allocations: 9681)
2021-07-07T08:28:08 [I|app|579edf45]   Rendered hosts/index.html.erb within layouts/application (Duration: 98.5ms | Allocations: 28696)
2021-07-07T08:28:08 [W|app|579edf45] comparison of NilClass with String failed
2021-07-07T08:28:08 [I|app|579edf45] Backtrace for 'comparison of NilClass with String failed' error (ActionView::Template::Error): comparison of NilClass with String failed
 579edf45 | /usr/share/foreman/app/helpers/hosts_helper.rb:97:in `sort_by'
 579edf45 | /usr/share/foreman/app/helpers/hosts_helper.rb:97:in `name_column'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/helpers/concerns/foreman_openscap/hosts_helper_extensions.rb:4:in `name_column'
 579edf45 | /usr/share/foreman/app/views/hosts/_list.html.erb:32:in `block in _a0b81b4970c40e91e2abaae59d744a2f'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/relation/delegation.rb:87:in `each'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/relation/delegation.rb:87:in `each'
 579edf45 | /usr/share/foreman/app/views/hosts/_list.html.erb:21:in `_a0b81b4970c40e91e2abaae59d744a2f'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:274:in `_run'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:185:in `block in render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:182:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:385:in `instrument_render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:183:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/deface-1.5.3/lib/deface/action_view_extensions.rb:43:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:357:in `block in render_partial'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:88:in `block in instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:87:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:346:in `render_partial'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:317:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:65:in `render_partial_to_object'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:53:in `render_partial'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/helpers/rendering_helper.rb:38:in `render'
 579edf45 | /usr/share/foreman/app/views/hosts/index.html.erb:12:in `_aa39dd0af591f0fb671523d54c2ab3d1'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:274:in `_run'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:185:in `block in render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:182:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:385:in `instrument_render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:183:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/deface-1.5.3/lib/deface/action_view_extensions.rb:43:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:58:in `block (2 levels) in render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:88:in `block in instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:87:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:57:in `block in render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:65:in `render_with_layout'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:56:in `render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:13:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:61:in `render_template_to_object'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:29:in `render_to_object'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:117:in `block in _render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:304:in `in_rendering_context'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:116:in `_render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/streaming.rb:218:in `_render_template'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:103:in `render_to_body'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:52:in `render_to_body'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/renderers.rb:142:in `render_to_body'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/rendering.rb:25:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:36:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:44:in `block (2 levels) in render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/core_ext/benchmark.rb:14:in `block in ms'
 579edf45 | /opt/rh/rh-ruby25/root/usr/share/ruby/benchmark.rb:308:in `realtime'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/core_ext/benchmark.rb:14:in `ms'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:44:in `block in render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:84:in `cleanup_view_runtime'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/railties/controller_runtime.rb:34:in `cleanup_view_runtime'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:43:in `render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/implicit_render.rb:35:in `default_render'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `block in send_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `tap'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/base.rb:195:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:30:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:112:in `block in run_callbacks'
 579edf45 | /usr/share/foreman/app/controllers/concerns/foreman/controller/timezone.rb:10:in `set_timezone'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 579edf45 | /usr/share/foreman/app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 579edf45 | /usr/share/foreman/app/controllers/concerns/foreman/controller/topbar_sweeper.rb:12:in `set_topbar_sweeper_controller'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/audited-4.9.0/lib/audited/sweeper.rb:14:in `around'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/audited-4.9.0/lib/audited/sweeper.rb:14:in `around'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:139:in `run_callbacks'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/callbacks.rb:41:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rescue.rb:22:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:33:in `block in process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:32:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/params_wrapper.rb:245:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/base.rb:136:in `process'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:39:in `process'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal.rb:190:in `dispatch'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal.rb:254:in `dispatch'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:33:in `serve'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:49:in `block in serve'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:32:in `each'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:32:in `serve'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:834:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.18.1.32/lib/katello/middleware/event_daemon.rb:10:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-dsl-2.3.0/lib/apipie_dsl/static_dispatcher.rb:67:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/static_dispatcher.rb:66:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/extractor/recorder.rb:137:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /usr/share/foreman/lib/foreman/middleware/telemetry.rb:10:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/middleware/checksum_in_headers.rb:27:in `call'
 579edf45 | /usr/share/foreman/lib/foreman/middleware/catch_json_parse_errors.rb:9:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/etag.rb:27:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/conditional_get.rb:27:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/head.rb:12:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/http/content_security_policy.rb:18:in `call'
 579edf45 | /usr/share/foreman/lib/foreman/middleware/logging_context_session.rb:22:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in `context'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/cookies.rb:648:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:101:in `run_callbacks'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/actionable_exceptions.rb:18:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/rack/logger.rb:37:in `call_app'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/rack/logger.rb:28:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/sprockets-rails-3.2.1/lib/sprockets/rails/quiet_assets.rb:13:in `call'
 579edf45 | /usr/share/foreman/lib/foreman/middleware/logging_context_request.rb:11:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/request_id.rb:27:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.18.1.32/lib/katello/prevent_json_parsing.rb:12:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/method_override.rb:24:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/runtime.rb:22:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/executor.rb:14:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/host_authorization.rb:76:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/secure_headers-6.3.0/lib/secure_headers/middleware.rb:11:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/engine.rb:527:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/railtie.rb:190:in `public_send'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/railtie.rb:190:in `method_missing'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:74:in `block in call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `each'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/configuration.rb:228:in `call'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:713:in `handle_request'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:472:in `process_client'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:328:in `block in run'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/thread_pool.rb:134:in `block in spawn_thread'
 579edf45 | /opt/theforeman/tfm/root/usr/share/gems/gems/logging-2.3.0/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
2021-07-07T08:28:09 [I|app|579edf45] Deface: [WARNING] No :original defined for 'change 500 page content', you should change its definition to include:
 579edf45 |  :original => 'b5a069a462197e389fb4ee3217dff38252f5bebd' 
2021-07-07T08:28:09 [I|app|579edf45]   Rendering common/500.html.erb within layouts/application
2021-07-07T08:28:09 [I|app|579edf45]   Rendered common/500.html.erb within layouts/application (Duration: 5.1ms | Allocations: 3432)
2021-07-07T08:28:09 [I|app|579edf45]   Rendered layouts/_application_content.html.erb (Duration: 3.9ms | Allocations: 6506)
2021-07-07T08:28:09 [I|app|579edf45]   Rendering layouts/base.html.erb
2021-07-07T08:28:09 [I|app|579edf45]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_theme_satellite-7.0.1.7/app/views/foreman_theme_satellite/_theme_client_side_branding.js.erb (Duration: 5.0ms | Allocations: 6895)
2021-07-07T08:28:09 [I|app|579edf45]   Rendered layouts/base.html.erb (Duration: 13.4ms | Allocations: 16707)
2021-07-07T08:28:09 [I|app|579edf45] Completed 500 Internal Server Error in 352ms (Views: 33.2ms | ActiveRecord: 112.9ms | Allocations: 127475)

Foreman version: 2.3.1.21
Plugins: 
 - foreman-tasks 3.0.6
 - foreman_ansible 6.1.1
 - foreman_azure_rm 2.1.3
 - foreman_bootdisk 17.0.2
 - foreman_discovery 16.3.6
 - foreman_hooks 0.3.17
 - foreman_kubevirt 0.1.8
 - foreman_leapp 0.1.6
 - foreman_openscap 4.1.3
 - foreman_remote_execution 4.2.3
 - foreman_rh_cloud 3.0.22
 - foreman_templates 9.0.2
 - foreman_theme_satellite 7.0.1.7
 - foreman_virt_who_configure 0.5.5
 - katello 3.18.1.32
 - redhat_access 2.2.20

Comment 2 Stefan Meyer 2021-07-07 07:02:11 UTC
After pushing an openscap report from a client the Openscap Reports page is also failing:


# foreman-rake errors:fetch_log request_id=730eb1cc 
2021-07-07T08:58:39 [I|app|730eb1cc] Started GET "/compliance/arf_reports" for 192.168.2.75 at 2021-07-07 08:58:39 +0200
2021-07-07T08:58:39 [I|app|730eb1cc] Processing by ArfReportsController#index as HTML
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendering /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/index.html.erb within layouts/application
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/_list.html.erb (Duration: 82.2ms | Allocations: 24533)
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/index.html.erb within layouts/application (Duration: 88.2ms | Allocations: 27445)
2021-07-07T08:58:39 [W|app|730eb1cc] comparison of String with nil failed
2021-07-07T08:58:39 [I|app|730eb1cc] Backtrace for 'comparison of String with nil failed' error (ActionView::Template::Error): comparison of String with nil failed
 730eb1cc | /usr/share/foreman/app/helpers/hosts_helper.rb:97:in `sort_by'
 730eb1cc | /usr/share/foreman/app/helpers/hosts_helper.rb:97:in `name_column'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/_list.html.erb:26:in `block in _adbf3371687c6d9d62fc1685ca38d903'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/relation/delegation.rb:87:in `each'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/relation/delegation.rb:87:in `each'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/_list.html.erb:15:in `_adbf3371687c6d9d62fc1685ca38d903'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:274:in `_run'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:185:in `block in render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:182:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:385:in `instrument_render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:183:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/deface-1.5.3/lib/deface/action_view_extensions.rb:43:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:357:in `block in render_partial'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:88:in `block in instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:87:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:346:in `render_partial'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/partial_renderer.rb:317:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:65:in `render_partial_to_object'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:27:in `render_to_object'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:22:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/helpers/rendering_helper.rb:34:in `block in render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:304:in `in_rendering_context'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/helpers/rendering_helper.rb:30:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-4.1.3/app/views/arf_reports/index.html.erb:3:in `_83e1228fd349ae35535c151b986476b7'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:274:in `_run'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:185:in `block in render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:182:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:385:in `instrument_render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/template.rb:183:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/deface-1.5.3/lib/deface/action_view_extensions.rb:43:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:58:in `block (2 levels) in render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:88:in `block in instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/abstract_renderer.rb:87:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:57:in `block in render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:65:in `render_with_layout'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:56:in `render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/template_renderer.rb:13:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:61:in `render_template_to_object'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/renderer/renderer.rb:29:in `render_to_object'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:117:in `block in _render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/base.rb:304:in `in_rendering_context'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:116:in `_render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/streaming.rb:218:in `_render_template'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:103:in `render_to_body'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:52:in `render_to_body'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/renderers.rb:142:in `render_to_body'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/rendering.rb:25:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:36:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:44:in `block (2 levels) in render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/core_ext/benchmark.rb:14:in `block in ms'
 730eb1cc | /opt/rh/rh-ruby25/root/usr/share/ruby/benchmark.rb:308:in `realtime'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/core_ext/benchmark.rb:14:in `ms'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:44:in `block in render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:84:in `cleanup_view_runtime'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/railties/controller_runtime.rb:34:in `cleanup_view_runtime'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:43:in `render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/implicit_render.rb:35:in `default_render'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `block in send_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `tap'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/base.rb:195:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rendering.rb:30:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:112:in `block in run_callbacks'
 730eb1cc | /usr/share/foreman/app/controllers/concerns/foreman/controller/timezone.rb:10:in `set_timezone'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 730eb1cc | /usr/share/foreman/app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 730eb1cc | /usr/share/foreman/app/controllers/concerns/foreman/controller/topbar_sweeper.rb:12:in `set_topbar_sweeper_controller'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/audited-4.9.0/lib/audited/sweeper.rb:14:in `around'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/audited-4.9.0/lib/audited/sweeper.rb:14:in `around'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:121:in `block in run_callbacks'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:139:in `run_callbacks'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/callbacks.rb:41:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/rescue.rb:22:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:33:in `block in process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `block in instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/notifications.rb:180:in `instrument'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/instrumentation.rb:32:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal/params_wrapper.rb:245:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.4/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/abstract_controller/base.rb:136:in `process'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionview-6.0.3.4/lib/action_view/rendering.rb:39:in `process'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal.rb:190:in `dispatch'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_controller/metal.rb:254:in `dispatch'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:33:in `serve'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:49:in `block in serve'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:32:in `each'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/journey/router.rb:32:in `serve'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/routing/route_set.rb:834:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.18.1.32/lib/katello/middleware/event_daemon.rb:10:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-dsl-2.3.0/lib/apipie_dsl/static_dispatcher.rb:67:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/static_dispatcher.rb:66:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/extractor/recorder.rb:137:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /usr/share/foreman/lib/foreman/middleware/telemetry.rb:10:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/apipie-rails-0.5.17/lib/apipie/middleware/checksum_in_headers.rb:27:in `call'
 730eb1cc | /usr/share/foreman/lib/foreman/middleware/catch_json_parse_errors.rb:9:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/etag.rb:27:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/conditional_get.rb:27:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/head.rb:12:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/http/content_security_policy.rb:18:in `call'
 730eb1cc | /usr/share/foreman/lib/foreman/middleware/logging_context_session.rb:22:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in `context'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/cookies.rb:648:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/callbacks.rb:101:in `run_callbacks'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/actionable_exceptions.rb:18:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/rack/logger.rb:37:in `call_app'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/rack/logger.rb:28:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/sprockets-rails-3.2.1/lib/sprockets/rails/quiet_assets.rb:13:in `call'
 730eb1cc | /usr/share/foreman/lib/foreman/middleware/logging_context_request.rb:11:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/request_id.rb:27:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.18.1.32/lib/katello/prevent_json_parsing.rb:12:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/method_override.rb:24:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/runtime.rb:22:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.4/lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/executor.rb:14:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/static.rb:126:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/actionpack-6.0.3.4/lib/action_dispatch/middleware/host_authorization.rb:76:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/secure_headers-6.3.0/lib/secure_headers/middleware.rb:11:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/engine.rb:527:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/railtie.rb:190:in `public_send'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/railties-6.0.3.4/lib/rails/railtie.rb:190:in `method_missing'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:74:in `block in call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `each'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/rack-2.2.3/lib/rack/urlmap.rb:58:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/configuration.rb:228:in `call'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:713:in `handle_request'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:472:in `process_client'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/server.rb:328:in `block in run'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/puma-4.3.6/lib/puma/thread_pool.rb:134:in `block in spawn_thread'
 730eb1cc | /opt/theforeman/tfm/root/usr/share/gems/gems/logging-2.3.0/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendering common/500.html.erb within layouts/application
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered common/500.html.erb within layouts/application (Duration: 9.9ms | Allocations: 9409)
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered layouts/_application_content.html.erb (Duration: 5.6ms | Allocations: 6525)
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendering layouts/base.html.erb
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_theme_satellite-7.0.1.7/app/views/foreman_theme_satellite/_theme_client_side_branding.js.erb (Duration: 5.9ms | Allocations: 6914)
2021-07-07T08:58:39 [I|app|730eb1cc]   Rendered layouts/base.html.erb (Duration: 15.7ms | Allocations: 16735)
2021-07-07T08:58:39 [I|app|730eb1cc] Completed 500 Internal Server Error in 157ms (Views: 38.1ms | ActiveRecord: 17.7ms | Allocations: 76942)

Foreman version: 2.3.1.21
Plugins: 
 - foreman-tasks 3.0.6
 - foreman_ansible 6.1.1
 - foreman_azure_rm 2.1.3
 - foreman_bootdisk 17.0.2
 - foreman_discovery 16.3.6
 - foreman_hooks 0.3.17
 - foreman_kubevirt 0.1.8
 - foreman_leapp 0.1.6
 - foreman_openscap 4.1.3
 - foreman_remote_execution 4.2.3
 - foreman_rh_cloud 3.0.22
 - foreman_templates 9.0.2
 - foreman_theme_satellite 7.0.1.7
 - foreman_virt_who_configure 0.5.5
 - katello 3.18.1.32
 - redhat_access 2.2.20

Comment 4 Pavel Moravec 2021-07-07 07:20:45 UTC
The cause for that backtrace is a record matching this query:

su - postgres -c "psql foreman -c \"SELECT * FROM host_status WHERE type IS null\""

Deleting is is a workaround.


No known cause how such records can pop up, though.

Comment 7 Peter Vreman 2021-07-15 09:33:51 UTC
The issue severity shall be Urgent, because the KB workaround is not persistent.

Today it is broken again after repairing it yesterday

I can also see the records are back:
~~~
[crash/LI] root@li-lc-2224:~# date
Thu Jul 15 09:22:44 UTC 2021
[crash/LI] root@li-lc-2224:~# su - postgres -c "psql foreman -c \"SELECT * FROM host_status WHERE type IS null\""
  id   | type | status | host_id |        reported_at
-------+------+--------+---------+----------------------------
 44606 |      |      1 |      73 | 2021-07-15 00:00:18.08595
 44608 |      |      1 |     111 | 2021-07-15 00:00:18.085993
 44610 |      |      1 |     139 | 2021-07-15 00:00:18.086003
 44611 |      |      1 |     165 | 2021-07-15 00:00:18.086011
...
 44677 |      |      1 |      49 | 2021-07-15 00:00:18.086288
 44679 |      |      1 |     137 | 2021-07-15 00:00:18.086332
(37 rows)

[crash/LI] root@li-lc-2224:~#
~~~

Matching log records from the timeframe:
~~~
2021-07-15T00:00:18 [I|bac|52f465c7] Task {label: InventorySync::Async::InventoryScheduledSync, id: e8e7896f-224a-4a02-9397-c33342e0a10a, execution_plan_id: c8630e70-b474-444d-85c0-7ae638c89a5d} state changed: stopped  result: success
2021-07-15T00:00:18 [I|bac|52f465c7] Task {label: InventorySync::Async::InventoryScheduledSync, id: e8e7896f-224a-4a02-9397-c33342e0a10a, execution_plan_id: c8630e70-b474-444d-85c0-7ae638c89a5d} state changed: stopped  result: success
~~~


And in the rh_cloud plugin there is a call to host_status.update():
~~~
[crash/LI] root@li-lc-2224:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.22/app# grep -R host_status
controllers/insights_cloud/api/machine_telemetries_controller.rb:      host_status = @host.get_status(InsightsClientReportStatus)
controllers/insights_cloud/api/machine_telemetries_controller.rb:      host_status.update(reported_at: Time.now.utc, status: host_status.to_status(data: data))
subscribers/foreman_rh_cloud/insights_subscriber.rb:      host_status = host.get_status(InsightsClientReportStatus)
subscribers/foreman_rh_cloud/insights_subscriber.rb:      host_status.update(status: host_status.to_status)
[crash/LI] root@li-lc-2224:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.22/app#
~~~

Hope this helps to fix the issue soon

Comment 8 Peter Vreman 2021-07-15 10:03:22 UTC
Some more info, it looks all hosts have the InventorySync::InventoryStatus, but there is also for ~50% a second record added.
I did check 2 hosts that shall be the same (id 73 and 74) and one has 2 records and the other only 1:

~~~
foreman=# select count(*) from host_status where reported_at > '2021-07-15 00:00' and reported_at < '2021-07-15 00:01';
 count
-------
   114
(1 row)

foreman=# select count(*) from host_status where reported_at > '2021-07-15 00:00' and reported_at < '2021-07-15 00:01' and type is null;
 count
-------
    37
(1 row)

foreman=# select count(*) from host_status where reported_at > '2021-07-15 00:00' and reported_at < '2021-07-15 00:01' and type is not null;
 count
-------
    77
(1 row)

foreman=# select count(*) from hosts;
 count
-------
    77
(1 row)

foreman=# select * from host_status where reported_at > '2021-07-15 00:00' and reported_at < '2021-07-15 00:01' and host_id=73;
  id   |              type              | status | host_id |        reported_at
-------+--------------------------------+--------+---------+---------------------------
 44580 | InventorySync::InventoryStatus |      1 |      73 | 2021-07-15 00:00:17.9814
 44606 |                                |      1 |      73 | 2021-07-15 00:00:18.08595
(2 rows)

foreman=# select * from host_status where reported_at > '2021-07-15 00:00' and reported_at < '2021-07-15 00:01' and host_id=74;
  id   |              type              | status | host_id |        reported_at
-------+--------------------------------+--------+---------+----------------------------
 44678 | InventorySync::InventoryStatus |      1 |      74 | 2021-07-15 00:00:17.982395
(1 row)

foreman=#
~~~

Comment 9 Peter Vreman 2021-07-15 10:21:58 UTC
There is really a major change between 6.9.2 and 6.9.3 in rh_cloud plugin, the whole InventorySync is newly introduced

~~~
[crash/LI] root@li-lc-2222:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.18.1# grep -R InventoryScheduledSync
[crash/LI] root@li-lc-2222:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.18.1#
~~~

~~~
[crash/LI] root@li-lc-2224:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.22# grep -R InventoryScheduledSync
lib/foreman_rh_cloud/engine.rb:              ForemanTasks::Task.where(label: 'InventorySync::Async::InventoryScheduledSync')
lib/foreman_rh_cloud/engine.rb:                recurring_logic.start(InventorySync::Async::InventoryScheduledSync)
lib/inventory_sync/async/inventory_scheduled_sync.rb:    class InventoryScheduledSync < ::Actions::EntryAction
[crash/LI] root@li-lc-2224:/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_rh_cloud-3.0.22#
~~~


Sorry, i really need to ask it: How could this kind of big function/feature changes ever made into a zStream release that should be bug fixes only.

Comment 10 Peter Vreman 2021-07-15 10:29:22 UTC
It is also worth to mention that foreman_rh_cloud 3.0.22 has another major Bug. It breaks the download of the latest egg for insights-client, see https://bugzilla.redhat.com/show_bug.cgi?id=1982468

Comment 11 Mike McCune 2021-07-15 20:55:14 UTC
Engineering is engaged and will develop a fix for this ASAP, same for 1982468.

Comment 13 Brad Buckingham 2021-07-15 21:20:59 UTC
Hello Peter,

As always, thank you for providing the additional context and information.  As mentioned by Mike, the engineering team is engaged to address this ASAP.

The team will dig in to the issue; however, changes in this area were actually to address bugs that had been raised and weren't deemed enhancements.  Unfortunately, it seems these errors were missed in the verification process.

Please know that we'll work to improve this for future z-streams.

Comment 15 Tomer Brisker 2021-07-19 06:46:19 UTC
While this does not fix the root cause of this BZ, I've opened https://projects.theforeman.org/issues/33049 to avoid the pages from breaking in such cases.

Comment 28 Mike McCune 2021-09-14 15:28:13 UTC
Unfortunately have to move this back to POST as we missed a code change from the original bugfix, we are tracking this needed update here:

https://bugzilla.redhat.com/show_bug.cgi?id=2004144

we will ship a fix for this BZ ASAP for 6.9.z and this will need to get re-verified for 6.10

Comment 40 errata-xmlrpc 2021-11-16 14:12:23 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 (Moderate: Satellite 6.10 Release), 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-2021:4702


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