20200608205813_set_lock_version_to_not_null.rb post-deployment migration timeout
In !25566 (merged) we introduced several post-deployment migrations
20200608205813_set_lock_version_to_not_null.rb
is failing on staging
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:12:in `block in up'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `up'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:12:in `block in up'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `up'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:12:in `block in up'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `each'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200608205813_set_lock_version_to_not_null.rb:11:in `up'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
Deployer job
Internal slack threads:
Edited by Alessio Caiazza