xa start 'xat2'; select * from Table1 where id = 1 for update; update Table1 set str = (select uuid()) where id = 1; do sleep(5); select * from Table1 where id = 2 for update; -- This will result in a rejected transaction due to detection of deadlock condition. do sleep(3); update Table1 set str = (select uuid()) where id = 2; -- This is timed to run after "xa end" in t1.sql. Upon running this, MySQL replication slave shows error.