Skip to content

Revert partition of package metadata tables

Fabien Catteau requested to merge 382567-revert-partition-package-metadata into master

What does this MR do and why?

Adds a migration that ensures that package metadata tables are not partitioned. This is needed to fix databases of environments where package metadata tables have been partitioned by !104155 (merged) (reverted) before !108644 (merged) was merged.

Here's the sequence:

  • !104155 (merged) added a migration to partition pm_packages, pm_package_versions, and pm_package_version_licenses.
  • The migration was deployed to staging, but not to production.
  • !108644 (merged) removed that migration.
  • This very MR is needed to revert the changes in the DB schema of staging.

Screenshots or screen recordings

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

How to set up and validate locally

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

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 #382567

Edited by Fabien Catteau

Merge request reports