20170306170512 MigrateLegacyManualActions post_migrate fails due to statement timeout
This migration timed out on GitLab.com. It looks like a call to disable_statement_timeout
is needed:
# sudo gitlab-rake db:migrate
I, [2017-03-16T05:20:33.689284 #52461] INFO -- sentry: ** [Raven] Raven 2.0.2 ready to catch errors
== 20170306170512 MigrateLegacyManualActions: migrating =======================
-- execute(" UPDATE ci_builds SET status = 'manual', allow_failure = true\n WHERE ci_builds.when = 'manual' AND ci_builds.status = 'skipped';\n")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: UPDATE ci_builds SET status = 'manual', allow_failure = true
WHERE ci_builds.when = 'manual' AND ci_builds.status = 'skipped';
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20170306170512_migrate_legacy_manual_actions.rb:7:in `up'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: UPDATE ci_builds SET status = 'manual', allow_failure = true
WHERE ci_builds.when = 'manual' AND ci_builds.status = 'skipped';
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20170306170512_migrate_legacy_manual_actions.rb:7:in `up'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20170306170512_migrate_legacy_manual_actions.rb:7:in `up'
/opt/gitlab/embedded/bin/bundle:22:in `load'
/opt/gitlab/embedded/bin/bundle:22:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)