Debian Codegraph @

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

raw
1 # test to see if replication can continue when master sporadically fails on
2 # COM_BINLOG_DUMP and additionally limits the number of events per dump
3
4 source include/master-slave.inc;
5
6 create table t2(n int);
7 create table t1(n int not null auto_increment primary key);
8 insert into t1 values (NULL),(NULL);
9 truncate table t1;
10 # We have to use 4 in the following to make this test work with all table types
11 insert into t1 values (4),(NULL);
12 --source include/sync_slave_sql_with_master.inc
13 --source include/stop_slave.inc
14 --source include/start_slave.inc
15 connection master;
16 insert into t1 values (NULL),(NULL);
17 flush logs;
18 truncate table t1;
19 insert into t1 values (10),(NULL),(NULL),(NULL),(NULL),(NULL);
20 --source include/sync_slave_sql_with_master.inc
21 select * from t1 ORDER BY n;
22 connection master;
23 drop table t1,t2;
24 --source include/sync_slave_sql_with_master.inc
25
26 --source include/rpl_end.inc