-- Fix stale_processing files: status='processing' but job_id IS NULL
-- These files should be reset to 'pending' so they can be processed properly

-- Show current state
SELECT file_uuid, file_name, status, job_id 
FROM videos 
WHERE status = 'processing' AND job_id IS NULL;

-- Fix: Reset to pending
UPDATE videos 
SET status = 'pending', processing_status = NULL 
WHERE status = 'processing' AND job_id IS NULL;

-- Verify fix
SELECT file_uuid, file_name, status, job_id 
FROM videos 
WHERE file_uuid IN (
  '5e207a246fd6a2a65ee0a267440465ee',
  '9cbeb112fcc5452e869755a539478061',
  'bfba056f5021e2404b0870cc0b1fa851',
  '2d0ec3a72d5dda98b10b3eb777650846'
);