Skip to content

Swap system_note_metadata.id to bigint

euko requested to merge 424114-swap-columns into master

What does this MR do and why?

Related to #424114 (closed)

Swaps system_note_metadata's id with id_convert_to_bigint following the documented procedure https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#migrating-integer-primary-keys-to-bigint.

  • The backfill migration was finalized in %16.8, a required stop. The finalizing migration shipped in !138610 (merged).

  • The index that would support the new PK and the FK referencing system_note_metadata's id_convert_to_bigint have been added in !141333 (merged) for gitlab.com asynchronously.

Edited by euko

Merge request reports