Actions
Bug #12844
closedunable to access invocation jobs page
Status:
Closed
Priority:
High
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
Description
ActiveRecord::StatementInvalid Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"foreman_tasks_tasks" ON "foreman_tasks_tasks"."id" = "job_invocations"."task_id' at line 1: SELECT `job_invocations`.* FROM `job_invocations` LEFT JOIN "foreman_tasks_tasks" ON "foreman_tasks_tasks"."id" = "job_invocations"."task_id" ORDER BY job_invocations.id DESC, "job_invocations"."id" DESC LIMIT 20 OFFSET 0 /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:217:in `exec_query' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:226:in `select' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/querying.rb:38:in `block in find_by_sql' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/explain.rb:41:in `logging_query_plan' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/querying.rb:37:in `find_by_sql' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:171:in `exec_queries' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:160:in `block in to_a' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/explain.rb:41:in `logging_query_plan' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:159:in `to_a' /home/foreman/gems/gems/will_paginate-3.0.7/lib/will_paginate/active_record.rb:131:in `to_a' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:189:in `exec_queries' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:160:in `block in to_a' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/explain.rb:41:in `logging_query_plan' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation.rb:159:in `to_a' /home/foreman/gems/gems/will_paginate-3.0.7/lib/will_paginate/active_record.rb:134:in `block in to_a' /home/foreman/gems/gems/will_paginate-3.0.7/lib/will_paginate/collection.rb:96:in `create' /home/foreman/gems/gems/will_paginate-3.0.7/lib/will_paginate/active_record.rb:133:in `to_a' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each' /home/foreman/gems/bundler/gems/foreman_remote_execution-0f4944792e42/app/views/job_invocations/index.html.erb:17:in `_c74150ff773e13d2a11028403f23e1e4' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/template.rb:145:in `block in render' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications.rb:125:in `instrument' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/template.rb:143:in `render' /home/foreman/gems/gems/deface-1.0.2/lib/deface/action_view_extensions.rb:41:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/template_renderer.rb:47:in `block (2 levels) in render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/abstract_renderer.rb:38:in `block in instrument' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `block in instrument' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `instrument' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/abstract_renderer.rb:38:in `instrument' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/template_renderer.rb:46:in `block in render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/template_renderer.rb:54:in `render_with_layout' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/template_renderer.rb:45:in `render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/template_renderer.rb:18:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/renderer.rb:36:in `render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_view/renderer/renderer.rb:17:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/rendering.rb:110:in `_render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/streaming.rb:225:in `_render_template' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/rendering.rb:103:in `render_to_body' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/renderers.rb:28:in `render_to_body' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/compatibility.rb:50:in `render_to_body' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/rendering.rb:88:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/rendering.rb:16:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:40:in `block (2 levels) in render' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/core_ext/benchmark.rb:5:in `block in ms' /opt/rh/rh-ruby22/root/usr/share/ruby/benchmark.rb:303:in `realtime' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/core_ext/benchmark.rb:5:in `ms' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:40:in `block in render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:83:in `cleanup_view_runtime' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:39:in `render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/implicit_render.rb:10:in `default_render' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/implicit_render.rb:5:in `send_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/base.rb:167:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/rendering.rb:10:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/callbacks.rb:18:in `block in process_action' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:649:in `block (4 levels) in _run__300927192299414248__process_action__1755029670491584456__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_8694' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:326:in `around' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:310:in `_callback_around_3152' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_8694' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:637:in `block (3 levels) in _run__300927192299414248__process_action__1755029670491584456__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_8693' /home/foreman/git/foreman/app/controllers/concerns/application_shared.rb:13:in `set_timezone' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_8693' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:636:in `block (2 levels) in _run__300927192299414248__process_action__1755029670491584456__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_8692' /home/foreman/git/foreman/app/models/concerns/foreman/thread_session.rb:32:in `clear_thread' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_8692' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:448:in `block in _run__300927192299414248__process_action__1755029670491584456__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_8691' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:326:in `around' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:310:in `_callback_around_13' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_8691' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:414:in `_run__300927192299414248__process_action__1755029670491584456__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:405:in `__run_callback' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:81:in `run_callbacks' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/callbacks.rb:17:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/rescue.rb:29:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `block in instrument' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `instrument' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/instrumentation.rb:29:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/params_wrapper.rb:207:in `process_action' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/railties/controller_runtime.rb:18:in `process_action' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/base.rb:121:in `process' /home/foreman/gems/gems/actionpack-3.2.22/lib/abstract_controller/rendering.rb:45:in `process' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal.rb:203:in `dispatch' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_controller/metal.rb:246:in `block in action' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/routing/route_set.rb:73:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/routing/route_set.rb:73:in `dispatch' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/routing/route_set.rb:36:in `call' /home/foreman/gems/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call' /home/foreman/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `each' /home/foreman/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/routing/route_set.rb:608:in `call' /home/foreman/gems/gems/apipie-rails-0.2.6/lib/apipie/extractor/recorder.rb:97:in `call' /home/foreman/gems/gems/apipie-rails-0.2.6/lib/apipie/middleware/checksum_in_headers.rb:27:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/etag.rb:23:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/conditionalget.rb:25:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/head.rb:14:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/params_parser.rb:21:in `call' /home/foreman/git/foreman/lib/middleware/catch_json_parse_errors.rb:9:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/flash.rb:242:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/session/abstract/id.rb:210:in `context' /home/foreman/gems/gems/rack-1.4.7/lib/rack/session/abstract/id.rb:205:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/cookies.rb:341:in `call' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/query_cache.rb:64:in `call' /home/foreman/gems/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:405:in `_run__2695338103069468341__call__3433558129602250468__callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:405:in `__run_callback' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:385:in `_run_call_callbacks' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/callbacks.rb:81:in `run_callbacks' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/callbacks.rb:27:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/remote_ip.rb:31:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' /home/foreman/gems/gems/railties-3.2.22/lib/rails/rack/logger.rb:32:in `call_app' /home/foreman/gems/gems/railties-3.2.22/lib/rails/rack/logger.rb:18:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/request_id.rb:22:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/methodoverride.rb:21:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/runtime.rb:17:in `call' /home/foreman/gems/gems/activesupport-3.2.22/lib/active_support/cache/strategy/local_cache.rb:72:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/lock.rb:15:in `call' /home/foreman/gems/gems/actionpack-3.2.22/lib/action_dispatch/middleware/static.rb:83:in `call' /home/foreman/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward' /home/foreman/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch' /home/foreman/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup' /home/foreman/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!' /home/foreman/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call' /home/foreman/gems/gems/railties-3.2.22/lib/rails/engine.rb:484:in `call' /home/foreman/gems/gems/railties-3.2.22/lib/rails/application.rb:231:in `call' /home/foreman/gems/gems/railties-3.2.22/lib/rails/railtie/configurable.rb:30:in `method_missing' /home/foreman/gems/gems/rack-1.4.7/lib/rack/builder.rb:134:in `call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:64:in `block in call' /home/foreman/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:49:in `each' /home/foreman/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:49:in `call' /root/.gem/gems/passenger-5.0.7/lib/phusion_passenger/rack/thread_handler_extension.rb:89:in `process_request' /root/.gem/gems/passenger-5.0.7/lib/phusion_passenger/request_handler/thread_handler.rb:149:in `accept_and_process_next_request' /root/.gem/gems/passenger-5.0.7/lib/phusion_passenger/request_handler/thread_handler.rb:110:in `main_loop' /root/.gem/gems/passenger-5.0.7/lib/phusion_passenger/request_handler.rb:414:in `block (3 levels) in start_threads' /root/.gem/gems/passenger-5.0.7/lib/phusion_passenger/utils.rb:111:in `block in create_thread_and_abort_on_exception' /home/foreman/gems/gems/logging-2.0.0/lib/logging/diagnostic_context.rb:448:in `call' /home/foreman/gems/gems/logging-2.0.0/lib/logging/diagnostic_context.rb:448:in `block in create_with_logging_context'
Updated by Ivan Necas almost 9 years ago
- Status changed from New to Assigned
- Assignee set to Ivan Necas
- Priority changed from Normal to High
- Target version set to 92
I can not reproduce on postgres, will set up mysql and see what's wrong there
Updated by The Foreman Bot almost 9 years ago
- Status changed from Assigned to Ready For Testing
- Pull request https://github.com/theforeman/foreman_remote_execution/pull/87 added
Updated by Ivan Necas almost 9 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset foreman_plugin|1d8b01dd698a9ce5c620b2a6494b0911353897b2.
Updated by Marek Hulán almost 9 years ago
- Translation missing: en.field_release set to 108
Actions