Disable statement Timeout for RenameLoginRootNamespaces
During the deploy to production we encountered the following error:
deploy-01-sv-gprd.c.gitlab-production.internal == 20180816193530 RenameLoginRootNamespaces: migrating ========================
deploy-01-sv-gprd.c.gitlab-production.internal rake aborted!
deploy-01-sv-gprd.c.gitlab-production.internal StandardError: An error has occurred, this and all later migrations canceled:
deploy-01-sv-gprd.c.gitlab-production.internal
deploy-01-sv-gprd.c.gitlab-production.internal PG::QueryCanceled: ERROR: canceling statement due to statement timeout
deploy-01-sv-gprd.c.gitlab-production.internal : SELECT "namespaces".* FROM "namespaces" INNER JOIN "routes" ON "routes"."source_id" = "namespaces"."id" AND "routes"."source_type" = 'Namespace' WHERE "namespaces"."parent_id" IS NULL AND ("routes"."path" ILIKE '%/login' OR "routes"."path" ILIKE 'login')
deploy-01-sv-gprd.c.gitlab-production.internal /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/rename_reserved_paths_migration/v1/rename_namespaces.rb:9:in `rename_namespaces'
deploy-01-sv-gprd.c.gitlab-production.internal /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/rename_reserved_paths_migration/v1.rb:30:in `rename_root_paths'
deploy-01-sv-gprd.c.gitlab-production.internal /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20180816193530_rename_login_root_namespaces.rb:10:in `up'
It looks like
SELECT "namespaces".* FROM "namespaces" INNER JOIN "routes" ON "routes"."source_id" = "namespaces"."id" AND "routes"."source_type" = 'Namespace' WHERE "namespaces"."parent_id" IS NULL AND ("routes"."path" ILIKE '%/login' OR "routes"."path" ILIKE 'login')
Caused a statement timeout.
When we retried the migration, everything worked fine. Could we disable the statement timeout for that migrations so self-managed instances don't need to deal with this?
This migration was added in https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/6876
/cc @mdelaossa @abrandl