Debian Codegraph @

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

raw
1 # The motive of this test case is to test the
2 # mts submode switch between master parallel to dbname and vice-versa
3
4 -- source include/have_debug.inc
5 -- source include/master-slave.inc
6 -- source include/force_myisam_default.inc
7 -- source include/have_myisam.inc
8 -- source include/only_mts_replica_parallel_workers.inc
9 call mtr.add_suppression("Statement is unsafe because it uses a system function that may return a different value on the replica");
10 -- sync_slave_with_master
11 -- connection master
12 -- let $saved_debug=`SELECT @@global.DEBUG`
13 # Simulate grouping on the master
14 SET GLOBAL DEBUG ='+d,set_commit_parent_100';
15 -- connection slave
16
17 # Save MTS submode
18 -- let $saved_submode= `SELECT @@replica_parallel_type`
19
20 # must error out since the slave is running
21 -- error ER_REPLICA_SQL_THREAD_MUST_STOP
22 SET GLOBAL replica_parallel_type=LOGICAL_CLOCK;
23
24 -- source include/stop_slave.inc
25
26 # Setup 4 connections to master
27 -- connect(m1, localhost,root,,,$MASTER_MYPORT)
28 -- connect(m2, localhost,root,,,$MASTER_MYPORT)
29 -- connect(m3, localhost,root,,,$MASTER_MYPORT)
30 -- connect(m4, localhost,root,,,$MASTER_MYPORT)
31
32 -- connection master
33 FLUSH LOGS; # New group of transactions will be logged.
34
35 create database db1;
36 create database db2;
37 create database db3;
38 create database db4;
39
40 -- connection master
41 FLUSH LOGS; # New group of transactions will be logged.
42
43 -- echo #setup the databases and tables
44 -- connection m1
45 CREATE TABLE db1.t (a int) engine=innodb;
46 CREATE TEMPORARY TABLE db1.t_temp (a int) engine=innodb;
47
48 -- connection m2
49 CREATE TABLE db2.t (a int) engine=myisam;
50 CREATE TEMPORARY TABLE db2.t_temp (a int) engine=innodb;
51
52 # CREATE-SELECT is logged as two consecutive groups with ROW format,
53 # common commit parent can't be simulated.
54 SET GLOBAL DEBUG ='-d,set_commit_parent_100';
55 --connection m3
56 --disable_warnings ER_BINLOG_UNSAFE_STATEMENT ONCE
57 CREATE TABLE db3.t engine=innodb select 100*RAND() as a;
58 CREATE TEMPORARY TABLE db3.t_temp (a int) engine=innodb;
59
60 -- connection m4
61 SET @VAR=100;
62
63 CREATE TABLE db4.t engine=myisam select @VAR as a;
64 CREATE TEMPORARY TABLE db4.t_temp (a int) engine=innodb;
65
66 SET GLOBAL DEBUG ='+d,set_commit_parent_100';
67 -- connection master
68 FLUSH LOGS; # New group of transactions will be logged.
69
70 #this is just to make sure that the slave does not error out due to this
71 #random value.
72 TRUNCATE db3.t;
73
74 -- connection master
75 FLUSH LOGS; # New group of transactions will be logged.
76
77 # NON TRANSACTIONAL
78 -- connection m2
79 INSERT INTO db2.t values (1),(2),(3);
80 -- connection m4
81 INSERT INTO db4.t values (1),(2),(3);
82
83 # Start a new group.
84 # Flush log creates a new binlog which means that we can check that:
85 # 1. A fresh group is started since we will encounter a "real" ROTATE event
86 # 2. Query on connection m2 have released its temp tables so that the
87 # corresponding query on m3 should not fail on slave.
88
89 FLUSH LOGS;
90
91 # temp tables operations
92 -- connection m1
93 INSERT INTO db1.t_temp values (1),(2),(3);
94
95 -- connection m2
96 INSERT INTO db2.t_temp values (1),(2),(3);
97
98 -- connection m3
99 INSERT INTO db3.t_temp values (1),(2),(3);
100
101 -- connection m4
102 INSERT INTO db4.t_temp values (1),(2),(3);
103
104 -- connection master
105 FLUSH LOGS; # New group of transactions will be logged.
106
107 #TRANSACTIONAL
108 -- connection m1
109 BEGIN;
110 INSERT INTO db1.t values (1),(2),(3);
111 INSERT INTO db1.t values (1),(2),(3);
112 UPDATE db1.t SET db1.t.a= 2 WHERE db1.t.a > 2;
113 COMMIT;
114
115 -- connection m3
116 BEGIN;
117 INSERT INTO db3.t values (1),(2),(3);
118 INSERT INTO db3.t values (1),(2),(3);
119 UPDATE db3.t SET db3.t.a= 2 WHERE db3.t.a > 2;
120 COMMIT;
121
122 -- connection master
123 FLUSH LOGS; # New group of transactions will be logged.
124
125 #BOTH TRANSACTIONAL AND NON TRANSACTIONAL
126 -- connection m2
127 BEGIN;
128 INSERT INTO db2.t values (1),(2),(3);
129 INSERT INTO db3.t values (1),(2),(3);
130 UPDATE db3.t SET db3.t.a= 2 WHERE db3.t.a > 2;
131 COMMIT;
132
133 -- connection m4
134 BEGIN;
135 INSERT INTO db1.t values (1),(2),(3);
136 INSERT INTO db4.t values (1),(2),(3);
137 UPDATE db1.t SET db1.t.a= 2 WHERE db1.t.a > 2;
138 COMMIT;
139
140 SET GLOBAL DEBUG ='-d,set_commit_parent_100';
141 # temp tables operations DELETE
142 -- connection m1
143 DROP TABLE db1.t_temp;
144
145 -- connection m2
146 DROP TABLE db2.t_temp;
147
148 -- connection m3
149 DROP TABLE db3.t_temp;
150
151 -- connection m4
152 DROP TABLE db4.t_temp;
153
154
155 -- disconnect m1
156 -- disconnect m2
157 -- disconnect m3
158 -- disconnect m4
159
160 -- connection slave
161
162 # DEFAULT ========> DATABASE
163 SET GLOBAL replica_parallel_type='DATABASE';
164 -- source include/start_slave.inc
165 -- connection master
166 -- source include/sync_slave_sql_with_master.inc
167 -- let diff_tables= master:db1.t,slave:db1.t
168 -- source include/diff_tables.inc
169 -- let diff_tables= master:db2.t, slave:db2.t
170 -- source include/diff_tables.inc
171 -- let diff_tables= master:db3.t, slave:db3.t
172 -- source include/diff_tables.inc
173 -- let diff_tables= master:db4.t, slave:db4.t
174 -- source include/diff_tables.inc
175 -- source include/stop_slave.inc
176 RESET SLAVE;
177 DROP DATABASE db1;
178 DROP DATABASE db2;
179 DROP DATABASE db3;
180 DROP DATABASE db4;
181
182 # DATABASE ==========> LOGICAL_CLOCK
183 SET GLOBAL replica_parallel_type='LOGICAL_CLOCK';
184 -- source include/start_slave.inc
185 -- connection master
186 -- source include/sync_slave_sql_with_master.inc
187 -- let diff_tables= master:db1.t, slave:db1.t
188 -- source include/diff_tables.inc
189 -- let diff_tables= master:db2.t, slave:db2.t
190 -- source include/diff_tables.inc
191 -- let diff_tables= master:db3.t, slave:db3.t
192 -- source include/diff_tables.inc
193 -- let diff_tables= master:db4.t, slave:db4.t
194 -- source include/diff_tables.inc
195 -- source include/stop_slave.inc
196 RESET SLAVE;
197 DROP DATABASE db1;
198 DROP DATABASE db2;
199 DROP DATABASE db3;
200 DROP DATABASE db4;
201
202 # LOGICAL_CLOCK ==========> DATABASE
203 SET GLOBAL replica_parallel_type='DATABASE';
204 -- source include/start_slave.inc
205 -- connection master
206 -- source include/sync_slave_sql_with_master.inc
207 -- let diff_tables= master:db1.t, slave:db1.t
208 -- source include/diff_tables.inc
209 -- let diff_tables= master:db2.t, slave:db2.t
210 -- source include/diff_tables.inc
211 -- let diff_tables= master:db3.t, slave:db3.t
212 -- source include/diff_tables.inc
213 -- let diff_tables= master:db4.t, slave:db4.t
214 -- source include/diff_tables.inc
215
216 -- source include/stop_slave.inc
217 SET GLOBAL REPLICA_PARALLEL_TYPE=DEFAULT;
218 -- source include/start_slave.inc
219
220 #clean up
221 -- connection master
222 DROP DATABASE db1;
223 DROP DATABASE db2;
224 DROP DATABASE db3;
225 DROP DATABASE db4;
226 -- sync_slave_with_master
227
228 -- connection slave
229
230 # temporary fix until BUG#16580366 is fixed.
231 # wait till we have dropped all temp tables.
232 -- let $status_var_comparsion= =
233 -- let $status_var= replica_open_temp_tables
234 -- let $status_var_value= 0
235 -- source include/wait_for_status_var.inc
236
237 -- source include/stop_slave.inc
238
239 -- disable_query_log
240 -- disable_result_log
241 -- eval SET GLOBAL replica_parallel_type= '$saved_submode'
242 -- source include/start_slave.inc
243
244 -- connection master
245 -- eval SET GLOBAL DEBUG='$saved_debug'
246 -- enable_query_log
247 -- enable_result_log
248
249 -- source include/rpl_end.inc
250