Skip to content

16.5.2 to 16.6.0 db migration problem

Summary

Hello, i am unable to update from 16.5.2-CE to 16.6.0-CE because of db migration problem.

Steps to reproduce

Update from 16.5.2 to 16.6.0

What is the current bug behavior?

PG::UndefinedObject: ERROR: constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist

Update from 16.5.2 to 16.6.0 fails

What is the expected correct behavior?

Update to 16.6.0

Relevant logs

Relevant logs
Recipe: gitlab::database_migrations
  * ruby_block[check remote PG version] action nothing (skipped due to action :nothing)
  * rails_migration[gitlab-rails] action run[2023-11-20T08:30:15+01:00] WARN: gitlab-rails does not have a log_group or default logdir mode defined. Setting to 0700.
* bash_hide_env[migrate gitlab-rails database] action run
  [execute] Running db:migrate rake task
            main: == [advisory_lock_connection] object_id: 118800, pg_backend_pid: 406
            main: == 20231025025733 SwapColumnsForCiPipelinesPipelineIdBigintForSelfHost: migrating
            main: -- columns(:ci_pipelines)
            main:    -> 0.1038s
            main: -- transaction_open?(nil)
            main:    -> 0.0000s
            main: -- execute("LOCK TABLE ci_pipelines IN ACCESS EXCLUSIVE MODE")
            main:    -> 0.0004s
            main: -- clear_cache!(nil)
            main:    -> 0.0000s
            main: -- quote_table_name(:ci_pipelines)
            main:    -> 0.0000s
            main: -- quote_column_name(:auto_canceled_by_id)
            main:    -> 0.0000s
            main: -- quote_column_name(:temp_name_for_renaming)
            main:    -> 0.0000s
            main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"auto_canceled_by_id\" TO \"temp_name_for_renaming\"\n")
            main:    -> 0.0004s
            main: -- clear_cache!(nil)
            main:    -> 0.0000s
            main: -- quote_table_name(:ci_pipelines)
            main:    -> 0.0000s
            main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
            main:    -> 0.0000s
            main: -- quote_column_name(:auto_canceled_by_id)
            main:    -> 0.0000s
            main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"auto_canceled_by_id_convert_to_bigint\" TO \"auto_canceled_by_id\"\n")
            main:    -> 0.0003s
            main: -- clear_cache!(nil)
            main:    -> 0.0000s
            main: -- quote_table_name(:ci_pipelines)
            main:    -> 0.0000s
            main: -- quote_column_name(:temp_name_for_renaming)
            main:    -> 0.0000s
            main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
            main:    -> 0.0000s
            main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"temp_name_for_renaming\" TO \"auto_canceled_by_id_convert_to_bigint\"\n")
            main:    -> 0.0003s
            main: -- quote_table_name(:trigger_1bd97da9c1a4)
            main:    -> 0.0000s
            main: -- execute("ALTER FUNCTION \"trigger_1bd97da9c1a4\" RESET ALL")
            main:    -> 0.0003s
            main: -- quote_table_name(:ci_pipelines)
            main:    -> 0.0000s
            main: -- quote_column_name(:fk_262d4c2d19)
            main:    -> 0.0000s
            main: -- quote_column_name(:temp_name_for_renaming)
            main:    -> 0.0000s
            main: -- execute("ALTER TABLE \"ci_pipelines\"\nRENAME CONSTRAINT \"fk_262d4c2d19\" TO \"temp_name_for_renaming\"\n")
            rake aborted!
            StandardError: An error has occurred, all later migrations canceled:

            PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
            /opt/gitlab/embedded/bin/bundle:25:in `load'
            /opt/gitlab/embedded/bin/bundle:25:in `<main>'

            Caused by:
            ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
            /opt/gitlab/embedded/bin/bundle:25:in `load'
            /opt/gitlab/embedded/bin/bundle:25:in `<main>'

            Caused by:
            PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
            /opt/gitlab/embedded/bin/bundle:25:in `load'
            /opt/gitlab/embedded/bin/bundle:25:in `<main>'
            Tasks: TOP => db:migrate
            (See full trace by running task with --trace)

  ================================================================================
  Error executing action `run` on resource 'bash_hide_env[migrate gitlab-rails database]'
  ================================================================================

  Mixlib::ShellOut::ShellCommandFailed
  ------------------------------------
  Expected process to exit with [0], but received '1'
  ---- Begin output of "bash"  ----
  STDOUT: Running db:migrate rake task
  main: == [advisory_lock_connection] object_id: 118800, pg_backend_pid: 406
  main: == 20231025025733 SwapColumnsForCiPipelinesPipelineIdBigintForSelfHost: migrating
  main: -- columns(:ci_pipelines)
  main:    -> 0.1038s
  main: -- transaction_open?(nil)
  main:    -> 0.0000s
  main: -- execute("LOCK TABLE ci_pipelines IN ACCESS EXCLUSIVE MODE")
  main:    -> 0.0004s
  main: -- clear_cache!(nil)
  main:    -> 0.0000s
  main: -- quote_table_name(:ci_pipelines)
  main:    -> 0.0000s
  main: -- quote_column_name(:auto_canceled_by_id)
  main:    -> 0.0000s
  main: -- quote_column_name(:temp_name_for_renaming)
  main:    -> 0.0000s
  main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"auto_canceled_by_id\" TO \"temp_name_for_renaming\"\n")
  main:    -> 0.0004s
  main: -- clear_cache!(nil)
  main:    -> 0.0000s
  main: -- quote_table_name(:ci_pipelines)
  main:    -> 0.0000s
  main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
  main:    -> 0.0000s
  main: -- quote_column_name(:auto_canceled_by_id)
  main:    -> 0.0000s
  main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"auto_canceled_by_id_convert_to_bigint\" TO \"auto_canceled_by_id\"\n")
  main:    -> 0.0003s
  main: -- clear_cache!(nil)
  main:    -> 0.0000s
  main: -- quote_table_name(:ci_pipelines)
  main:    -> 0.0000s
  main: -- quote_column_name(:temp_name_for_renaming)
  main:    -> 0.0000s
  main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
  main:    -> 0.0000s
  main: -- execute("ALTER TABLE \"ci_pipelines\"\n  RENAME COLUMN \"temp_name_for_renaming\" TO \"auto_canceled_by_id_convert_to_bigint\"\n")
  main:    -> 0.0003s
  main: -- quote_table_name(:trigger_1bd97da9c1a4)
  main:    -> 0.0000s
  main: -- execute("ALTER FUNCTION \"trigger_1bd97da9c1a4\" RESET ALL")
  main:    -> 0.0003s
  main: -- quote_table_name(:ci_pipelines)
  main:    -> 0.0000s
  main: -- quote_column_name(:fk_262d4c2d19)
  main:    -> 0.0000s
  main: -- quote_column_name(:temp_name_for_renaming)
  main:    -> 0.0000s
  main: -- execute("ALTER TABLE \"ci_pipelines\"\nRENAME CONSTRAINT \"fk_262d4c2d19\" TO \"temp_name_for_renaming\"\n")
  rake aborted!
  StandardError: An error has occurred, all later migrations canceled:

  PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
  /opt/gitlab/embedded/bin/bundle:25:in `load'
  /opt/gitlab/embedded/bin/bundle:25:in `<main>'

  Caused by:
  ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
  /opt/gitlab/embedded/bin/bundle:25:in `load'
  /opt/gitlab/embedded/bin/bundle:25:in `<main>'

  Caused by:
  PG::UndefinedObject: ERROR:  constraint "fk_262d4c2d19" for table "ci_pipelines" does not exist
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/constraints_helpers.rb:253:in `rename_constraint'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/swapping.rb:30:in `swap_foreign_keys'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:48:in `block in swap'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:123:in `run_block'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:134:in `block in run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:97:in `run'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retries_helpers.rb:52:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/v2.rb:99:in `with_lock_retries'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:37:in `swap'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20231025025733_swap_columns_for_ci_pipelines_pipeline_id_bigint_for_self_host.rb:21: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:37: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/migrations/lock_retry_mixin.rb:36: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:15:in `block in with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/pg_backend_pid.rb:12:in `with_advisory_lock_connection'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:126:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:101:in `block (3 levels) in <top (required)>'
  /opt/gitlab/embedded/bin/bundle:25:in `load'
  /opt/gitlab/embedded/bin/bundle:25:in `<main>'
  Tasks: TOP => db:migrate
  (See full trace by running task with --trace)
  STDERR:
  ---- End output of "bash"  ----
  Ran "bash"  returned 1

Details of package version

Docker CE version.

Provide the package version installation details

Edited by yordo