Multiple failures on master due to ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_plans_on_name"
Summary
QA jobs started to fail due to ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_plans_on_name"
:
- https://gitlab.com/gitlab-org/gitlab-qa-mirror/-/pipelines/326554320
- https://gitlab.com/gitlab-org/gitlab-qa-mirror/-/pipelines/326483568
The last successful run was https://gitlab.com/gitlab-org/gitlab-qa-mirror/-/pipelines/326408001
Diff between the first failed and the last successful run: 7aca6e6e...d4df549d
Stack trace
Recipe: gitlab::gitlab-rails
* execute[clear the gitlab-rails cache] action run
- execute /opt/gitlab/bin/gitlab-rake cache:clear
Recipe: gitaly::enable
* runit_service[gitaly] action hup
- send hup to runit_service[gitaly]
There was an error running gitlab-ctl reconfigure:
rails_migration[gitlab-rails] (gitlab::database_migrations line 51) had an error: Mixlib::ShellOut::ShellCommandFailed: bash[migrate gitlab-rails database] (/opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/resources/rails_migration.rb line 16) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash" "/tmp/chef-script20210624-39-ktsp2j" ----
STDOUT: psql:/opt/gitlab/embedded/service/gitlab-rails/db/structure.sql:9: NOTICE: extension "btree_gist" already exists, skipping
psql:/opt/gitlab/embedded/service/gitlab-rails/db/structure.sql:11: NOTICE: extension "pg_trgm" already exists, skipping
rake aborted!
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:124:in `ensure in without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:124:in `without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:90:in `quiet'
(eval):3:in `block (2 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:386:in `block in transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:385:in `transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:66:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:124:in `ensure in without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:124:in `without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:90:in `quiet'
(eval):3:in `block (2 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:386:in `block in transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:385:in `transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:66:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_plans_on_name"
DETAIL: Key (name)=(default) already exists.
(eval):4:in `block (3 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:91:in `block in quiet'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:122:in `without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:90:in `quiet'
(eval):3:in `block (2 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:386:in `block in transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:385:in `transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:66:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_plans_on_name"
DETAIL: Key (name)=(default) already exists.
(eval):4:in `block (3 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:91:in `block in quiet'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:122:in `without_statement_timeout'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/seeder.rb:90:in `quiet'
(eval):3:in `block (2 levels) in run_file'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:386:in `block in transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database.rb:385:in `transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:66:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Tasks: TOP => db:seed_fu
(See full trace by running task with --trace)
== Seed from /opt/gitlab/embedded/service/gitlab-rails/db/fixtures/production/001_application_settings.rb
Creating the default ApplicationSetting record.
== Seed from /opt/gitlab/embedded/service/gitlab-rails/db/fixtures/production/002_admin.rb
Administrator account created:
login: root
password: *** - You opted not to display initial root password to STDOUT.
== Seed from /opt/gitlab/embedded/service/gitlab-rails/db/fixtures/production/010_settings.rb
Saved CI JWT signing key
== Seed from /opt/gitlab/embedded/service/gitlab-rails/db/fixtures/production/998_gitlab_instance_administration_project.rb
Successfully created self monitoring project.
== Seed from /opt/gitlab/embedded/service/gitlab-rails/db/fixtures/production/999_common_metrics.rb
== Seed from ee/db/fixtures/production/010_license.rb
== Seed from ee/db/fixtures/production/027_plans.rb
STDERR:
---- End output of "bash" "/tmp/chef-script20210624-39-ktsp2j" ----
Ran "bash" "/tmp/chef-script20210624-39-ktsp2j" returned 1
Running handlers:
Notes:
Default admin account has been configured with following details:
Username: root
Password: You didn't opt-in to print initial root password to STDOUT.
NOTE: Because these credentials might be present in your log files in plain text, it is highly recommended to reset the password following https://docs.gitlab.com/ee/security/reset_user_password.html#reset-your-root-password.
Running handlers complete
Screenshot / HTML page
Possible fixes
Edited by Nailia Iskhakova (OOO)