Skip to content

Prepare conversion of abuse_reports to bigint.

Max Orefice requested to merge initialize-big-int-conversion-abuse_reports into master

What does this MR do and why?

Prepares conversion of abuse_reports to bigint for assignee_id, id, reporter_id, resolved_by_id, user_id.

You can read more about the process for preparing bigint conversion in https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#migrating-integer-primary-keys-to-bigint.

As part of our process we want to ensure all ID columns are bigint to avoid the risk of overflowing while we continue our growth.

See Convert all integer IDs to bigint in the primar... (#465805 - closed)

Verify this MR as it was automatically created by gitlab-housekeeper.

Ensure that those columns are not being converted yet in the production database by checking Joe Bot through https://console.postgres.ai/gitlab. If the columns were already converted in another merge request, consider closing this merge request.

This change was generated by gitlab-housekeeper using the Keeps::InitializeBigIntConversion keep.

To provide feedback on your experience with gitlab-housekeeper please create an issue with the label GitLab Housekeeper and consider pinging the author of this keep.

Changelog: added

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

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

Numbered steps to set up and validate the change are strongly suggested.

Merge request reports

Loading