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.