Gitlab upgrade fail 12.1.17 to 12.10.14

Question

I was upgrading gitlab docker image. It's since 11.11.8 to the 14.Y.Z, also follow the document version.(https://docs.gitlab.com/ee/update/index.html#upgrade-paths)

But when I upgrade 12.10.14 (12.1.17 to 12.10.14), it's fail.

It's fail log.

bash[migrate gitlab-rails database] (gitlab::database_migrations line 54) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash"  "/tmp/chef-script20220125-27-131h8bw" ----
STDOUT: rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::NotNullViolation: ERROR:  null value in column "id" violates not-null constraint
DETAIL:  Failing row contains (null, null, HTTP Error Rate, sum(rate(nginx_server_requests{code=~"5.*", host="*", %{environm..., HTTP Errors (%), %, 5xx Errors (%), -4, 2022-01-25 14:37:27.610755+00, 2022-01-25 14:37:27.610755+00, t, response_metrics_nginx_http_error_percentage).
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:20:in `block in execute'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:58:in `process_metric_details'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:48:in `block in process_panel'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:47:in `map'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:47:in `process_panel'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:38:in `block in process_group'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:37:in `map'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:37:in `process_group'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:28:in `block in process_content'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:27:in `map'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:27:in `process_content'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database_importers/common_metrics/importer.rb:18:in `execute'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190709220014_import_common_metrics_y_axis.rb:7:in `up'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'

I didn't know how to fixed it.

Help me plz

Answer 1

I can't comment, so I'll post an "answer" instead:

Are you running on the internal or an external database?

It seems that the solution you link to is related to running an external database, but I have this very issue running on the internal database.

Edit: I am running gitlab-rake gitlab:check between upgrades to check that everything is correct (such as migrations) before upgrading and as well after upgrading.

Also, I have just tried with an external database with the exact same problem. Running fine on Gitlab 12.8.10 with external PostgreSQL 11, but failing on Gitlab 12.10.14 with the same external database and postgresql['version'] = 11 set in gitlab.rb.

Edit 2/Solution: I finally managed to get past this! I found this comment that provided me with a solution that let me continue along the upgrade path and everything seems to work fine now.