fix: add missing worker_job_results FK cleanup in V115 migration #619

Merged
chris merged 1 commit from fix/v115-worker-job-results-fk into main 2026-07-14 22:16:23 +02:00
Owner

Problem\nV115 migration fails on deploy: FK violation when deleting from worker_jobs because worker_job_results rows still reference those jobs.\n\n## Fix\nAdd step 15b before step 16 to DELETE from worker_job_results where the parent worker_jobs match the same queued/failed people-pipeline jobs being cleaned.\n\n## Changes\n- apps/api/src/main/resources/db/migration/V115__clear_person_domain.sql — insert DELETE FROM worker_job_results before DELETE FROM worker_jobs

## Problem\nV115 migration fails on deploy: FK violation when deleting from `worker_jobs` because `worker_job_results` rows still reference those jobs.\n\n## Fix\nAdd step 15b before step 16 to DELETE from `worker_job_results` where the parent `worker_jobs` match the same queued/failed people-pipeline jobs being cleaned.\n\n## Changes\n- `apps/api/src/main/resources/db/migration/V115__clear_person_domain.sql` — insert `DELETE FROM worker_job_results` before `DELETE FROM worker_jobs`
fix: add worker_job_results DELETE before worker_jobs in V115 to respect FK constraint
All checks were successful
Build and Deploy / Detect changed services and test scopes (push) Successful in 3s
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 web image (push) Has been skipped
Build and Deploy / Build media worker 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
Build and Deploy / Run scoped PR tests (push) Successful in 2m5s
ef574c0340
chris merged commit c6f334b6c3 into main 2026-07-14 22:16:23 +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!619
No description provided.