Upgrading from 11.8.0 to 11.11.8 fails with database migration

General
1

Hi

I attempted an upgrade from 11.8.0 to 11.11.8 via:

yum install gitlab-ee-11.11.8-ee.0.el7

with error:

There was an error running gitlab-ctl reconfigure:

bash[migrate gitlab-rails database] (gitlab::database_migrations line 53) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash"  "/tmp/chef-script20210215-17441-1hxuxr0" ----
STDOUT: rake aborted!
ActiveRecord::DuplicateMigrationNameError:

Multiple migrations have the name AddExternalClassificationAuthorizationSettingsToApplictionSettings.

/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56: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)
STDERR:
---- End output of "bash"  "/tmp/chef-script20210215-17441-1hxuxr0" ----
Ran "bash"  "/tmp/chef-script20210215-17441-1hxuxr0" returned 1

I already checked for multiple migrations via:

gitlab-rake db:migrate:status | grep -i "init schem"

with output:

   up     20140313092127  Init schema

I have tried a couple of commands found via search, but can not resolve the issue.
I will really appreciate some help.
Regards

2

Issue resolved. I figured out that

Multiple migrations have the name AddExternalClassificationAuthorizationSettingsToApplictionSettings

means that there is a file called:

20171211131502_add_external_classification_authorization_settings_to_appliction_settings.rb

in the /opt/gitlab/embedded/service/gitlab-rails/db/migrate directory.
I moved the file to a temp storage location and then re-ran gitlab-ctl reconfigure. It kept on complaining about more duplicates and I finally had to move all of the following files to get reconfigure to work:

-rw-r--r-- 1 root    root      971 Aug 10  2019 20171211131502_add_external_classification_authorization_settings_to_appliction_settings.rb
-rw-r--r-- 1 root    root      297 Aug 10  2019 20171218140451_add_external_authorization_service_classification_label_to_projects.rb
-rw-r--r-- 1 root    root      537 Aug 10  2019 20180115094742_add_default_project_creation_setting.rb
-rw-r--r-- 1 root    root      445 Aug 10  2019 20180115113902_add_project_creation_level_to_groups.rb
-rw-r--r-- 1 root    root      747 Aug 10  2019 20180209115333_create_chatops_tables.rb
-rw-r--r-- 1 root    root      536 Aug 10  2019 20180314100728_add_external_authorization_service_timeout_to_application_settings.rb
-rw-r--r-- 1 root    root      539 Aug 10  2019 20180314145917_add_header_and_footer_banners_to_appearances_table.rb
-rw-r--r-- 1 root    root      621 Aug 10  2019 20180315160435_add_external_auth_mutual_tls_fields_to_project_settings.rb