Failed Jobs Debugging Queries

Queries to investigate and analyze failed jobs in Farfalla's queue system.

Recent Failed Jobs from High Priority Queue

SELECT
    *
FROM
    `farfalla`.`failed_jobs`
WHERE
    (`failed_at` > '2025-04-13')
    AND (`queue` = 'https://sqs.us-east-1.amazonaws.com/375481448855/highPriority-farfalla-production')
ORDER BY
    `failed_at` DESC
LIMIT
    60
OFFSET
    0;

Daily Count of Message Size Errors (Last 30 Days)

SELECT 
  DATE(failed_at) AS date,
  COUNT(*) AS count
FROM 
  `farfalla`.`failed_jobs`
WHERE 
  failed_at >= CURDATE() - INTERVAL 30 DAY AND
  queue = 'https://sqs.us-east-1.amazonaws.com/375481448855/highPriority-farfalla-production' AND
  exception LIKE '%Message must be shorter than 262144 bytes%'
GROUP BY 
  DATE(failed_at)
ORDER BY 
  date DESC;