Debian Codegraph @

mysql-test/suite/rpl/t/rpl_parallel_xa_same_xid.test

raw
1 # The tests verify concurrent execution of replicated (MDEV-742)
2 # XA transactions in the parallel optimistic mode.
3 # Prove optimistic scheduler handles xid-namesake XA:s.
4 # That is despite running in parallel there must be no conflicts
5 # caused by multiple transactions' same xid.
6
7 --source include/have_binlog_format_mixed_or_row.inc
8 --source include/have_innodb.inc
9 --source include/have_perfschema.inc
10 --source include/master-slave.inc
11
12 --disable_query_log
13 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
14 --enable_query_log
15
16 --let $xid_num = 19
17 --let $repeat = 17
18 --let $workers = 7
19 --connection slave
20 call mtr.add_suppression("WSREP: handlerton rollback failed");
21
22 --source include/stop_slave.inc
23 # a measure against MDEV-20605
24 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
25
26 SET @old_parallel_threads = @@GLOBAL.slave_parallel_threads;
27 --disable_query_log
28 --eval SET @@global.slave_parallel_threads = $workers
29 --enable_query_log
30 SET @old_parallel_mode = @@GLOBAL.slave_parallel_mode;
31 SET @@global.slave_parallel_mode ='optimistic';
32 --source include/start_slave.inc
33
34 --connection master
35 CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB;
36
37 --let $i = $xid_num
38 --let $t = t1
39 --disable_query_log
40 while ($i)
41 {
42 --let $k = $repeat
43 while ($k)
44 {
45 --eval XA START 'xid_$i'
46 --eval INSERT INTO $t SET a=$i, b=$k
47 --eval XA END 'xid_$i'
48 --let $one_phase = `SELECT IF(floor(rand()*10)%2, "ONE PHASE", 0)`
49 if (!$one_phase)
50 {
51 --eval XA PREPARE 'xid_$i'
52 --eval XA COMMIT 'xid_$i'
53 }
54 if ($one_phase)
55 {
56 --eval XA COMMIT 'xid_$i' ONE PHASE
57 }
58
59 if (!$one_phase)
60 {
61 --eval XA START 'xid_$i'
62 --eval INSERT INTO $t SET a=$i, b=$k
63 --eval XA END 'xid_$i'
64 --eval XA PREPARE 'xid_$i'
65 --eval XA ROLLBACK 'xid_$i'
66 }
67
68 --dec $k
69 }
70
71 --dec $i
72 }
73 --enable_query_log
74
75
76
77 # Above-like test complicates execution env to create
78 # data conflicts as well. They will be resolved by the optmistic
79 # scheduler as usual.
80
81 CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB;
82
83 --let $i = $xid_num
84 --let $t = t2
85 --disable_query_log
86 while ($i)
87 {
88 --let $k = $repeat
89 while ($k)
90 {
91 --eval XA START 'xid_$i'
92 --eval INSERT INTO $t SET a=NULL, b=$k
93 --eval UPDATE $t SET b=$k + 1 WHERE a=last_insert_id() % $workers
94 --eval XA END 'xid_$i'
95 --let $one_phase = `SELECT IF(floor(rand()*10)%2, "ONE PHASE", 0)`
96 if (!$one_phase)
97 {
98 --eval XA PREPARE 'xid_$i'
99 --eval XA COMMIT 'xid_$i'
100 }
101 if ($one_phase)
102 {
103 --eval XA COMMIT 'xid_$i' ONE PHASE
104 }
105
106 --eval XA START 'xid_$i'
107 --eval UPDATE $t SET b=$k + 1 WHERE a=last_insert_id() % $workers
108 --eval DELETE FROM $t WHERE a=last_insert_id()
109 --eval XA END 'xid_$i'
110 --eval XA PREPARE 'xid_$i'
111 --eval XA ROLLBACK 'xid_$i'
112
113 --let $do_drop_create = `SELECT IF(floor(rand()*10)%100, 1, 0)`
114 if ($do_drop_create)
115 {
116 DROP TABLE t1;
117 CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB;
118 }
119 --dec $k
120 }
121
122 --dec $i
123 }
124 --enable_query_log
125
126 --source include/sync_slave_sql_with_master.inc
127 --let $diff_tables= master:t1, slave:t1
128 --source include/diff_tables.inc
129
130 #
131 # Clean up.
132 #
133 --connection slave
134 --source include/stop_slave.inc
135 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
136 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
137 --source include/start_slave.inc
138
139 --connection master
140 DROP TABLE t1, t2;
141
142 --source include/rpl_end.inc