118
118
SELECT * FROM t2;
123
Master_Host 127.0.0.1
127
Master_Log_File master-bin.000001
128
Read_Master_Log_Pos #
131
Relay_Master_Log_File master-bin.000001
133
Slave_SQL_Running Yes
137
Replicate_Ignore_Table
138
Replicate_Wild_Do_Table
139
Replicate_Wild_Ignore_Table
141
Last_Error <Last_Error>
143
Exec_Master_Log_Pos #
148
Master_SSL_Allowed No
154
Seconds_Behind_Master #
155
Master_SSL_Verify_Server_Cert No
156
Last_IO_Errno <Last_IO_Errno>
157
Last_IO_Error <Last_IO_Error>
159
Last_SQL_Error <Last_SQL_Error>
121
Checking that both slave threads are running.
160
122
INSERT INTO t9 VALUES (4);
161
123
INSERT INTO t4 VALUES (4);
164
Master_Host 127.0.0.1
168
Master_Log_File master-bin.000001
169
Read_Master_Log_Pos #
172
Relay_Master_Log_File master-bin.000001
178
Replicate_Ignore_Table
179
Replicate_Wild_Do_Table
180
Replicate_Wild_Ignore_Table
182
Last_Error <Last_Error>
184
Exec_Master_Log_Pos #
189
Master_SSL_Allowed No
195
Seconds_Behind_Master #
196
Master_SSL_Verify_Server_Cert No
197
Last_IO_Errno <Last_IO_Errno>
198
Last_IO_Error <Last_IO_Error>
200
Last_SQL_Error <Last_SQL_Error>
201
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
124
--source include/wait_for_slave_sql_error_and_skip.inc
125
Last_SQL_Error = Table definition on master and slave does not match: Column 0 type mismatch - received type 3, test.t4 has type 4
126
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
127
include/start_slave.inc
203
128
INSERT INTO t9 VALUES (5);
204
129
INSERT INTO t5 VALUES (5,10,25);
207
Master_Host 127.0.0.1
211
Master_Log_File master-bin.000001
212
Read_Master_Log_Pos #
215
Relay_Master_Log_File master-bin.000001
221
Replicate_Ignore_Table
222
Replicate_Wild_Do_Table
223
Replicate_Wild_Ignore_Table
225
Last_Error <Last_Error>
227
Exec_Master_Log_Pos #
232
Master_SSL_Allowed No
238
Seconds_Behind_Master #
239
Master_SSL_Verify_Server_Cert No
240
Last_IO_Errno <Last_IO_Errno>
241
Last_IO_Error <Last_IO_Error>
243
Last_SQL_Error <Last_SQL_Error>
244
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
130
--source include/wait_for_slave_sql_error_and_skip.inc
131
Last_SQL_Error = Table definition on master and slave does not match: Column 1 type mismatch - received type 3, test.t5 has type 4
132
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
133
include/start_slave.inc
246
134
INSERT INTO t9 VALUES (6);
247
135
INSERT INTO t6 VALUES (6,12,36);
250
Master_Host 127.0.0.1
254
Master_Log_File master-bin.000001
255
Read_Master_Log_Pos #
258
Relay_Master_Log_File master-bin.000001
264
Replicate_Ignore_Table
265
Replicate_Wild_Do_Table
266
Replicate_Wild_Ignore_Table
268
Last_Error <Last_Error>
270
Exec_Master_Log_Pos #
275
Master_SSL_Allowed No
281
Seconds_Behind_Master #
282
Master_SSL_Verify_Server_Cert No
283
Last_IO_Errno <Last_IO_Errno>
284
Last_IO_Error <Last_IO_Error>
286
Last_SQL_Error <Last_SQL_Error>
287
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
136
--source include/wait_for_slave_sql_error_and_skip.inc
137
Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 3, test.t6 has type 4
138
SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;
139
include/start_slave.inc
289
140
INSERT INTO t9 VALUES (6);
292
Master_Host 127.0.0.1
296
Master_Log_File master-bin.000001
297
Read_Master_Log_Pos #
300
Relay_Master_Log_File master-bin.000001
302
Slave_SQL_Running Yes
306
Replicate_Ignore_Table
307
Replicate_Wild_Do_Table
308
Replicate_Wild_Ignore_Table
310
Last_Error <Last_Error>
312
Exec_Master_Log_Pos #
317
Master_SSL_Allowed No
323
Seconds_Behind_Master #
324
Master_SSL_Verify_Server_Cert No
325
Last_IO_Errno <Last_IO_Errno>
326
Last_IO_Error <Last_IO_Error>
328
Last_SQL_Error <Last_SQL_Error>
141
Checking that both slave threads are running.
329
142
INSERT INTO t7 VALUES (1),(2),(3);
330
143
INSERT INTO t8 VALUES (1),(2),(3);
331
144
SELECT * FROM t7 ORDER BY a;