fix: allow out-of-order Flyway migrations for V110 #569

Merged
chris merged 1 commit from fix/flyway-out-of-order into main 2026-07-10 20:24:32 +02:00
Owner

Problem

API container restart loop. Flyway validates that V110 not applied but V111 is.
Outcome: Validate failed: Migrations have failed validation

Root cause: V111 merged directly to main before V110 (separate branch).
V110 now can't apply because Flyway detects higher version (V111) already applied.

Fix

Add spring.flyway.out-of-order=true so Flyway applies V110 despite V111
already being present. V110 adds domain_key columns to retrospective runs tables.

Verification

  • CI builds API image
  • Deploy succeeds, container starts healthy
  • flyway_schema_history shows V110 applied after V111
## Problem API container restart loop. Flyway validates that V110 not applied but V111 is. Outcome: `Validate failed: Migrations have failed validation` Root cause: V111 merged directly to main before V110 (separate branch). V110 now can't apply because Flyway detects higher version (V111) already applied. ## Fix Add `spring.flyway.out-of-order=true` so Flyway applies V110 despite V111 already being present. V110 adds `domain_key` columns to retrospective runs tables. ## Verification - CI builds API image - Deploy succeeds, container starts healthy - `flyway_schema_history` shows V110 applied after V111
fix: allow out-of-order Flyway migrations for V110
All checks were successful
Build and Deploy / Detect changed services and test scopes (push) Successful in 3s
Build and Deploy / Run scoped PR tests (push) Has been skipped
Build and Deploy / Smoke API and media worker (push) Has been skipped
Build and Deploy / Smoke web (push) Has been skipped
Build and Deploy / Smoke ML worker (push) Has been skipped
Build and Deploy / Build plants worker image (push) Has been skipped
Build and Deploy / Build people worker image (push) Has been skipped
Build and Deploy / Build converter worker image (push) Has been skipped
Build and Deploy / Build API image (push) Has been skipped
Build and Deploy / Build media worker image (push) Has been skipped
Build and Deploy / Build web image (push) Has been skipped
Build and Deploy / Build ML worker image (push) Has been skipped
Build and Deploy / Deploy API (push) Has been skipped
Build and Deploy / Deploy web (push) Has been skipped
Build and Deploy / Deploy media worker (push) Has been skipped
Build and Deploy / Deploy ML worker (push) Has been skipped
Build and Deploy / Deploy plants worker (push) Has been skipped
Build and Deploy / Deploy people worker (push) Has been skipped
Build and Deploy / Deploy converter worker (push) Has been skipped
Build and Deploy / Clean Docker build artifacts (push) Has been skipped
b9fa336c34
chris merged commit 86f87ae75b into main 2026-07-10 20:24:32 +02:00
Sign in to join this conversation.
No reviewers
No labels
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
chris/memories!569
No description provided.