fix: face pipeline - unique constraint + numpy type error #588

Merged
chris merged 2 commits from fix/face-pipeline-unique-constraint into main 2026-07-11 19:24:13 +02:00
Owner

Changes\n\n### Bug #1: UNIQUE constraint kills multi-face results\n- Migration V112 drops old UNIQUE constraint on worker_job_id, idempotency_key, domain_key, scope_type, payload\n- Adds new UNIQUE constraint on worker_job_id, idempotency_key, domain_key, scope_type, scope\n- scope stores bounding box JSON, uniquely identifying each face region\n\n### Bug #2: numpy TypeError in people worker\n- face_model.py:83 change float(scores[i]) to float(scores[i].item()) for proper scalar conversion

## Changes\n\n### Bug #1: UNIQUE constraint kills multi-face results\n- Migration V112 drops old UNIQUE constraint on worker_job_id, idempotency_key, domain_key, scope_type, payload\n- Adds new UNIQUE constraint on worker_job_id, idempotency_key, domain_key, scope_type, scope\n- scope stores bounding box JSON, uniquely identifying each face region\n\n### Bug #2: numpy TypeError in people worker\n- face_model.py:83 change float(scores[i]) to float(scores[i].item()) for proper scalar conversion
fix: numpy array scalar conversion in face_model.py
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
c5d9a19bf9
chris merged commit 3f37515f43 into main 2026-07-11 19:24:13 +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!588
No description provided.