Finalize migration BackfillDefaultOrganizationUsers
What does this MR do and why?
This migration was introduced in !144674 (merged).
This migration was finished at 2024-02-24 06:58:01 UTC
, you can confirm
the status using our
batched background migration chatops commands.
To confirm it is finished you can run:
/chatops run batched_background_migrations status 1000483
The last time this background migration was triggered was in db/post_migrate/20240213210124_queue_backfill_default_organization_users.rb
You can read more about the process for finalizing batched background migrations in https://docs.gitlab.com/ee/development/database/batched_background_migrations.html .
As part of our process we want to ensure all batched background migrations have had at least one required stop to process the migration. Therefore we can finalize any batched background migration that was added before the last required stop.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Migration output
Up
bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 120180, pg_backend_pid: 13049
main: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: migrating =========
main: -- transaction_open?(nil)
main: -> 0.0000s
main: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: migrated (0.0335s)
main: == [advisory_lock_connection] object_id: 120180, pg_backend_pid: 13049
ci: == [advisory_lock_connection] object_id: 120580, pg_backend_pid: 13051
ci: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: migrating =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: migrated (0.0095s)
ci: == [advisory_lock_connection] object_id: 120580, pg_backend_pid: 13051
Down
bin/rails db:migrate:down:ci VERSION=$v && bin/rails db:migrate:down:main VERSION=$v
ci: == [advisory_lock_connection] object_id: 119700, pg_backend_pid: 14235
ci: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: reverting =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: reverted (0.0108s)
ci: == [advisory_lock_connection] object_id: 119700, pg_backend_pid: 14235
main: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 14629
main: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: reverting =========
main: == 20240321051307 FinalizeBackfillDefaultOrganizationUsers: reverted (0.0035s)
main: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 14629
Related to #442474 (closed)