diff options
Diffstat (limited to 'mysql-test/t/rpl_log_pos.test')
-rw-r--r-- | mysql-test/t/rpl_log_pos.test | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_log_pos.test b/mysql-test/t/rpl_log_pos.test new file mode 100644 index 00000000000..cce52dc5daa --- /dev/null +++ b/mysql-test/t/rpl_log_pos.test @@ -0,0 +1,42 @@ +# +# 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 3306 MASTER_PORT 9306 MASTER_PORT 3334 MASTER_PORT 3336 MASTER_PORT +show slave status; +change master to master_log_pos=73; +slave stop; + +change master to master_log_pos=73; +--replace_result 3306 MASTER_PORT 9306 MASTER_PORT 3334 MASTER_PORT 3336 MASTER_PORT +show slave status; +slave start; +sleep 2; +--replace_result 3306 MASTER_PORT 9306 MASTER_PORT 3334 MASTER_PORT 3336 MASTER_PORT +show slave status; +change master to master_log_pos=173; +--replace_result 3306 MASTER_PORT 9306 MASTER_PORT 3334 MASTER_PORT 3336 MASTER_PORT +slave start; +sleep 2; +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; +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; |