Receiving this error when running "gitlab-ctl reconfigure"

* bash_hide_env[migrate gitlab-rails database] action run
  [execute] rake aborted!
            StandardError: An error has occurred, all later migrations canceled:

            PG::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
            DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
            DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
            DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
            /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
            /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
            /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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)
            Running db:migrate rake task
            main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743
            main: == 20240219092714 PartitionCiStagesAddFkToCiPipelines: migrating ==============
            main: -- transaction_open?(nil)
            main:    -> 0.0000s
            main: -- execute("CREATE TABLE IF NOT EXISTS \"p_ci_stages\" (\n    LIKE \"ci_stages\" INCLUDING ALL\n) PARTITION BY LIST(\"partition_id\")\n")
            main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743

  ================================================================================
  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: rake aborted!
  StandardError: An error has occurred, all later migrations canceled:

  PG::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
  DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
  DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
  DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
  /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
  /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
  /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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)
  Running db:migrate rake task
  main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743
  main: == 20240219092714 PartitionCiStagesAddFkToCiPipelines: migrating ==============
  main: -- transaction_open?(nil)
  main:    -> 0.0000s
  main: -- execute("CREATE TABLE IF NOT EXISTS \"p_ci_stages\" (\n    LIKE \"ci_stages\" INCLUDING ALL\n) PARTITION BY LIST(\"partition_id\")\n")
  main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743
  STDERR:
  ---- End output of "bash"  ----
  Ran "bash"  returned 1

  Cookbook Trace: (most recent call first)
  ----------------------------------------
  /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/resources/rails_migration.rb:20:in `block in class_from_file'

  Resource Declaration:
  ---------------------
  # In /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/resources/rails_migration.rb

   20:   bash_hide_env "migrate #{new_resource.name} database" do
   21:     code <<-EOH
   22:     set -e
   23:     log_file="#{logging_settings[:log_directory]}/#{new_resource.logfile_prefix}-$(date +%Y-%m-%d-%H-%M-%S).log"
   24:     umask 077
   25:     /opt/gitlab/bin/gitlab-rake #{new_resource.rake_task} 2>& 1 | tee ${log_file}
   26:     STATUS=${PIPESTATUS[0]}
   27:     chown #{account_helper.gitlab_user}:#{account_helper.gitlab_group} ${log_file}
   28:     echo $STATUS > #{new_resource.helper.db_migrate_status_file}
   29:     exit $STATUS
   30:     EOH
   31:
   32:     environment new_resource.environment if new_resource.property_is_set?(:environment)
   33:     new_resource.dependent_services.each do |svc|
   34:       notifies :restart, svc, :immediately
   35:     end
   36:
   37:     not_if { new_resource.helper.migrated? }
   38:     sensitive false
   39:   end
   40: end

  Compiled Resource:
  ------------------
  # Declared in /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/resources/rails_migration.rb:20:in `block in class_from_file'

  bash_hide_env("migrate gitlab-rails database") do
    action [:run]
    default_guard_interpreter :default
    interpreter "bash"
    declared_type :bash_hide_env
    cookbook_name "gitlab"
    recipe_name "database_migrations"
    code "    set -e\n    log_file=\"/var/log/gitlab/gitlab-rails/gitlab-rails-db-migrate-$(date +%Y-%m-%d-%H-%M-%S).log\"\n    umask 077\n    /opt/gitlab/bin/gitlab-rake gitlab:db:configure 2>& 1 | tee ${log_file}\n    STATUS=${PIPESTATUS[0]}\n    chown git:git ${log_file}\n    echo $STATUS > /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-c6697a9cd49e1cfa45cc31b1ecdb90ae-6231cc1c609\n    exit $STATUS\n"
    environment "*sensitive value suppressed*"
    not_if { #code block }
  end

  System Info:
  ------------
  chef_version=18.3.0
  platform=ubuntu
  platform_version=20.04
  ruby=ruby 3.1.4p223 (2023-03-30 revision 957bb7cb81) [x86_64-linux]
  program_name=/opt/gitlab/embedded/bin/cinc-client
  executable=/opt/gitlab/embedded/bin/cinc-client


================================================================================
Error executing action `run` on resource 'rails_migration[gitlab-rails]'
================================================================================

Mixlib::ShellOut::ShellCommandFailed
------------------------------------
bash_hide_env[migrate gitlab-rails database] (gitlab::database_migrations line 20) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash"  ----
STDOUT: rake aborted!
StandardError: An error has occurred, all later migrations canceled:

PG::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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::FeatureNotSupported: ERROR:  unique constraint on partitioned table must include all partitioning columns
DETAIL:  UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key.
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in `create_parent_table'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in `partition'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in `convert_table_to_first_list_partition'
/opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in `configure_pg_databases'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94: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)
Running db:migrate rake task
main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743
main: == 20240219092714 PartitionCiStagesAddFkToCiPipelines: migrating ==============
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("CREATE TABLE IF NOT EXISTS \"p_ci_stages\" (\n    LIKE \"ci_stages\" INCLUDING ALL\n) PARTITION BY LIST(\"partition_id\")\n")
main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743
STDERR:
---- End output of "bash"  ----
Ran "bash"  returned 1

Cookbook Trace: (most recent call first)
----------------------------------------
/opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/resources/rails_migration.rb:20:in `block in class_from_file'

Resource Declaration:
---------------------
# In /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb

 51: rails_migration "gitlab-rails" do
 52:   rake_task 'gitlab:db:configure'
 53:   logfile_prefix 'gitlab-rails-db-migrate'
 54:   helper migration_helper
 55:
 56:   environment env_variables
 57:   dependent_services dependent_services
 58:   notifies :run, "execute[clear the gitlab-rails cache]", :immediately
 59:   notifies :run, "ruby_block[check remote PG version]", :immediately
 60:
 61:   only_if { migration_helper.attributes_node['auto_migrate'] }
 62: end

Compiled Resource:
------------------
# Declared in /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb:51:in `from_file'

rails_migration("gitlab-rails") do
  action [:run]
  default_guard_interpreter :default
  declared_type :rails_migration
  cookbook_name "gitlab"
  recipe_name "database_migrations"
  rake_task "gitlab:db:configure"
  logfile_prefix "gitlab-rails-db-migrate"
  helper "*sensitive value suppressed*"
  environment "*sensitive value suppressed*"
  dependent_services ["runit_service[puma]", "sidekiq_service[sidekiq]"]
  only_if { #code block }
end

System Info:
------------
chef_version=18.3.0
platform=ubuntu
platform_version=20.04
ruby=ruby 3.1.4p223 (2023-03-30 revision 957bb7cb81) [x86_64-linux]
program_name=/opt/gitlab/embedded/bin/cinc-client
executable=/opt/gitlab/embedded/bin/cinc-client

[2024-08-07T16:51:32+05:30] INFO: Running queued delayed notifications before re-raising exception

Running handlers: [2024-08-07T16:51:32+05:30] ERROR: Running exception handlers There was an error running gitlab-ctl reconfigure:

rails_migration[gitlab-rails] (gitlab::database_migrations line 51) had an error: Mixlib::ShellOut::ShellCommandFailed: bash_hide_env[migrate gitlab-rails database] (gitlab::database_migrations line 20) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1' ---- Begin output of "bash" ---- STDOUT: rake aborted! StandardError: An error has occurred, all later migrations canceled:

PG::FeatureNotSupported: ERROR: unique constraint on partitioned table must include all partitioning columns DETAIL: UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in create_parent_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in partition' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in convert_table_to_first_list_partition' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in configure_database' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in configure_pg_databases' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:25:in load' /opt/gitlab/embedded/bin/bundle:25:in `'

Caused by: ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: unique constraint on partitioned table must include all partitioning columns DETAIL: UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in create_parent_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in partition' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in convert_table_to_first_list_partition' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in configure_database' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in configure_pg_databases' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:25:in load' /opt/gitlab/embedded/bin/bundle:25:in `'

Caused by: PG::FeatureNotSupported: ERROR: unique constraint on partitioned table must include all partitioning columns DETAIL: UNIQUE constraint on table "p_ci_stages" lacks column "partition_id" which is part of the partition key. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:195:in create_parent_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning/list/convert_table.rb:53:in partition' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:346:in convert_table_to_first_list_partition' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20240219092714_partition_ci_stages_add_fk_to_ci_pipelines.rb:16: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:40: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:54: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:136:in configure_database' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:107:in configure_pg_databases' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:94:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:25:in load' /opt/gitlab/embedded/bin/bundle:25:in `' Tasks: TOP => db:migrate (See full trace by running task with --trace) Running db:migrate rake task main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743 main: == 20240219092714 PartitionCiStagesAddFkToCiPipelines: migrating ============== main: -- transaction_open?(nil) main: -> 0.0000s main: -- execute("CREATE TABLE IF NOT EXISTS "p_ci_stages" (\n LIKE "ci_stages" INCLUDING ALL\n) PARTITION BY LIST("partition_id")\n") main: == [advisory_lock_connection] object_id: 49920, pg_backend_pid: 282743 STDERR: ---- End output of "bash" ---- Ran "bash" returned 1

Deprecations:

omnibus_gitconfig has been deprecated since 16.10 and will be removed in 17.0. omnibus_gitconfig will be removed in GitLab 17.0. For details and migration instructions, please see: https://docs.gitlab.com/ee/update/versions/gitlab_16_changes.html#gitlabomnibus_gitconfig-deprecation

Running handlers complete [2024-08-07T16:51:32+05:30] ERROR: Exception handlers complete Infra Phase failed. 0 resources updated in 32 seconds

Deprecations:

omnibus_gitconfig has been deprecated since 16.10 and will be removed in 17.0. omnibus_gitconfig will be removed in GitLab 17.0. For details and migration instructions, please see: https://docs.gitlab.com/ee/update/versions/gitlab_16_changes.html#gitlabomnibus_gitconfig-deprecation

[2024-08-07T16:51:32+05:30] FATAL: Stacktrace dumped to /opt/gitlab/embedded/cookbooks/cache/cinc-stacktrace.out [2024-08-07T16:51:32+05:30] FATAL: --------------------------------------------------------------------------------------- [2024-08-07T16:51:32+05:30] FATAL: PLEASE PROVIDE THE CONTENTS OF THE stacktrace.out FILE (above) IF YOU FILE A BUG REPORT [2024-08-07T16:51:32+05:30] FATAL: --------------------------------------------------------------------------------------- [2024-08-07T16:51:32+05:30] FATAL: Mixlib::ShellOut::ShellCommandFailed: rails_migration[gitlab-rails] (gitlab::database_migrations line 51) had an error: Mixlib::ShellOut::ShellCommandFailed: bash_hide_env[migrate gitlab-rails database] (gitlab::database_migrations line 20) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1' ---- Begin output of "bash" ---- STDOUT: rake aborted! StandardError: An error has occurred, all later migrations canceled: