Debian Codegraph @

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

raw
1 ##########
2 # Change Author: JBM
3 # Change Date: 2006-01-16
4 # Change: Added Order by for NDB
5 ##########
6
7 #
8 # Testing of setting slave to wrong log position with master_log_pos
9 #
10
11 # Passes with rbr no problem, removed statement include [jbm]
12
13 --source include/not_group_replication_plugin.inc
14 source include/master-slave.inc;
15 call mtr.add_suppression ("Replica I/O for channel '': Got fatal error 1236 from source when reading data from binary");
16 source include/show_master_status.inc;
17 --source include/sync_slave_sql_with_master.inc
18 source include/stop_slave.inc;
19
20 --replace_result 75 MASTER_LOG_POS
21 CHANGE REPLICATION SOURCE to SOURCE_LOG_POS=75;
22 let $status_items= Read_Master_Log_Pos;
23 source include/show_slave_status.inc;
24 start slave;
25 let $slave_io_errno= 13114;
26 --let $show_slave_io_error= 1
27 # Mask line numbers
28 --let $slave_io_error_replace= / at [0-9]*/ at XXX/
29 source include/wait_for_slave_io_error.inc;
30 source include/stop_slave_sql.inc;
31
32 connection master;
33 source include/show_master_status.inc;
34 create table if not exists t1 (n int);
35 drop table if exists t1;
36 create table t1 (n int);
37 insert into t1 values (1),(2),(3);
38 save_master_pos;
39 connection slave;
40 --replace_result 4 MASTER_LOG_POS
41 CHANGE REPLICATION SOURCE to SOURCE_LOG_POS=4;
42 start slave;
43 sync_with_master;
44 select * from t1 ORDER BY n;
45 connection master;
46 drop table t1;
47 --source include/sync_slave_sql_with_master.inc
48
49 --echo End of 5.0 tests
50 --source include/rpl_end.inc