Backend: Migrate ci_build_needs.id to bigint
ci_build_needs.id
column is an int4 primary key currently exceeding 50% of saturation. As a result, that key must be migrated to a big int to ensure we don't exhaust potential values.
Timeline
This process needs to be started ASAP - exhausting this key would cause serious harm to the running application.
Process
Following the process outlined here, we must:
Initialize the conversion | !110521 (merged) | workflowcomplete | %15.9 |
Swap the columns | !111968 (merged) && !112444 (merged) | workflowcomplete | %15.10 |
Remove the trigger and old integer columns | !115398 (merged) | workflowcomplete | %15.11 |
Remove ignore rules | !116924 (merged) | workflowin review | %16.0 |
Questions or Help
Reach out to groupdatabase in slack or in the issue.
Edited by Laura Montemayor