Post deployment migration failure due to statement timeout
Failure during post-deployment migration in https://ops.gitlab.net/gitlab-com/gl-infra/deployer/-/jobs/524842 (private link).
Caused by:
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."state" = 'opened' AND "merge_requests"."merge_status" = 'can_be_merged' AND ("merge_requests"."id" >= 35) ORDER BY "merge_requests"."id" ASC LIMIT 1 OFFSET 10000
/opt/gitlab/embedded/service/gitlab-rails/config/initializers/peek.rb:18:in `async_exec_params'
/opt/gitlab/embedded/service/gitlab-rails/config/initializers/peek.rb:18:in `exec_params'
/opt/gitlab/embedded/service/gitlab-rails/app/models/concerns/each_batch.rb:78:in `block in each_batch'
/opt/gitlab/embedded/service/gitlab-rails/app/models/concerns/each_batch.rb:68:in `step'
/opt/gitlab/embedded/service/gitlab-rails/app/models/concerns/each_batch.rb:68:in `each_batch'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20190528180441_enqueue_reset_merge_status.rb:24:in `up'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
It appears to be caused by https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/28843