Skip to content

Finalize migration BackfillDefaultOrganizationUsers

Abdul Wadood requested to merge 442474-finalize-org-default-user-backfill into master

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)

Edited by Abdul Wadood

Merge request reports