Hello,
I was unable to upgrade Gitlab-ce from version 15.4.6 to 15.5.0 because of the following error :
Unable to find check constraint on table “user_details”
Could anyone help please ?
Complete logs :
Running handlers:
[2023-03-03T09:14:19+11:00] 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 18) 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:
Could not find check constraint "check_7d6489f8f3" on table "user_details" which was referenced during the migration.
This issue could be caused by the database schema straying from the expected state.
To resolve this issue, please verify:
1. all previous migrations have completed
2. the database objects used in this migration match the Rails definition in schema.rb or structure.sql
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1294:in `validate_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1286:in `add_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1381:in `add_text_limit'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20220802202505_add_user_details_field_limits.rb:9:in `up'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:33:in `block in exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/query_analyzer.rb:37:in `within'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:30:in `exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retry_mixin.rb:36:in `ddl_transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:115:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:95: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:
Could not find check constraint "check_7d6489f8f3" on table "user_details" which was referenced during the migration.
This issue could be caused by the database schema straying from the expected state.
To resolve this issue, please verify:
1. all previous migrations have completed
2. the database objects used in this migration match the Rails definition in schema.rb or structure.sql
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1294:in `validate_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1286:in `add_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1381:in `add_text_limit'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20220802202505_add_user_details_field_limits.rb:9:in `up'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:33:in `block in exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/query_analyzer.rb:37:in `within'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:30:in `exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retry_mixin.rb:36:in `ddl_transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:115:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:95: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:migrate
(See full trace by running task with --trace)
main: == 20220126191624 AddScanFilePathToDastSiteProfile: migrating =================
main: -- add_column(:dast_site_profiles, :scan_file_path, :text)
main: -> 0.0803s
main: == 20220126191624 AddScanFilePathToDastSiteProfile: migrated (0.0828s) ========
main: == 20220615172230 AddUserPreferenceToTurnOffAutomaticLists: migrating =========
main: -- add_column(:user_preferences, :markdown_automatic_lists, :boolean, {:default=>true, :null=>false})
main: -> 0.0509s
main: == 20220615172230 AddUserPreferenceToTurnOffAutomaticLists: migrated (0.0511s)
main: == 20220802200719 AddUserDetailsProfileFields: migrating ======================
main: -- add_column(:user_details, :linkedin, :text, {:null=>false, :default=>""})
main: -> 0.0098s
main: -- add_column(:user_details, :twitter, :text, {:null=>false, :default=>""})
main: -> 0.0449s
main: -- add_column(:user_details, :skype, :text, {:null=>false, :default=>""})
main: -> 0.0055s
main: -- add_column(:user_details, :website_url, :text, {:null=>false, :default=>""})
main: -> 0.0106s
main: -- add_column(:user_details, :location, :text, {:null=>false, :default=>""})
main: -> 0.0028s
main: -- add_column(:user_details, :organization, :text, {:null=>false, :default=>""})
main: -> 0.0025s
main: == 20220802200719 AddUserDetailsProfileFields: migrated (0.0784s) =============
main: == 20220802202505 AddUserDetailsFieldLimits: migrating ========================
main: -- transaction_open?()
main: -> 0.0000s
main: -- current_schema()
main: -> 0.0010s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE user_details\nADD CONSTRAINT check_7d6489f8f3\nCHECK ( char_length(linkedin) <= 500 )\nNOT VALID;\n")
main: -> 0.0297s
main: -- current_schema()
main: -> 0.0030s
STDERR:
---- End output of "bash" ----
Ran "bash" returned 1
Running handlers complete
[2023-03-03T09:14:19+11:00] ERROR: Exception handlers complete
Infra Phase failed. 19 resources updated in 02 minutes 23 seconds
[2023-03-03T09:14:19+11:00] FATAL: Stacktrace dumped to /opt/gitlab/embedded/cookbooks/cache/cinc-stacktrace.out
[2023-03-03T09:14:19+11:00] FATAL: ---------------------------------------------------------------------------------------
[2023-03-03T09:14:19+11:00] FATAL: PLEASE PROVIDE THE CONTENTS OF THE stacktrace.out FILE (above) IF YOU FILE A BUG REPORT
[2023-03-03T09:14:19+11:00] FATAL: ---------------------------------------------------------------------------------------
[2023-03-03T09:14:19+11:00] 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 18) 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:
Could not find check constraint "check_7d6489f8f3" on table "user_details" which was referenced during the migration.
This issue could be caused by the database schema straying from the expected state.
To resolve this issue, please verify:
1. all previous migrations have completed
2. the database objects used in this migration match the Rails definition in schema.rb or structure.sql
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1294:in `validate_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1286:in `add_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1381:in `add_text_limit'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20220802202505_add_user_details_field_limits.rb:9:in `up'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:33:in `block in exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/query_analyzer.rb:37:in `within'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:30:in `exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retry_mixin.rb:36:in `ddl_transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:115:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:95: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:
Could not find check constraint "check_7d6489f8f3" on table "user_details" which was referenced during the migration.
This issue could be caused by the database schema straying from the expected state.
To resolve this issue, please verify:
1. all previous migrations have completed
2. the database objects used in this migration match the Rails definition in schema.rb or structure.sql
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1294:in `validate_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1286:in `add_check_constraint'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:1381:in `add_text_limit'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20220802202505_add_user_details_field_limits.rb:9:in `up'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:33:in `block in exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/query_analyzer.rb:37:in `within'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers/restrict_gitlab_schema.rb:30:in `exec_migration'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migrations/lock_retry_mixin.rb:36:in `ddl_transaction'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:115:in `configure_database'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:95: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:migrate
(See full trace by running task with --trace)
main: == 20220126191624 AddScanFilePathToDastSiteProfile: migrating =================
main: -- add_column(:dast_site_profiles, :scan_file_path, :text)
main: -> 0.0803s
main: == 20220126191624 AddScanFilePathToDastSiteProfile: migrated (0.0828s) ========
main: == 20220615172230 AddUserPreferenceToTurnOffAutomaticLists: migrating =========
main: -- add_column(:user_preferences, :markdown_automatic_lists, :boolean, {:default=>true, :null=>false})
main: -> 0.0509s
main: == 20220615172230 AddUserPreferenceToTurnOffAutomaticLists: migrated (0.0511s)
main: == 20220802200719 AddUserDetailsProfileFields: migrating ======================
main: -- add_column(:user_details, :linkedin, :text, {:null=>false, :default=>""})
main: -> 0.0098s
main: -- add_column(:user_details, :twitter, :text, {:null=>false, :default=>""})
main: -> 0.0449s
main: -- add_column(:user_details, :skype, :text, {:null=>false, :default=>""})
main: -> 0.0055s
main: -- add_column(:user_details, :website_url, :text, {:null=>false, :default=>""})
main: -> 0.0106s
main: -- add_column(:user_details, :location, :text, {:null=>false, :default=>""})
main: -> 0.0028s
main: -- add_column(:user_details, :organization, :text, {:null=>false, :default=>""})
main: -> 0.0025s
main: == 20220802200719 AddUserDetailsProfileFields: migrated (0.0784s) =============
main: == 20220802202505 AddUserDetailsFieldLimits: migrating ========================
main: -- transaction_open?()
main: -> 0.0000s
main: -- current_schema()
main: -> 0.0010s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE user_details\nADD CONSTRAINT check_7d6489f8f3\nCHECK ( char_length(linkedin) <= 500 )\nNOT VALID;\n")
main: -> 0.0297s
main: -- current_schema()
main: -> 0.0030s
STDERR:
---- End output of "bash" ----
Ran "bash" returned 1