diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_sync.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_sync.result | 25 |
1 files changed, 12 insertions, 13 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_sync.result b/mysql-test/suite/rpl/r/rpl_sync.result index edc20c46140..de3506465aa 100644 --- a/mysql-test/suite/rpl/r/rpl_sync.result +++ b/mysql-test/suite/rpl/r/rpl_sync.result @@ -1,10 +1,6 @@ =====Configuring the enviroment=======; -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; +include/master-slave.inc +[connection master] call mtr.add_suppression('Attempting backtrace'); call mtr.add_suppression("Recovery from master pos .* and file master-bin.000001"); CREATE TABLE t1(a INT, PRIMARY KEY(a)) engine=innodb; @@ -12,20 +8,21 @@ insert into t1(a) values(1); insert into t1(a) values(2); insert into t1(a) values(3); =====Inserting data on the master but without the SQL Thread being running=======; -stop slave SQL_THREAD; +include/stop_slave_sql.inc insert into t1(a) values(4); insert into t1(a) values(5); insert into t1(a) values(6); =====Removing relay log files and crashing/recoverying the slave=======; -stop slave IO_THREAD; +include/stop_slave_io.inc SET SESSION debug="d,crash_before_rotate_relaylog"; FLUSH LOGS; ERROR HY000: Lost connection to MySQL server during query +include/rpl_reconnect.inc =====Dumping and comparing tables=======; -start slave; -Comparing tables master:test.t1 and slave:test.t1 +include/start_slave.inc +include/diff_tables.inc [master:t1,slave:t1] =====Corrupting the master.info=======; -stop slave; +include/stop_slave.inc FLUSH LOGS; insert into t1(a) values(7); insert into t1(a) values(8); @@ -33,8 +30,10 @@ insert into t1(a) values(9); SET SESSION debug="d,crash_before_rotate_relaylog"; FLUSH LOGS; ERROR HY000: Lost connection to MySQL server during query +include/rpl_reconnect.inc =====Dumping and comparing tables=======; -start slave; -Comparing tables master:test.t1 and slave:test.t1 +include/start_slave.inc +include/diff_tables.inc [master:t1,slave:t1] =====Clean up=======; drop table t1; +include/rpl_end.inc |