Skip to content

Finalize migration BackfillDefaultOrganizationOwnersAgain

Abdul Wadood requested to merge 441709-finalize-org-owners-backfill into master

What does this MR do and why?

This migration was introduced in !142979 (merged).

This migration was finished at 2024-02-12 22:04: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 1000481

The last time this background migration was triggered was in db/post_migrate/20240126210641_requeue_backfill_default_organization_owners.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: 120040, pg_backend_pid: 8404
main: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: migrating ===
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: migrated (0.0375s)

main: == [advisory_lock_connection] object_id: 120040, pg_backend_pid: 8404
ci: == [advisory_lock_connection] object_id: 120600, pg_backend_pid: 8406
ci: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: 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: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: migrated (0.0113s)

ci: == [advisory_lock_connection] object_id: 120600, pg_backend_pid: 8406
down 
bin/rails db:migrate:down:ci VERSION=$v && bin/rails db:migrate:down:main VERSION=$v
ci: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 8936
ci: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: 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: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: reverted (0.0336s)

ci: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 8936
main: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 9348
main: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: reverting ===
main: == 20240321045306 FinalizeBackfillDefaultOrganizationOwnersAgain: reverted (0.0040s)

main: == [advisory_lock_connection] object_id: 119680, pg_backend_pid: 9348

Related to #441709 (closed)

Merge request reports