Skip to content

Finalize conversion for FKs targeting p_ci_builds - 2

Marius Bobin requested to merge 414396-finalize-fk-conversion-3 into master

What does this MR do and why?

Related to #414396 (closed)

Completes the FK swap for ci_job_artifacts, ci_running_builds and ci_job_variables on .com, development and test.

We're executing them on .com first because we don't know if we'll be able to get the necessary locks on the ci_job_artifacts or ci_builds due to the wraparound prevention autovacuum. If the migrations were execute at the same time as the process, they will be marked as completed and we'll need to reintroduce them to be retried at a later time.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Marius Bobin

Merge request reports