diff options
Diffstat (limited to 'mysql-test/r/rpl000016.result')
| -rw-r--r-- | mysql-test/r/rpl000016.result | 58 |
1 files changed, 51 insertions, 7 deletions
diff --git a/mysql-test/r/rpl000016.result b/mysql-test/r/rpl000016.result index 1390291f1e8..6a91309c29c 100644 --- a/mysql-test/r/rpl000016.result +++ b/mysql-test/r/rpl000016.result @@ -1,30 +1,74 @@ -Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter -127.0.0.1 root 9999 60 master-bin.001 216 Yes 0 0 +slave start; +Could not initialize master info structure, check permisions on master.info +slave start; +Could not initialize master info structure, check permisions on master.info +change master to master_host='127.0.0.1',master_port=MASTER_PORT, +master_user='root'; +Could not initialize master info +reset slave; +change master to master_host='127.0.0.1',master_port=MASTER_PORT, +master_user='root'; +reset master; +slave start; +drop table if exists t1; +create table t1 (s text); +insert into t1 values('Could not break slave'),('Tried hard'); +show slave status; +Master_Host Master_User Master_Port Connect_retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Exec_master_log_pos +127.0.0.1 root MASTER_PORT 60 master-bin.001 234 slave-relay-bin.001 275 master-bin.001 Yes Yes 0 0 234 +select * from t1; s Could not break slave Tried hard +flush logs; +drop table if exists t2; +create table t2(m int not null auto_increment primary key); +insert into t2 values (34),(67),(123); +flush logs; +show master logs; Log_name master-bin.001 master-bin.002 master-bin.003 +insert into t2 values(1234); +set insert_id=1234; +insert into t2 values(NULL); +set sql_slave_skip_counter=1; +slave start; +purge master logs to 'master-bin.003'; +show master logs; Log_name master-bin.003 -Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter -127.0.0.1 root 9999 60 master-bin.003 206 Yes 0 0 +insert into t2 values (65); +show slave status; +Master_Host Master_User Master_Port Connect_retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Exec_master_log_pos +127.0.0.1 root MASTER_PORT 60 master-bin.003 155 slave-relay-bin.001 755 master-bin.003 Yes Yes 0 0 155 +select * from t2; m 34 65 67 123 1234 +drop table if exists t3; +create table t3 (n int); +show master logs; Log_name master-bin.003 master-bin.004 master-bin.005 master-bin.006 +show master status; File Position Binlog_do_db Binlog_ignore_db -master-bin.006 131 -Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter -127.0.0.1 root 9999 60 master-bin.006 131 Yes 0 0 +master-bin.006 445 +slave stop; +slave start; +show slave status; +Master_Host Master_User Master_Port Connect_retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Exec_master_log_pos +127.0.0.1 root MASTER_PORT 60 master-bin.006 445 slave-relay-bin.004 1229 master-bin.006 Yes Yes 0 0 445 +lock tables t3 read; +select count(*) from t3 where n >= 4; count(*) 100 +unlock tables; +drop table if exists t1,t2,t3; |