Validate foreign key `fk_rails_e214655a86_p`
This foreign key was added in !166318 (diffs) to replace the corrupted ones from #487947 (comment 2101608662) and when the cleanup of orphaned rows is complete we can validate it.
Process:
- Use
prepare_partitioned_async_foreign_key_validationto validate the FK over the weekend: https://docs.gitlab.com/ee/development/database/add_foreign_key_to_existing_column.html#validate-the-foreign-key-asynchronously - When the FK is valid on .com, use
add_concurrent_partitioned_foreign_keyto add the FK between the routing tables. Same call as the one from the original MR, but with thevalidate:option set totrue.
Details:
SOURCE_TABLE_NAME = :p_ci_builds_execution_configs
TARGET_TABLE_NAME = :p_ci_pipelines
COLUMN = :pipeline_id
TARGET_COLUMN = :id
PARTITION_COLUMN = :partition_id
FK_NAME = :fk_rails_e214655a86_p