Query CommitLogs with LEFT JOIN so zero-translation records are caught by retry

Shipped

April 17, 2026 at 5:15 AM UTC

Author

Kamo

Commit

40c85d6

The old query selected from CommitLogTranslation — commit logs with no translations at all were invisible to it. Use LEFT JOIN from CommitLog so the HAVING COUNT < expected clause includes records with 0 translations. Also removes the large allIds IN clause and accepts a Pageable instead, so the caller can cap the batch size per scheduler run.