dbaplus Community

Oct 29, 2023 · Databases

Why MySQL 8.0 MTS Hangs After 2³¹ Transactions and How to Reproduce the Bug

MySQL 8.0.28 and earlier can deadlock in multi‑threaded slave replication when the internal commit sequence counter overflows after 2³¹ transactions, causing workers to stop waking and the replica to hang; the article explains the underlying slave_preserve_commit_order mechanism, the overflow bug, and a step‑by‑step reproduction method.