Skip to content

Internal Server Error when trying to submit jobs via the self service

the server logs show this:

App 1357538 stderr: 2021-08-22 13:09:15 - ActiveRecord::NotNullViolation - PG::NotNullViolation: ERROR:  null value in column "requestor_id" of relation "jobs" violates not-null constraint
App 1357538 stderr: DETAIL:  Failing row contains (14763069, 2021-08-22 13:09:15.420744, 2021-08-22 13:09:15.420744, unstable, amd64, null, , null, null, null, null, null, null, null, null, null, 16879, null, t, null).
App 1357538 stderr: :
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:675:in `exec_params'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:675:in `block (2 levels) in exec_no_cache'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:674:in `block in exec_no_cache'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:722:in `block (2 levels) in log'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:721:in `block in log'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:712:in `log'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:673:in `exec_no_cache'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:656:in `execute_and_clear'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `exec_query'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:135:in `exec_insert'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:132:in `exec_insert'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:166:in `insert'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `insert'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/persistence.rb:375:in `_insert_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/persistence.rb:932:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/counter_cache.rb:166:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/locking/optimistic.rb:70:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/attribute_methods/dirty.rb:211:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/callbacks.rb:331:in `block in _create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/callbacks.rb:135:in `run_callbacks'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/callbacks.rb:825:in `_run_create_callbacks'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/callbacks.rb:331:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/timestamp.rb:110:in `_create_record'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/persistence.rb:905:in `create_or_update'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/callbacks.rb:327:in `block in create_or_update'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/callbacks.rb:135:in `run_callbacks'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/callbacks.rb:825:in `_run_save_callbacks'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/callbacks.rb:327:in `create_or_update'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/timestamp.rb:128:in `create_or_update'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/persistence.rb:503:in `save!'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/validations.rb:53:in `save!'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:318:in `block in save!'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:375:in `block in with_transaction_returning_status'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `block in transaction'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `transaction'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in `transaction'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:366:in `with_transaction_returning_status'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:318:in `save!'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/suppressor.rb:48:in `save!'
App 1357538 stderr: 	/usr/share/rubygems-integration/all/gems/activerecord-6.0.3.7/lib/active_record/persistence.rb:55:in `create!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/debci/test_handler.rb:69:in `block in request_tests'
App 1357538 stderr: 	/usr/lib
App 1357538 stderr: /ruby/vendor_ruby/debci/test_handler.rb:57:in `each'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/debci/test_handler.rb:57:in `request_tests'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/debci/self_service.rb:138:in `block (2 levels) in <class:SelfService>'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/debci/self_service.rb:137:in `each'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/debci/self_service.rb:137:in `block in <class:SelfService>'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1636:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1636:in `block in compile!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:987:in `block (3 levels) in route!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1006:in `route_eval'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:987:in `block (2 levels) in route!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1035:in `block in process_route'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1033:in `catch'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1033:in `process_route'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:985:in `block in route!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:984:in `each'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:984:in `route!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1098:in `block in dispatch!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `block in invoke'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `catch'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `invoke'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1095:in `dispatch!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:919:in `block in call!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `block in invoke'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `catch'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1072:in `invoke'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:919:in `call!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:908:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/omniauth/strategy.rb:192:in `call!'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/omniauth/strategy.rb:169:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/omniauth/builder.rb:45:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/xss_header.rb:18:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/base.rb:50:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/base.rb:50:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/path_traversal.rb:16:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/json_csrf.rb:26:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/base.rb:50:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/base.rb:50:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/protection/frame_options.rb:31:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/session/abstract/id.rb:269:in `context'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/session/abstract/id.rb:263:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/null_logger.rb:11:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/head.rb:14:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:194:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1951:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1503:in `block in call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1730:in `synchronize'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/sinatra/base.rb:1503:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/urlmap.rb:77:in `block in call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/urlmap.rb:61:in `each'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/urlmap.rb:61:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/rack/builder.rb:177:in `call'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/phusion_passenger/rack/thread_handler_extension.rb:97:in `process_request'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:160:in `accept_and_process_next_request'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:113:in `main_loop'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler.rb:416:in `block (3 levels) in start_threads'
App 1357538 stderr: 	/usr/lib/ruby/vendor_ruby/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception'