Isaac Connor 1f84c57ccc fix: use READ COMMITTED in Refresh_Summaries_SWR to avoid Events deadlock ...

INSERT INTO Event_Summaries_New SELECT * FROM VIEW_Event_Summaries took
shared next-key locks on the source Events table (required for STATEMENT
binlog correctness under the default REPEATABLE READ).  Concurrent DELETE
FROM Events deadlocked against those S locks.

Switch the procedure to READ COMMITTED so the source-side SELECT runs as
a consistent snapshot read with no row locks.

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

2026-04-07 13:29:35 -04:00

6.5 KiB

Raw Permalink Blame History

View Raw