Skip to content

Add index for the new primary key on system_note_metadata

euko requested to merge 424114-create-bigint-primary-key-index into master

What does this MR do and why?

Related to #424114 (closed)

system_note_metadata table's primary key column id needs to be converted to use bigint type.

id_convert_to_bigint is the new column that's been backfilled and uses bigint. We need to create a new index on the column. The index will be used to support the new primary key (this step is a part of https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#swap-the-columns-release-n--1).

The index has been added (prepared) asynchronously for .com in !141330 (merged)

This MR synchronously adds the same index following https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#add-a-migration-to-create-the-index-synchronously.

Edited by euko

Merge request reports