Opus finding
Webhook ignores enqueueReview's returned reviewId staleness — old commit shas not refreshed
- apps/web/app/api/github/webhook/route.ts:297-320
When isNew=false, the webhook returns and never schedules a worker — comments on retry hand-off. But if the prior row is terminally 'failed' (max attempts), a new identical delivery cannot re-trigger work. This is by design per the comment ('the original one (or the retry cron) will settle the row'), but a 'failed' row will never re-run. Borderline maintainability concern — the operator must reset status manually.
Recommendation
Document this on the duplicate path, or detect status==='failed' and reset to pending_retry if the operator wants a re-attempt via duplicate redelivery.