docker-gitlab icon indicating copy to clipboard operation
docker-gitlab copied to clipboard

Published 20 hours ago • verified publisher icon sameersbn

Migration from 13.10.2 to 13.12.1 causes "ERROR: duplicate key value violates unique constraint"

Open carukc opened this issue 3 years ago • 11 comments

Hello,

While updating GitLab I encountered a duplicate key error:

PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index"

...

Caused by:
gitlab_1    | ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index"
gitlab_1    | DETAIL:  Key (conrelid, contypid, conname)=(1927909, 0, fk_rails_bb3355782d) already exists.

Do you think that I should rebuild the indexes?

Thanks for the help. Here is the detailed log:

2021-06-02 10:43:35,604 INFO success: sshd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) gitlab_1 | 2021-06-02 10:43:35,604 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) gitlab_1 | 2021-06-02 10:43:35,605 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) gitlab_1 | Missing Rails.application.secrets.openid_connect_signing_key for production environment. The secret will be generated and stored in config/s ecrets.yml. gitlab_1 | rake aborted! gitlab_1 | StandardError: An error has occurred, all later migrations canceled: gitlab_1 | gitlab_1 | PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" gitlab_1 | DETAIL: Key (conrelid, contypid, conname)=(1927909, 0, fk_rails_bb3355782d) already exists. gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in exec' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in block (2 levels) in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:48:in block in permit_con current_loads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_l oads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 91:in block in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications/instrumenter.rb:24:in instrument' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 90:in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:998: in add_foreign_key' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:890:in block in method_missing' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in block in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:879:in method_missing' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreig n_key' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:121:in run_block' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:280:in bl ock in within_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:278:in wi thin_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/transactions.rb:212:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:371:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications.rb:182:in instrument' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:370:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:95:in run' gitlab_1 | /home/git/gitlab/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' gitlab_1 | /home/git/gitlab/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:831:in exec_migration' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:812:in block (2 levels) in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:811:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:810:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1002:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1310:in block in execute_migration_in_tr ansaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1363:in ddl_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1309:in execute_migration_in_transaction ' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1281:in block in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1382:in with_advisory_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1061:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1036:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/tasks/database_tasks.rb:238:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:86:in block (3 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in block (2 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/rake-13.0.3/exe/rake:27:in <top (required)>' gitlab_1 | gitlab_1 | Caused by: gitlab_1 | ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_ conname_index" gitlab_1 | DETAIL: Key (conrelid, contypid, conname)=(1927909, 0, fk_rails_bb3355782d) already exists. gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in exec' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in block (2 levels) in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:48:in block in permit_con current_loads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_l oads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 91:in block in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications/instrumenter.rb:24:in instrument' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 90:in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:998: in add_foreign_key' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:890:in block in method_missing' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in block in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:879:in method_missing' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreig n_key' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:121:in run_block' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:280:in bl ock in within_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:278:in wi thin_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/transactions.rb:212:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:371:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications.rb:182:in instrument' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:370:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:95:in run' gitlab_1 | /home/git/gitlab/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' gitlab_1 | /home/git/gitlab/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:831:in exec_migration' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:812:in block (2 levels) in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:811:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:810:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1002:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1310:in block in execute_migration_in_tr ansaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1363:in ddl_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1309:in execute_migration_in_transaction ' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1281:in block in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1382:in with_advisory_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1061:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1036:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/tasks/database_tasks.rb:238:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:86:in block (3 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in block (2 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/rake-13.0.3/exe/rake:27:in <top (required)>' gitlab_1 | gitlab_1 | Caused by: gitlab_1 | PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" gitlab_1 | DETAIL: Key (conrelid, contypid, conname)=(1927909, 0, fk_rails_bb3355782d) already exists. gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in exec' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 92:in block (2 levels) in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:48:in block in permit_con current_loads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_l oads' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 91:in block in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications/instrumenter.rb:24:in instrument' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/postgresql/database_statements.rb: 90:in execute' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:998: in add_foreign_key' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:890:in block in method_missing' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in block in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:858:in say_with_time' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:879:in method_missing' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreig n_key' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:121:in run_block' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:280:in bl ock in within_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in b lock (2 levels) in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in b lock in synchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in h andle_interrupt' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in s ynchronize' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/transaction.rb:278:in wi thin_new_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/database_statements.rb:28 0:in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/transactions.rb:212:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:371:in block in transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.6/lib/active_support/notifications.rb:182:in instrument' gitlab_1 | /home/git/gitlab/lib/gitlab/database.rb:370:in transaction' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' gitlab_1 | /home/git/gitlab/lib/gitlab/database/with_lock_retries.rb:95:in run' gitlab_1 | /home/git/gitlab/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' gitlab_1 | /home/git/gitlab/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' gitlab_1 | /home/git/gitlab/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:831:in exec_migration' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:812:in block (2 levels) in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:811:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:810:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1002:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1310:in block in execute_migration_in_tr ansaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1363:in ddl_transaction' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1309:in execute_migration_in_transaction ' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1281:in block in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1280:in migrate_without_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in block in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1382:in with_advisory_lock' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1229:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1061:in up' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/migration.rb:1036:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/tasks/database_tasks.rb:238:in migrate' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:86:in block (3 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in each' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.6/lib/active_record/railties/databases.rake:84:in block (2 levels) in <to p (required)>' gitlab_1 | /home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/rake-13.0.3/exe/rake:27:in `<top (required)>' gitlab_1 | Tasks: TOP => db:migrate gitlab_1 | (See full trace by running task with --trace) pegasus_gitlab_1 exited with code 1

carukc avatar Jun 02 '21 10:06 carukc

Hi,

I would guess that updating from version 13.10.2 to 13.12.1 is not possible directly.

I would try to follow the official migration path (see https://docs.gitlab.com/ee/update/#upgrade-paths). Therefore, I suspect that the way to go is via intermediate updates (13.10.2 -> 13.0.14 -> 13.1.11 -> latest 13.12.x).

I hope that this works.

Best regards

sachilles avatar Jun 10 '21 14:06 sachilles

Thanks... I'll give that a try.

carukc avatar Jun 10 '21 16:06 carukc

@sachilles , I think that you might have misread the upgrade pahts... your recomendation seems to be for 12.10 to 13.12.x and I am already on 13.10.

I do not think that it would work very well to downgrade to downgrade from 13.10 to 13.1 before upgrading to 13.12.x

So 'Upgrade paths' seems to indicate that 13.1.11 -> latest 13.12.Z -> latest 14.0.Z will work and I am aready passed 13.1.

Perhaps I have misunderstood something but all the same, thank you for the suggestion.

carukc avatar Jun 10 '21 16:06 carukc

Hi @carukc, I am facing your same error, did you manage to find a solution? I am facing the issue upgrading from version 13.5.0 to 13.12.5.

I have an AMI with the current GitLab version (13.5.0) and I cannot upgrade to the version I am aiming for at the moment (13.12.5).

I managed to upgrade from an earlier version up to 13.5.0, and as far as I know, the steps are the same.

I launched a

sudo gitlab-ctl reconfigure, and a sudo gitlab-rake db:migrate

Upon the "migrate" command, the following error arise, and gitlab goes into 500 (503 error).

== 20210413130011 AddPartitionedWebHookLogFk: migrating ======================= -- foreign_keys(:web_hook_logs_part_0c5294f417) -> 0.0024s -- transaction_open?() -> 0.0000s -- foreign_keys("gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_000000") -> 0.0023s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_000000\nADD CONSTRAINT fk_rails_bb3355782d\nFOREIGN KEY (web_hook_id)\nREFERENCES web_hooks (id)\nON DELETE CASCADE\nNOT VALID;\n") -> 0.0009s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_000000 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0015s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202109 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0013s -- add_foreign_key(:web_hook_logs_part_0c5294f417, :web_hooks, {:column=>:web_hook_id, :on_delete=>:cascade, :name=>"fk_rails_bb3355782d", :validate=>true}) rake aborted! StandardError: An error has occurred, all later migrations canceled:

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(28942, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:inblock in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in `up'

Caused by: ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(28942, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:inblock in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in<main>'

I looked at https://docs.gitlab.com/ee/update/#upgrade-paths but the link does not cover my specific case. Did you manage to find a solution?

gl-es avatar Aug 11 '21 14:08 gl-es

Hi,

I am facing same error. My path is 13.4.2 --> 13.5.0 --> 13.7.0 --> 13.9.0 --> 13.12.10.

the db:migrate task gives the error: -- foreign_keys("gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202109") -> 0.0025s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202109 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0004s -- add_foreign_key(:web_hook_logs_part_0c5294f417, :web_hooks, {:column=>:web_hook_id, :on_delete=>:cascade, :name=>"fk_rails_bb3355782d", :validate=>true}) rake aborted! StandardError: An error has occurred, all later migrations canceled:

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

'

Caused by: ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

'

Caused by: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

' Tasks: TOP => db:migrate (See full trace by running task with --trace) root@ip-10-0-0-230:~# gitlab-rake db:migrate --trace ** Invoke db:migrate (first_time) ** Invoke db:load_config (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:load_config ** Invoke schema_version_check (first_time) ** Invoke environment ** Execute schema_version_check ** Execute db:migrate == 20210413130011 AddPartitionedWebHookLogFk: migrating ======================= -- foreign_keys(:web_hook_logs_part_0c5294f417) -> 0.0037s -- transaction_open?() -> 0.0000s -- foreign_keys("gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_000000") -> 0.0026s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_000000 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0005s -- transaction_open?() -> 0.0000s -- foreign_keys("gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202108") -> 0.0025s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202108 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0005s -- transaction_open?() -> 0.0000s -- foreign_keys("gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202109") -> 0.0025s -- execute("ALTER TABLE gitlab_partitions_dynamic.web_hook_logs_part_0c5294f417_202109 VALIDATE CONSTRAINT fk_rails_bb3355782d;") -> 0.0004s -- add_foreign_key(:web_hook_logs_part_0c5294f417, :web_hooks, {:column=>:web_hook_id, :on_delete=>:cascade, :name=>"fk_rails_bb3355782d", :validate=>true}) rake aborted! StandardError: An error has occurred, all later migrations canceled:

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in exec' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in block (2 levels) in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications/instrumenter.rb:24:in instrument' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:998:in add_foreign_key' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:890:in block in method_missing' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in block in say_with_time' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in say_with_time' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:879:in method_missing' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in block in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications.rb:182:in instrument' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:831:in exec_migration' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:812:in block (2 levels) in migrate' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:811:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:810:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1002:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1310:in block in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1363:in ddl_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1309:in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1281:in block in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1382:in with_advisory_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1061:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1036:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/tasks/database_tasks.rb:238:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:86:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in block (2 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:219:in block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:188:in invoke' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:160:in invoke_task' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block (2 levels) in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:125:in run_with_threads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:110:in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:83:in block in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:186:in standard_exception_handling' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:80:in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/exe/rake:27:in <top (required)>' /opt/gitlab/embedded/bin/rake:23:in load' /opt/gitlab/embedded/bin/rake:23:in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in kernel_load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:28:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:476:in exec' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/command.rb:27:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/invocation.rb:127:in invoke_command' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor.rb:399:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:30:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/base.rb:476:in start' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:24:in start' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:46:in block in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/friendly_errors.rb:123:in with_friendly_errors' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:34:in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

'

Caused by: ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in exec' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in block (2 levels) in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications/instrumenter.rb:24:in instrument' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:998:in add_foreign_key' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:890:in block in method_missing' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in block in say_with_time' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in say_with_time' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:879:in method_missing' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in block in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications.rb:182:in instrument' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:831:in exec_migration' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:812:in block (2 levels) in migrate' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:811:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:810:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1002:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1310:in block in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1363:in ddl_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1309:in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1281:in block in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1382:in with_advisory_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1061:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1036:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/tasks/database_tasks.rb:238:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:86:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in block (2 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:219:in block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:188:in invoke' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:160:in invoke_task' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block (2 levels) in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:125:in run_with_threads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:110:in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:83:in block in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:186:in standard_exception_handling' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:80:in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/exe/rake:27:in <top (required)>' /opt/gitlab/embedded/bin/rake:23:in load' /opt/gitlab/embedded/bin/rake:23:in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in kernel_load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:28:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:476:in exec' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/command.rb:27:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/invocation.rb:127:in invoke_command' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor.rb:399:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:30:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/base.rb:476:in start' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:24:in start' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:46:in block in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/friendly_errors.rb:123:in with_friendly_errors' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:34:in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

'

Caused by: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "pg_constraint_conrelid_contypid_conname_index" DETAIL: Key (conrelid, contypid, conname)=(29005, 0, fk_rails_bb3355782d) already exists. /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in exec' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in block (2 levels) in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_loads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:722:in block (2 levels) in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:721:in block in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications/instrumenter.rb:24:in instrument' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract_adapter.rb:712:in log' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/marginalia-1.10.0/lib/marginalia.rb:71:in execute_with_marginalia' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:998:in add_foreign_key' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:890:in block in method_missing' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in block in say_with_time' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:858:in say_with_time' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:879:in method_missing' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:66:in block in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in run_block' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in block in run_block_with_lock_timeout' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in block in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interrupt' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in within_new_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:371:in block in transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/notifications.rb:182:in instrument' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:370:in transaction' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in run_block_with_lock_timeout' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:397:in with_lock_retries' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/foreign_key_helpers.rb:65:in add_concurrent_partitioned_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20210413130011_add_partitioned_web_hook_log_fk.rb:11:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:831:in exec_migration' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:812:in block (2 levels) in migrate' /opt/gitlab/embedded/lib/ruby/2.7.0/benchmark.rb:293:in measure' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:811:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connection' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:810:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1002:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1310:in block in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1363:in ddl_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1309:in execute_migration_in_transaction' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1281:in block in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in migrate_without_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in block in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1382:in with_advisory_lock' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1061:in up' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1036:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/tasks/database_tasks.rb:238:in migrate' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:86:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in block (2 levels) in <top (required)>' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in block in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in execute' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:219:in block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in synchronize' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/task.rb:188:in invoke' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:160:in invoke_task' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block (2 levels) in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in each' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in block in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:125:in run_with_threads' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:110:in top_level' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:83:in block in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:186:in standard_exception_handling' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/lib/rake/application.rb:80:in run' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/rake-13.0.3/exe/rake:27:in <top (required)>' /opt/gitlab/embedded/bin/rake:23:in load' /opt/gitlab/embedded/bin/rake:23:in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:63:in kernel_load' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli/exec.rb:28:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:476:in exec' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/command.rb:27:in run' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/invocation.rb:127:in invoke_command' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor.rb:399:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:30:in dispatch' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/vendor/thor/lib/thor/base.rb:476:in start' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/cli.rb:24:in start' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:46:in block in <top (required)>' /opt/gitlab/embedded/lib/ruby/site_ruby/2.7.0/bundler/friendly_errors.rb:123:in with_friendly_errors' /opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/bundler-2.1.4/exe/bundle:34:in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in

' Tasks: TOP => db:migrate

I'd like to add intermediate steps as suggested by @sachilles going through 13.10.x and 13.11.x. I'll let you know.

fabiomarinetti avatar Aug 31 '21 08:08 fabiomarinetti

I went through 13.10.0 and 13.11.0 and I found that the error occurs at 13.11.0.

fabiomarinetti avatar Aug 31 '21 16:08 fabiomarinetti

Hi @gl-es , @fabiomarinetti

No I did not resolve. I am still stuck at 13.10.2.

I would really love to move on to 14 but am still unable.

carukc avatar Sep 01 '21 02:09 carukc

@carukc maybe I missed an important info: I am using an external aws postgres db. Is it the same for you, or you are facing the issue by using the embedded postgres?

Thanks.

fabiomarinetti avatar Sep 01 '21 07:09 fabiomarinetti

@fabiomarinetti I am using an external (local) instance on postgres version 11.1. I am presently trying to migrate the database to postgres 13.3 to see if that makes a difference but it's not going very well. I've tried backup-recover, import-export and a direct copy using Navicat but none have worked. I think that I might be missing functions in the new instance of postgres. I will keep you posted.

... by local I mean .. not cloud based.

carukc avatar Sep 01 '21 19:09 carukc

hi @carukc I have solved by upgrading to postgres 12.7. Seems it has some magic which avoid the issue to occurr. Let me know if this helped.

fabiomarinetti avatar Sep 02 '21 14:09 fabiomarinetti

Many thanks @fabiomarinetti ! I will give that a try

carukc avatar Sep 17 '21 11:09 carukc