Ensure that all tables that reference ci_job_artifacts have partition_id column
We need to check and update(if needed) all the tables that reference ci_job_artifacts
for:
-
- They have a partition_id
column for each FK -
- the partition_id
column is correctly populated with an appropriate value
Currently only these table reference ci_job_artifacts
:
gitlabhq_development=# \d+ ci_job_artifacts
...
Referenced by:
TABLE "ci_build_trace_metadata" CONSTRAINT "fk_21d25cac1a" FOREIGN KEY (trace_artifact_id) REFERENCES ci_job_artifacts(id) ON DELETE CASCADE
TABLE "ci_job_artifact_states" CONSTRAINT "fk_rails_80a9cba3b2" FOREIGN KEY (job_artifact_id) REFERENCES ci_job_artifacts(id) ON DELETE CASCADE
Edited by Max Orefice