Job Composer issue

Dear All,

We have experienced some Job Composer issue on OOD-v1.8. Would someone give us some guidance, please?

Best,

Dawei

A problem occurred while initializing your data for this app.

At your own risk you can still open the app or you can just go back to the dashboard

Share this with the developer of your app: The setup production script is supposed to be idempotent and is run each time the user opens the app through the dashboard.

Exception: OodApp::SetupScriptFailed

Per user setup failed for script at /var/www/ood/apps/sys/myjobs/./bin/setup-production for user dmu with output: Exception occurred: no such table: schema_migrations

Stack trace:

/var/www/ood/apps/sys/dashboard/app/apps/ood_app.rb:220:in block (2 levels) in run_setup_production' /var/www/ood/apps/sys/dashboard/app/apps/ood_app.rb:206:in chdir’ /var/www/ood/apps/sys/dashboard/app/apps/ood_app.rb:206:in block in run_setup_production' /opt/ood/ondemand/root/usr/share/gems/2.5/gems/bundler-1.17.3/lib/bundler.rb:313:in block in with_clean_env’ /opt/ood/ondemand/root/usr/share/gems/2.5/gems/bundler-1.17.3/lib/bundler.rb:562:in with_env' /opt/ood/ondemand/root/usr/share/gems/2.5/gems/bundler-1.17.3/lib/bundler.rb:313:in with_clean_env’ /var/www/ood/apps/sys/dashboard/app/apps/ood_app.rb:203:in run_setup_production' /var/www/ood/apps/sys/dashboard/app/controllers/apps_controller.rb:32:in show’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/basic_implicit_render.rb:6:in send_action' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/abstract_controller/base.rb:194:in process_action’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/rendering.rb:30:in process_action' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/abstract_controller/callbacks.rb:42:in block in process_action’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/callbacks.rb:132:in run_callbacks' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/abstract_controller/callbacks.rb:41:in process_action’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/rescue.rb:22:in process_action' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/instrumentation.rb:34:in block in process_action’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/notifications.rb:168:in block in instrument' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/notifications/instrumenter.rb:23:in instrument’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/notifications.rb:168:in instrument' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/instrumentation.rb:32:in process_action’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal/params_wrapper.rb:256:in process_action' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/abstract_controller/base.rb:134:in process’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionview-5.2.4.4/lib/action_view/rendering.rb:32:in process' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal.rb:191:in dispatch’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_controller/metal.rb:252:in dispatch' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/routing/route_set.rb:52:in dispatch’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/routing/route_set.rb:34:in serve' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/journey/router.rb:52:in block in serve’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/journey/router.rb:35:in each' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/journey/router.rb:35:in serve’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/routing/route_set.rb:840:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/etag.rb:27:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/conditional_get.rb:27:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/head.rb:12:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/http/content_security_policy.rb:18:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in context' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/cookies.rb:670:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/callbacks.rb:28:in block in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/callbacks.rb:98:in run_callbacks' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/callbacks.rb:26:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/debug_exceptions.rb:61:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/show_exceptions.rb:33:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/lograge-0.11.2/lib/lograge/rails_ext/rack/logger.rb:15:in call_app' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/railties-5.2.4.4/lib/rails/rack/logger.rb:26:in block in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/tagged_logging.rb:71:in block in tagged' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/tagged_logging.rb:28:in tagged’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/tagged_logging.rb:71:in tagged' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/railties-5.2.4.4/lib/rails/rack/logger.rb:26:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/remote_ip.rb:81:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/request_store-1.5.0/lib/request_store/middleware.rb:19:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/request_id.rb:27:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/method_override.rb:24:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/runtime.rb:22:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/activesupport-5.2.4.4/lib/active_support/cache/strategy/local_cache_middleware.rb:29:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/executor.rb:14:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/actionpack-5.2.4.4/lib/action_dispatch/middleware/static.rb:127:in call’ /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in call' /opt/ood/ondemand/root/usr/share/gems/2.5/ondemand/1.8.18/gems/railties-5.2.4.4/lib/rails/engine.rb:524:in call’ /opt/rh/ondemand/root/usr/share/ruby/vendor_ruby/phusion_passenger/rack/thread_handler_extension.rb:97:in process_request' /opt/rh/ondemand/root/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:149:in accept_and_process_next_request’ /opt/rh/ondemand/root/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:110:in main_loop' /opt/rh/ondemand/root/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler.rb:415:in block (3 levels) in start_threads’ /opt/rh/ondemand/root/usr/share/ruby/vendor_ruby/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception’

This can happen if you database file got zeroed out. look at the file ~/ondemand/data/myjobs/production.sqlite3. if it’s in fact of size 0 just remove the file and restart the PUN and things should come back up.

Thanks, This works!

-Dawei