Freegle / Iznik / 10911

73%

Build Type

push

circleci

Committed by invalid-email-address

Commit Message

chore(batch): enable seven migrated V1 schedules; Galera-safe purge:logs

Promotes purge:chats, purge:logs, emails:validate, users:update-kudos,
groups:update-counts, chats:update-counts and users:update-lastaccess from
the DISABLED section to the active schedule. Daily jobs spread across
02:00–04:30 to avoid bunching. Each has a `// V1: cron/<name>.php` pointer
to the original cron.

Hardens two PurgeService methods that purge:logs depends on:

- purgeOldLikes(): the previous DELETE … WHERE timestamp < ? did a full
  scan on an unindexed column and gap-locked the rows it touched, which
  deadlocks against concurrent inserts on Galera. Switched to the v1
  pattern: read distinct old msgids first (read-only full scan, no gap
  locks), then delete per msgid using the (msgid, type) index.

- purgeOrphanedMessageLogs(): was loading every orphan ID into memory
  before deleting, which is unbounded across the 30–60-day window.
  Now fetches in chunkSize-bounded chunks. Dry-run path switched to
  SELECT COUNT(*) instead of materialising the rows just to count them.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

Coverage Stats

9125 of 10552 branches covered (86.48%)

Branch coverage included in aggregate %.

15 of 22 new or added lines in 1 file covered. (68.18%)

11964 existing lines in 143 files now uncovered.

98596 of 145854 relevant lines covered (67.6%)

19.88 hits per line