Debian Codegraph @

mysql-test/suite/innodb/r/high_prio_trx_debug.result

raw
1 #
2 # Bug #21143276 HANGING DUE TO ASYNC_ROLLBACK
3 #
4 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (0);
6 START TRANSACTION;
7 insert into t1 values(1);
8 UPDATE t1 SET c1=2 WHERE c1=0;
9 SET DEBUG_SYNC='ha_innobase_info_low SIGNAL update_cmd WAIT_FOR enter_innodb';
10 select * from t1;
11
12 # On connection 1
13 include/start_transaction_high_prio.inc
14 START TRANSACTION /* HIGH PRIORITY */;
15 set debug_sync='now WAIT_FOR update_cmd';
16 select * from t1;
17 c1
18 0
19 SET DEBUG_SYNC='trx_kill_blocking_enter SIGNAL enter_innodb';
20 UPDATE t1 SET c1=2 WHERE c1=0;
21 commit;
22 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
23 commit;
24 select * from t1;
25 c1
26 2
27 DROP TABLE t1;
28 #
29 # Bug #25032066: PREPARED TRANSACTION SHOULD NOT BE ROLLED BACK
30 #
31 CREATE TABLE t1(col1 int PRIMARY KEY, col2 int);
32 INSERT INTO t1 VALUES(1, 10);
33 XA START 'xid1';
34 UPDATE t1 SET col2 = 20;
35 XA END 'xid1';
36 XA PREPARE 'xid1';
37 include/start_transaction_high_prio.inc
38 START TRANSACTION /* HIGH PRIORITY */;
39 UPDATE t1 SET col2 = 30 WHERE col2 = 10;;
40 XA COMMIT 'xid1';
41 COMMIT;
42 SELECT * FROM t1;
43 col1 col2
44 1 20
45 DROP TABLE t1;