Address the Primary Key Overflow risk for the geo_job_artifact_deleted_events table - Step 2: Finalize background migrations and swap columns
With #331789 (closed) we have started the process of converting geo_job_artifact_deleted_events.job_artifact_id to bigint (int8), as it references ci_job_artifacts.id.
In this issue we'll address the second step of the process:
- Ensure the migration of
job_artifact_idtojob_artifact_id_convert_to_bigintis completed. - Define the index over
job_artifact_id(index_geo_job_artifact_deleted_events_on_job_artifact_id) for the newjob_artifact_id_convert_to_bigintcolumn as well - Copy the FK
- Swap columns
The implementation should follow that of !64577 (merged) (and the additional patch on !64973 (merged)).
Edited by Yannis Roussos