[Fixed] Upgrade from 14.3.0 to 14.10.0 fails with background migration error

This is an FYI issue just in case someone has the same problem. It's similar to #2409 but with an upgrade from 14.3.0 to 14.10.0.

The error message was:

rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

Expected batched background migration for the given configuration to be marked as 'finished', but it is 'active':#011{:job_class_name=>"ProjectNamespaces::BackfillProjectNamespaces", :table_name=>:projects, :col
umn_name=>:id, :job_arguments=>[nil, "up"]}

Finalize it manualy by running

#011sudo gitlab-rake gitlab:background_migrations:finalize[ProjectNamespaces::BackfillProjectNamespaces,projects,id,'[null,"up"]']

For more information, check the documentation

#011https://docs.gitlab.com/ee/user/admin_area/monitoring/background_migrations.html#database-migrations-failing-because-of-batched-background-migration-not-finished

To apply the suggested fix (using docker-compose where I have a gitlab container):

• Stop the container
• Run docker-compose run --rm gitlab app:rake gitlab:background_migrations:finalize[ProjectNamespaces::BackfillProjectNamespaces,projects,id,'[null\,"up"]']

That fixed it for me. The command may be a little different but can be copied from the error message.

No repository file or test is identified. Start with the 14.3.0-to-14.10.0 upgrade path and the linked background-migration documentation, then inspect how docker-compose invokes the GitLab rake task. Done would require a reproducible upgrade fix or documented handling that avoids the manual finalize command.