2026-02-04: post deploy migration failing on production

post deploy migration failing on production (Severity 3)

A post deployment migration (20260113233315_remove_wiki_repository_states_project_id_fk) is failing on production because it is unable to obtain a lock.

https://ops.gitlab.net/gitlab-com/gl-infra/k8s-workloads/gitlab-com/-/jobs/22379724main: -- execute("LOCK TABLE projects, wiki_repository_states IN ACCESS EXCLUSIVE MODE")main: == [advisory_lock_connection] object_id: 74600, pg_backend_pid: 3114839rake aborted!StandardError: An error has occurred, all later migrations canceled:configured attempts to obtain locks are exhausted/srv/gitlab/lib/gitlab/database/with_lock_retries.rb:108:in `rescue in run'/srv/gitlab/lib/gitlab/database/with_lock_retries.rb:98:in `run'/srv/gitlab/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'/srv/gitlab/lib/gitlab/database/migration_helpers/v2.rb:101:in `with_lock_retries'/srv/gitlab/db/post_migrate/20260113233315_remove_wiki_repository_states_project_id_fk.rb:11:in `up'

UPDATE: A retry of the migration succeeded: https://ops.gitlab.net/gitlab-com/gl-infra/k8s-workloads/gitlab-com/-/jobs/22380933.

This ticket was created to track INC-7086, by incident.io 🔥