Hi,
While upgrading from my 13.X local installation to 14.4 I forgot to wait for the migrations to finish in the 14.0 → 14.4 step, and it failed, and my gitlab is now down. Could you help me get it back up ?
Here’s the result of the migration list psql command:
gitlabhq_production=# select job_class_name, table_name, column_name, job_arguments from batched_background_migrations where status <> 3;
job_class_name | table_name | column_name | job_arguments
---------------------------------------+--------------------+-------------+------------------------------------------------------------------------------------
CopyColumnUsingBackgroundMigrationJob | ci_job_artifacts | id | [["id", "job_id"], ["id_convert_to_bigint", "job_id_convert_to_bigint"]]
CopyColumnUsingBackgroundMigrationJob | ci_builds | id | [["id", "stage_id"], ["id_convert_to_bigint", "stage_id_convert_to_bigint"]]
CopyColumnUsingBackgroundMigrationJob | taggings | id | [["id", "taggable_id"], ["id_convert_to_bigint", "taggable_id_convert_to_bigint"]]
CopyColumnUsingBackgroundMigrationJob | ci_stages | id | [["id"], ["id_convert_to_bigint"]]
CopyColumnUsingBackgroundMigrationJob | ci_builds_metadata | id | [["id"], ["id_convert_to_bigint"]]
(5 rows)
I don’t know if they are stuck or still running.
Edit: one is running, I don’t know how to see if it’s stuck.
# gitlab-rails runner -e production 'puts Gitlab::BackgroundMigration.remaining'
1