# # Testing of setting slave to wrong log position with master_log_pos # source include/master-slave.inc; show master status; save_master_pos; connection slave; sync_with_master; --replace_result $MASTER_MYPORT MASTER_PORT show slave status; slave stop; change master to master_log_pos=73; slave start; sleep 5; slave stop; change master to master_log_pos=73; --replace_result $MASTER_MYPORT MASTER_PORT show slave status; slave start; sleep 5; --replace_result $MASTER_MYPORT MASTER_PORT show slave status; slave stop; change master to master_log_pos=173; slave start; sleep 2; --replace_result $MASTER_MYPORT MASTER_PORT show slave status; connection master; show master status; create table if not exists t1 (n int); drop table if exists t1; create table t1 (n int); insert into t1 values (1),(2),(3); save_master_pos; connection slave; slave stop; change master to master_log_pos=79; slave start; sync_with_master; select * from t1; connection master; drop table t1; save_master_pos; connection slave; sync_with_master;