BUG: `job_type` and `job_status` enums don't match — `jobs.js` DB table uses `job_type` ENUM with missing values #75

New issue

Closed

opened 2026-05-25 06:23:51 -04:00 by zgaetano · 1 comment

zgaetano commented

2026-05-25 06:23:51 -04:00

Owner

Fixed in migration 016-fix-job-type-enum.sql — job_type now includes proxy, import; job_status includes completed. Verified.

Fixed in migration `016-fix-job-type-enum.sql` — `job_type` now includes `proxy`, `import`; `job_status` includes `completed`. Verified.

zgaetano referenced this issue from a commit

2026-05-26 10:10:49 -04:00

fix: close all 24 open issues (#40–#94)

zgaetano commented

2026-05-26 19:41:14 -04:00

Author

Owner

Fix Plan — #75 job_type and job_status enums don't match

Root cause: job_type enum: proxy_gen, thumbnail, conform, export (+ youtube_import, trim via migrations). BullMQ queues: proxy, thumbnail, conform, import, trim. Naming inconsistency: import vs youtube_import. Also: upload.js and assets.js never write to jobs DB table — only add to BullMQ.

Fix: Align enum values with BullMQ queue names. Either:

Rename BullMQ queues to match DB enum
Add missing enum values via migration
Stop writing to jobs DB table and track purely via BullMQ

Files: migration SQL, src/routes/upload.js, src/routes/assets.js, worker files
Effort: ~1.5h
**Priority: P2 — data consistency

## Fix Plan — #75 job_type and job_status enums don't match **Root cause:** job_type enum: proxy_gen, thumbnail, conform, export (+ youtube_import, trim via migrations). BullMQ queues: proxy, thumbnail, conform, import, trim. Naming inconsistency: import vs youtube_import. Also: upload.js and assets.js never write to jobs DB table — only add to BullMQ. **Fix:** Align enum values with BullMQ queue names. Either: 1. Rename BullMQ queues to match DB enum 2. Add missing enum values via migration 3. Stop writing to jobs DB table and track purely via BullMQ **Files:** migration SQL, src/routes/upload.js, src/routes/assets.js, worker files **Effort:** ~1.5h **Priority: P2 — data consistency

zgaetano closed this issue

2026-05-26 21:58:45 -04:00

zgaetano referenced this issue

2026-05-26 21:58:50 -04:00

BUG: POST /assets/batch-trim creates jobs table row with wrong job_type — no matching pg_enum value #70

zgaetano referenced this issue

2026-05-26 21:58:57 -04:00

BUG: Batch-trim DB jobs row is orphaned — no status lifecycle, job_type enum is stale #90