Project

General

Profile

Bug #12844

unable to access invocation jobs page

Added by Ohad Levy over 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
High
Assignee:
Category:
-
Difficulty:
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

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'

Associated revisions

Revision 1d8b01dd (diff)
Added by Ivan Necas over 6 years ago

Fixes #12844 - make job invocations search work with mysql

Revision f0f65e85
Added by Ivan Necas over 6 years ago

Merge pull request #87 from iNecas/fix-mysql

Fixes #12844 - make job invocations search work with mysql

History

#1 Updated by Ivan Necas over 6 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

#2 Updated by The Foreman Bot over 6 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/theforeman/foreman_remote_execution/pull/87 added

#3 Updated by Ivan Necas over 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#4 Updated by Marek Hulán over 6 years ago

  • Legacy Backlogs Release (now unused) set to 108

Also available in: Atom PDF