Skip to content

Update db:check-schema job for decomposed CI

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

What does this MR do and why?

Add new CI jobs that run db:migrate-from-previous-major-version and db:check-migrations for the decomposed pipeline.

The job db:migrate-from-previous-major-version checks out the tag prior to the last major release, and sets up the database at that point in time. So we have to be careful not to reference a decomposed database at that previous commit before the application was aware of it.

For now, since we intend to keep the schema in sync between the main and ci databases, we run the migrations only against the main database. This also fits with the current design of phase 4 of the rollout, where the ci connections still point at the main database, and we only run one set of migrations.

We can update these jobs later once we're at a later phase in the rollout and have better tooling for migrating multiple databases.

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