#!/usr/bin/env bash set -euo pipefail cd "$(dirname "$0")/.." sql() { docker compose exec -T db \ psql -U messenger -d messenger -At -c "$1" } echo "Finding completed image job..." JOB_ID=$(sql " SELECT j.id FROM attachment_jobs j JOIN attachment_variants v ON v.attachment_id = j.attachment_id WHERE j.status = 'ready' AND v.variant_name = 'thumbnail' ORDER BY j.created_at DESC LIMIT 1; ") if [[ -z "$JOB_ID" ]]; then echo "FAIL: no completed image job found" exit 1 fi echo "Job: $JOB_ID" STATE_QUERY=" SELECT j.status || '|' || j.attempts || '|' || v.sha256 || '|' || ( SELECT COUNT(*) FROM attachment_variants WHERE attachment_id = j.attachment_id ) FROM attachment_jobs j JOIN attachment_variants v ON v.attachment_id = j.attachment_id WHERE j.id = '$JOB_ID' AND v.variant_name = 'thumbnail'; " BEFORE=$(sql "$STATE_QUERY") echo "Before: $BEFORE" echo "Publishing the same job twice..." docker compose run --rm --no-deps api1 \ python -c ' import sys from src.queue import publish_job job_id = sys.argv[1] publish_job(job_id) publish_job(job_id) print("Two duplicate messages published") ' "$JOB_ID" sleep 5 AFTER=$(sql "$STATE_QUERY") echo "After: $AFTER" if [[ "$BEFORE" != "$AFTER" ]]; then echo "FAIL: completed job changed after redelivery" exit 1 fi echo "PASS: duplicate delivery did not change completed job" echo "PASS: thumbnail checksum and variant count preserved"