Skip to content
Snippets Groups Projects

Docs for marking a batched BG migration finished

Merged Adam Hegyi requested to merge ah-marking-bg-migration-finished-doc into master
All threads resolved!
@@ -266,7 +266,7 @@ arguments until the status query returns no rows.
1. Run a reconfigure:
```plaintext
```plaintext
sudo gitlab-ctl reconfigure
```
@@ -336,14 +336,24 @@ When the background migration is determined to be "safe" to skip, the migration
WARNING:
Make sure you create a backup before proceeding.
```shell
```ruby
# Start the rails console
migration = Gitlab::Database::BackgroundMigration::BatchedMigration.find_by!(job_class_name: "BackfillUserDetailsFields")
connection = ApplicationRecord.connection # or Ci::ApplicationRecord.connection, depending on which DB was the migration scheduled
# mark all jobs completed
migration.batched_jobs.update_all(status: Gitlab::Database::BackgroundMigration::BatchedJob.state_machine.states['succeeded'].value)
migration.update_attribute(:status, Gitlab::Database::BackgroundMigration::BatchedMigration.state_machine.states[:finished].value)
Gitlab::Database::SharedModel.using_connection(connection) do
migration = Gitlab::Database::BackgroundMigration::BatchedMigration.find_for_configuration(
Gitlab::Database.gitlab_schemas_for_connection(connection),
'BackfillUserDetailsFields',
:users,
:id,
[]
)
# mark all jobs completed
migration.batched_jobs.update_all(status: Gitlab::Database::BackgroundMigration::BatchedJob.state_machine.states['succeeded'].value)
migration.update_attribute(:status, Gitlab::Database::BackgroundMigration::BatchedMigration.state_machine.states[:finished].value)
end
```
### The `BackfillNamespaceIdForNamespaceRoute` batched migration job fails
Loading