Loading
Duplicate bigint indexes for ci_sources_pipelines
What does this MR do and why?
Release N+1 (finalize backfill + duplicate indexes) of the ci_sources_pipelines bigint conversion for id, project_id, and source_project_id. Per the swap-the-columns process, the index duplication must be fully deployed before the column swap, so the swap is handled in a separate, later MR (see #500027 (closed)).
This MR adds two post-deployment migrations:
FinalizeCiSourcesPipelinesBigintConversionfinalizes the backfill batched background migration enqueued in step N.CreateBigintIndexesForCiSourcesPipelinescreates indexes on the*_convert_to_bigintcolumns mirroring the existing integer-column indexes:ci_sources_pipelines_pkeyindex_ci_sources_pipelines_on_project_idindex_ci_sources_pipelines_on_source_project_id
There are no foreign keys on the converted columns, so no bigint foreign keys are created here.
On new installations the columns are already bigint, so both migrations no-op and db/structure.sql is intentionally left unchanged.
Related
- Work item: #500026 (closed)
- Followed by (swap): #500027 (closed)
- Blocked by: #500025 (closed)
- Epic: &15621
Edited by Oleg Yakovenko