Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_parallel_switch_sequential.test

raw
1
2 --source include/big_test.inc
3 --source include/master-slave.inc
4 --source include/have_binlog_format_mixed_or_row.inc
5
6 let $max_workers= 4;
7
8 --connection slave
9 SET @save_replica_parallel_workers= @@replica_parallel_workers;
10 SET @save_default_storage_engine=@@global.default_storage_engine;
11 SET @@global.default_storage_engine='innodb';
12
13 eval SET GLOBAL replica_parallel_workers= $max_workers;
14 # As the test case is not going to do any synchronization with the master
15 # before issuing STOP SLAVE in the non-deterministic activity, there is a
16 # chance that the slave applier be in MTS mode and in a condition that it
17 # will throw the following error message:
18 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
19 call mtr.add_suppression("Request to stop replica SQL Thread received while applying a group that has non-transactional changes");
20
21 --source include/stop_slave.inc
22 --source include/start_slave.inc
23
24 --connection master
25 SET @save_default_storage_engine=@@global.default_storage_engine;
26 SET @@global.default_storage_engine='innodb';
27 SET @@session.default_storage_engine='innodb';
28
29 call mtr.add_suppression('.*Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.*');
30
31 let $i= 10;
32 let $slave_status= 0;
33 while ($i) {
34 eval CREATE DATABASE test_$i;
35 eval CREATE TABLE test_$i.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
36 dec $i;
37 }
38 --sync_slave_with_master
39 --connection master
40
41
42 --disable_query_log
43 --disable_warnings
44
45 let $slave_status= 0;
46 let $trx= 0;
47 let $alter= 0;
48 let $i= 200; # with bigger value test times out on some PB hosts
49 --let $small_test=`SELECT @@replica_parallel_type='LOGICAL_CLOCK' OR $VALGRIND_TEST`
50 if ($small_test)
51 {
52 # test may be slow on Valgrind or on MTS SUBMODE = LOGICAL CLOCK
53 let $i=50;
54 }
55 if (`select @@binlog_format like "STATEMENT"`) {
56 # relax mtr to scan unsafe warnings
57 let $i=50;
58 }
59 while ($i) {
60 if (`SELECT 10*RAND() > 8`) {
61 if ($trx) {
62 COMMIT;
63 let $trx= 0;
64 }
65 }
66 if (`SELECT 10*RAND() > 8`) {
67 if (!$trx) {
68 BEGIN;
69 let $trx= 1;
70 }
71 }
72 let $db= `SELECT FLOOR(10*RAND())+1`;
73 let $k= 10;
74 while ($k) {
75 eval INSERT INTO test_$k.t1 VALUES ($i, 'test', NULL, 0);
76 dec $k;
77 }
78 let $k= 10;
79 while ($k) {
80 eval UPDATE test_$k.t1 SET d=a WHERE a = FLOOR(1000*RAND());
81 dec $k;
82 }
83 eval DELETE FROM test_$db.t1 WHERE a = FLOOR(1000*RAND());
84 if (`SELECT 10*RAND() > 5`) {
85 eval UPDATE test_$db.t1 SET c=REPEAT('a', 1000) WHERE a < $i;
86 }
87 if ($trx) {
88 if (`SELECT 10*RAND() > 8`) {
89 let $k= 10;
90 while ($k) {
91
92 # Can't be CREATE .. SELECT here because of BUG#11756034 that allows STOP SLAVE
93 # in the middle of CREATE-SELECT caused group.
94 # TODO: fix the bug and create a use case.
95
96 eval CREATE TABLE test_$k.t0 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
97 eval INSERT INTO test_$k.t0 SELECT * FROM test_$k.t1;
98 dec $k;
99 }
100 let $k= 10;
101 while ($k) {
102 eval DROP TABLE test_$k.t1;
103 dec $k;
104 }
105 let $k= 10;
106 while ($k) {
107 eval RENAME TABLE test_$k.t0 TO test_$k.t1 /* i= $i */;
108 dec $k;
109 }
110 }
111 }
112 if (`SELECT 10*RAND() > 9`) {
113 --connection slave
114 FLUSH LOGS;
115 --connection master
116 }
117 if (`SELECT 100*RAND() > 95`) {
118 if ($slave_status) {
119 --connection slave
120 let $workers= $max_workers;
121 if (`SELECT 10*RAND() > 5`) {
122 let $workers= 0;
123 }
124 eval SET GLOBAL replica_parallel_workers= $workers;
125 START SLAVE;
126 --connection master
127 let $slave_status= 0;
128 }
129 }
130 if (`SELECT 100*RAND() > 95`) {
131 if (!$slave_status)
132 {
133 --connection slave
134 STOP SLAVE;
135 --connection master
136 let $slave_status= 1;
137 }
138 }
139 dec $i;
140 }
141 --enable_warnings
142
143 --enable_query_log
144 --connection slave
145 --disable_warnings
146 --source include/start_slave.inc
147 --enable_warnings
148
149 #cleanup
150
151 --connection master
152 let $i= 10;
153 while ($i) {
154 eval DROP DATABASE test_$i;
155 dec $i;
156 }
157
158 SET @@global.default_storage_engine= @save_default_storage_engine;
159
160 --connection slave
161 SET @@global.default_storage_engine= @save_default_storage_engine;
162 --disable_warnings
163 SET GLOBAL replica_parallel_workers= @save_replica_parallel_workers;
164 --enable_warnings
165
166 # It may generate a big delay between master and slave, that will need more time
167 # to sync data
168
169 --let slave-timeout= 3600
170 --source include/rpl_end.inc