Skip to content

Update db:check-migrations for decomposed CI

Patrick Bair requested to merge pb-update-check-migrations-for-decomposed into master

What does this MR do and why?

Add a new CI job that runs db:check-migrations for the decomposed pipeline.

For now, when we have multiple configured databases, we run the migrations and dump the schema from main only. This matches how we currently expect the decomposed setup to work, since we currently only have a single primary so run migrations against only main.

This also sidesteps some inconsistencies in structure.sql as a result of the way partitioned tables are dumped, which varies depending on if they have attached partitions.

Once we move beyond phase 4 and have better tooling to control migrations for multiple databases, we can revisit how this job works.

Related issue: #345653 (closed)

MR acceptance checklist

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

Edited by Patrick Bair

Merge request reports