Description of problem: ----------------------- The UI blows up with this error while sorting container nodes on Operating System and Kernel Version. Error text: ERROR: column container_nodes.system_distribution does not exist LINE 1: ...tems"."id" = "container_nodes"."ems_id" ORDER BY container_... ^ [container_node/show_list] Snippet from production.log: [----] I, [2015-11-25T22:58:40.684342 #14439:1133994] INFO -- : Started POST "/container_node/show_list?sortby=4&" for 127.0.0.1 at 2015-11-25 22:58:40 -0500 [----] I, [2015-11-25T22:58:42.004539 #14439:1133994] INFO -- : Processing by ContainerNodeController#show_list as JS [----] I, [2015-11-25T22:58:42.004651 #14439:1133994] INFO -- : Parameters: {"sortby"=>"4"} [----] F, [2015-11-25T22:58:48.000915 #14439:1133994] FATAL -- : Error caught: [PG::UndefinedColumn] ERROR: column container_nodes.system_distribution does not exist LINE 1: ...tems"."id" = "container_nodes"."ems_id" ORDER BY container_... ^ /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:355:in `select' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `block in select_all' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/query_cache.rb:83:in `cache_sql' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `select_all' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/relation/finder_methods.rb:356:in `find_with_associations' /var/www/miq/vmdb/lib/extensions/ar_virtual.rb:374:in `find_with_associations_with_virtual' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/relation.rb:639:in `exec_queries' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/relation.rb:515:in `load' /opt/rh/cfme-gemset/gems/activerecord-4.2.5/lib/active_record/relation.rb:243:in `to_a' /var/www/miq/vmdb/app/models/miq_report/generator.rb:355:in `build_table' /var/www/miq/vmdb/app/models/miq_report/search.rb:125:in `paged_view_search' /var/www/miq/vmdb/app/controllers/application_controller.rb:1756:in `get_view' /var/www/miq/vmdb/app/controllers/application_controller/ci_processing.rb:999:in `process_show_list' /var/www/miq/vmdb/app/controllers/container_node_controller.rb:10:in `show_list' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/implicit_render.rb:4:in `send_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/abstract_controller/base.rb:198:in `process_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/rendering.rb:10:in `process_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/abstract_controller/callbacks.rb:20:in `block in process_action' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:117:in `call' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:117:in `call' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:505:in `call' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:505:in `call' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:92:in `__run_callbacks__' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:778:in `_run_process_action_callbacks' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/callbacks.rb:81:in `run_callbacks' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/abstract_controller/callbacks.rb:19:in `process_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/rescue.rb:29:in `process_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/notifications.rb:164:in `block in instrument' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /opt/rh/cfme-gemset/gems/activesupport-4.2.5/lib/active_support/notifications.rb:164:in `instrument' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/instrumentation.rb:30:in `process_action' /opt/rh/cfme-gemset/gems/actionpack-4.2.5/lib/action_controller/metal/params_wrapper.rb:250:in `process_action' Version-Release number of selected component (if applicable): -------------------- 5.5.0.12 How reproducible: ---------------- Always Steps to Reproduce: ------------------ 1.Manager a Container 2.Navigate to Containers -> Container Nodes page 3.Sort container nodes on Operating System, Kernel Version Actual results: --------------- UI error Expected results: ---------------- No UI error Additional info: ----------------
Kobi, can you look at this? Thank you.
Submited upstream: https://github.com/ManageIQ/manageiq/pull/7441
Yaacov, shouldn't this be moved to POST?
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/RHBA-2016:1348