Debian Codegraph @

mysql-test/suite/innodb/t/trx_deadlock.test

raw
1 --echo #
2 --echo # MDEV-36959 Deadlock does not rollback transaction fully
3 --echo #
4
5 --source include/have_log_bin.inc
6 --source include/have_innodb.inc
7 --source include/count_sessions.inc
8
9 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 INT) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1, 1), (2, 2);
11 SELECT * FROM t1;
12
13 --connect (con1,localhost,root,,)
14 START TRANSACTION;
15 --echo # Trx-1: Lock 1st record
16 UPDATE t1 SET col2=10 where col1=1;
17
18 --connection default
19 START TRANSACTION;
20 --echo # Trx-2: Lock 2nd record
21 UPDATE t1 SET col2=100 where col1=2;
22
23 --connection con1
24 --echo # Trx-1: Try locking 1st record : Wait
25 --send UPDATE t1 SET col2=10 where col1=2
26
27 --connection default
28 --echo # Wait for Trx-1 to get into lock wait stage
29 let $wait_condition=
30 SELECT COUNT(*) >= 2 FROM INFORMATION_SCHEMA.INNODB_LOCKS
31 WHERE lock_table like "%t1%";
32 --source include/wait_condition.inc
33
34 --echo # Trx-2: Try locking 2nd record : Deadlock
35 --error ER_LOCK_DEADLOCK
36 UPDATE t1 SET col2=100 where col1=1;
37
38 --connection con1
39 --reap
40 ROLLBACK;
41
42 --connection default
43 SELECT @@in_transaction;
44 UPDATE t1 SET col2=10 where col1=1;
45 UPDATE t1 SET col2=100 where col1=2;
46 SELECT @@in_transaction;
47 ROLLBACK;
48
49 SELECT * FROM t1;
50 DROP TABLE t1;
51
52 --echo #
53 --echo # MDEV-37141 DML committed within XA transaction block after deadlock error and implicit rollback
54 --echo #
55
56 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 INT) ENGINE=InnoDB;
57 INSERT INTO t1 VALUES (1, 1), (2, 2);
58 SELECT * FROM t1;
59
60 --echo # Wait for information schema cache for locks to get cleared
61 let $wait_condition=
62 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_LOCKS
63 WHERE lock_table like "%t1%";
64 --source include/wait_condition.inc
65
66 --connection con1
67 XA BEGIN 'x1';
68 --echo # XA Trx-1: Lock 1st record
69 UPDATE t1 SET col2=10 where col1=1;
70
71 --connection default
72 XA BEGIN 'x2';
73 --echo # XA Trx-2: Lock 2nd record
74 UPDATE t1 SET col2=100 where col1=2;
75
76 --connection con1
77 --echo # XA Trx-1: Try locking 1st record : Wait
78 --send UPDATE t1 SET col2=10 where col1=2
79
80 --connection default
81 --echo # Wait for XA Trx-1 to get into lock wait stage
82 let $wait_condition=
83 SELECT COUNT(*) >= 2 FROM INFORMATION_SCHEMA.INNODB_LOCKS
84 WHERE lock_table like "%t1%";
85 --source include/wait_condition.inc
86
87 --echo # XA Trx-2: Try locking 2nd record : Deadlock
88 --error ER_LOCK_DEADLOCK
89 UPDATE t1 SET col2=100 where col1=1;
90 --error ER_XAER_RMFAIL
91 INSERT INTO t1 VALUES (3, 3), (4, 4);
92 --error ER_XAER_RMFAIL
93 XA END 'x2';
94 XA ROLLBACK 'x2';
95
96 --connection con1
97 --reap
98 XA END 'x1';
99 XA ROLLBACK 'x1';
100
101 --connection default
102 SELECT * FROM t1;
103 DROP TABLE t1;
104
105 --disconnect con1
106 --source include/wait_until_count_sessions.inc