Debian Codegraph @

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

raw
1 # Scenario:
2 # T1=({R(B), W(B)})
3 # T2=({R(B), W(B), C}, HIGH_PRIORITY).
4 #
5 # T2 waits for T1 to exit from InnoDB and T1 trying to enter InnoDB
6 # and T1 will wait for async rollback to complete
7 #
8 # Outcome: T1 must abort, T2 must commit.
9
10 --source include/count_sessions.inc
11 --source include/have_debug.inc
12
13 --echo #
14 --echo # Bug #21143276 HANGING DUE TO ASYNC_ROLLBACK
15 --echo #
16
17 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
18 INSERT INTO t1 VALUES (0);
19 START TRANSACTION;
20 insert into t1 values(1);
21 UPDATE t1 SET c1=2 WHERE c1=0;
22 SET DEBUG_SYNC='ha_innobase_info_low SIGNAL update_cmd WAIT_FOR enter_innodb';
23 --send select * from t1
24
25 --echo
26 --echo # On connection 1
27 --connect(con1,localhost,root,,test)
28 --connection con1
29 --source include/start_transaction_high_prio.inc
30 set debug_sync='now WAIT_FOR update_cmd';
31 select * from t1;
32 SET DEBUG_SYNC='trx_kill_blocking_enter SIGNAL enter_innodb';
33 UPDATE t1 SET c1=2 WHERE c1=0;
34 commit;
35
36 --connection default
37 --error ER_LOCK_DEADLOCK
38 --reap
39 commit;
40 select * from t1;
41 DROP TABLE t1;
42
43 --echo #
44 --echo # Bug #25032066: PREPARED TRANSACTION SHOULD NOT BE ROLLED BACK
45 --echo #
46
47 CREATE TABLE t1(col1 int PRIMARY KEY, col2 int);
48 INSERT INTO t1 VALUES(1, 10);
49
50 XA START 'xid1';
51 UPDATE t1 SET col2 = 20;
52 XA END 'xid1';
53 XA PREPARE 'xid1';
54
55 --connection con1
56 --source include/start_transaction_high_prio.inc
57 --send UPDATE t1 SET col2 = 30 WHERE col2 = 10;
58 --sleep 1
59
60 --connection default
61 XA COMMIT 'xid1';
62
63 --connection con1
64 --reap
65 COMMIT;
66
67 --connection default
68 SELECT * FROM t1;
69
70 --disconnect con1
71 DROP TABLE t1;
72
73 --source include/wait_until_count_sessions.inc