Update db:check-schema job for decomposed CI
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.
-
I have evaluated the MR acceptance checklist for this MR.