Skip to content

Backport notes.id BIGINT conversion fix to 16.4.0

Leonardo da Rosa requested to merge cherry-pick-235f08d8 into 16-4-stable-ee

What does this MR do and why?

Prevents notes column swap migration from failing, as reported by customers.

Detailed explanation

Some customers reported that their instances failed to upgrade to v16.4.0 because their database has a different name for fk_d83a918cb1 FK.

Column swap will not be completed if notes_pkey is still dependent on FKs in the database. To avoid issues, the migration will look up for these faulting FK and drop them.

Cherry-pick commits from:

MR acceptance checklist

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

  • This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch.
  • The MR that fixed the bug on the default branch has been deployed to GitLab.com (not applicable for documentation or spec changes).
  • This MR has a severity label assigned (if applicable).
  • This MR has been approved by a maintainer (only one approval is required).
  • Ensure the e2e:package-and-test-ee job has either succeeded or been approved by a Software Engineer in Test.

Note to the merge request author and maintainer

If you have questions about the patch release process, please:

Edited by Leonardo da Rosa

Merge request reports