Schedule the `namespaces.organization_id` foreign key to be validated

What does this MR do and why?

Schedule the namespaces.organization_id foreign key to be validated

See https://docs.gitlab.com/ee/development/database/add_foreign_key_to_existing_column.html#schedule-the-fk-to-be-validated.

Migration output

up
❯ bin/rails db:migrate
DEPRECATION WARNING: Support for Rails versions < 7.1 is deprecated and will be removed from ViewComponent 4.0.0 (ViewComponent v4 will remove support for Rails versions < 7.1 no earlier than April 1, 2025) (called from <main> at /Users/abdul/gitlab/gdk/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131540, pg_backend_pid: 78271
main: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: migrating
main: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: migrated (0.0605s)

main: == [advisory_lock_connection] object_id: 131540, pg_backend_pid: 78271
ci: == [advisory_lock_connection] object_id: 131900, pg_backend_pid: 78273
ci: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: migrating
ci: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: migrated (0.0336s)

ci: == [advisory_lock_connection] object_id: 131900, pg_backend_pid: 78273
down
❯ VERSION=20250114100435 bin/rails db:migrate:down:main && VERSION=20250114100435 bin/rails db:migrate:down:ci
DEPRECATION WARNING: Support for Rails versions < 7.1 is deprecated and will be removed from ViewComponent 4.0.0 (ViewComponent v4 will remove support for Rails versions < 7.1 no earlier than April 1, 2025) (called from <main> at /Users/abdul/gitlab/gdk/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 50972
main: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: reverting
main: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: reverted (0.0401s)

main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 50972
DEPRECATION WARNING: Support for Rails versions < 7.1 is deprecated and will be removed from ViewComponent 4.0.0 (ViewComponent v4 will remove support for Rails versions < 7.1 no earlier than April 1, 2025) (called from <main> at /Users/abdul/gitlab/gdk/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 54387
ci: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: reverting
ci: == 20250114100435 PrepareAsyncValidateForeignKeyForNamespacesOrganizationId: reverted (0.0885s)

ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 54387

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

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.

Related to #466142 (closed)

Edited by Abdul Wadood

Merge request reports

Loading