connection node_2; connection node_1; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INT) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, 10); connection node_1; BEGIN; SELECT * FROM t1 FOR UPDATE; f1 f2 1 10 connection node_2; UPDATE t1 SET f1 = 2; connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; connection node_1; COMMIT; ERROR 40001: Deadlock found when trying to get lock; try restarting transaction wsrep_local_bf_aborts_diff 1 connection node_1; BEGIN; SELECT * FROM t1 FOR UPDATE; f1 f2 2 10 connection node_2; UPDATE t1 SET f2 = 20; connection node_1a; connection node_1; COMMIT; ERROR 40001: Deadlock found when trying to get lock; try restarting transaction wsrep_local_bf_aborts_diff 1 DROP TABLE t1;