Skip to content

Resolve "Swap epic_user_mentions.note_id to bigint"

Diogo Frazão requested to merge 417402-swap-integer-and-bigint-columns-for-notes-and-dependent-tables-for-self-managed into master

What does this MR do and why?

This MR swaps theepic_user_mentions.note_id and epic_user_mentions.note_id_convert_to_bigint columns for self-managed instances. This was already done for GitLab.com with Swap epic_user_mentions.note_id to bigint (!116627 - merged). The process is outlined here.

The timeline for GitLab.com was the following:

Since we made the decision to commit schema changes to structure.sql for the above MRs, we now need to take into account the state of the schema from which the self-managed instance was created.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

I have done the following manual testing:

  1. Create new instance from each of 15.8.0, 15.9.0, 16.0.0, 16.1.0 and 16.2.0
  2. Upgrade all instances to 16.2.1
  3. Execute the migrations from this MR
  4. Verify migrations execute successfully and epic_user_mentions table has the expected schema.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #417402 (closed)

Edited by Diogo Frazão

Merge request reports