19 lines
484 B
Plaintext
19 lines
484 B
Plaintext
CREATE TABLE t (i INT) ENGINE = InnoDB;
|
|
INSERT INTO t (i) VALUES(1);
|
|
xa start '1';
|
|
SELECT * FROM t WHERE i = 1 LOCK IN SHARE MODE;
|
|
i
|
|
1
|
|
xa start '2';
|
|
update t set i=2 where i=1;;
|
|
update t set i=2 where i=1;
|
|
xa end '1';
|
|
xa prepare '1';
|
|
xa commit '1';
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
insert into t values (5);
|
|
xa end '2';
|
|
ERROR XA102: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
|
|
xa rollback '2';
|
|
drop table t;
|