Skip to content

Convert `ci_pipeline_variables.pipeline_id` to bigint

Problem

This column references the ci_pipelines table and its column type is not bigint.

Process

Following the process outlined here, we must:

Step MR Workflow Status Milestone
Initialize the conversion and ignore column !123132 (merged) workflowcomplete %16.2
Confirm backfill is finished and Async Create index !125188 (merged)
!128719 (merged)
workflowcomplete
workflowcomplete
%16.3
Sync Create index !127449 (merged) workflowcomplete %16.3
Add not valid foreign key constraint
Async validate foreign key constraint
!127445 (merged) workflowverification %16.3
Sync validate foreign key constraint !129199 (merged) workflowin dev %16.4
Swap the columns %16.4
Remove the trigger and old integer columns %16.5
Remove ignore rules %16.6
Edited by Tianwen Chen