2025-08-07: Post deployment migration failing on gstg

Post deployment migration failing on gstg (Severity 3 (Medium))

A post deployment migration is failing on staging with PG::CheckViolation: ERROR: check constraint "check_e2ab92a2f6" of relation "deploy_tokens" is violated by some row

TASK [Run migrations] **********************************************************
fatal: [deploy-01-sv-gstg]: FAILED! => changed=true 
  cmd:
  - /usr/bin/gitlab-rake
  - db:migrate
  delta: '0:02:22.425463'
  end: '2025-08-07 10:46:03.735823'
  msg: non-zero return code
  rc: 1
  start: '2025-08-07 10:43:41.310360'
  stderr: |-
    rake aborted!
    StandardError: An error has occurred, all later migrations canceled:
  
    PG::CheckViolation: ERROR:  check constraint "check_e2ab92a2f6" of relation "deploy_tokens" is violated by some row
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:122:in `block in validate_check_constraint'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/timeout_helpers.rb:31:in `disable_statement_timeout'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:119:in `validate_check_constraint'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:109:in `add_check_constraint'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:260:in `add_multi_column_not_null_constraint'
    /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20250804193153_add_not_null_to_deploy_tokens_sharding_keys.rb:8:in `up'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:33:in `block in exec_migration'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/query_analyzer.rb:83:in `within'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:30:in `exec_migration'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/automatic_lock_writes_on_tables.rb:21:in `exec_migration'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/require_disable_ddl_transaction_for_multiple_locks.rb:35:in `exec_migration'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retry_mixin.rb:46:in `ddl_transaction'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/runner_backoff/active_record_mixin.rb:21:in `execute_migration_in_transaction'
    /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:14:in `with_advisory_lock'
    /opt/gitlab/embedded/bin/bundle:25:in `load'
    /opt/gitlab/embedded/bin/bundle:25:in `<main>'

---

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