Skip to content

Validate referenced FK constraints ci_job_artifacts

Max Orefice requested to merge morefice/validate-fk-constraint-job-artifacts into master

Ref: #435801 (closed)

What does this MR do?

Following up !140187 (merged) where we validated those FK constraint async for gitlab.com

This MR validates those FK for self instances users as those constraints are already valid in production as you can see:

"fk_rails_80a9cba3b2_p" FOREIGN KEY (partition_id, job_artifact_id) REFERENCES ci_job_artifacts(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE
"fk_21d25cac1a_p" FOREIGN KEY (partition_id, trace_artifact_id) REFERENCES ci_job_artifacts(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE

Why are we doing this?

Necessary step in order to partition ci_job_artifacts as each referenced FK must include the partition key, as explained in our documentation.

Edited by Max Orefice

Merge request reports