My Oracle Support Banner

Replicating XA Transactions in MySQL 5.7, the Slave Fails With Lock Wait Timeout and the Error: "Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable." (Doc ID 2257067.1)

Last updated on MARCH 24, 2019

Applies to:

MySQL Server - Version 5.7 to 5.7 [Release 5.7]
Information in this document applies to any platform.

Symptoms

Replicating XA transactions in MySQL 5.7 sometimes causes the replication slave to stop with the following error in the SHOW SLAVE STATUS output:

Notice how the blocking_pid (the processlist id of the blocking connection) is 0.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.