← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/rpl_change_master.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/rpl_change_master.test
18
18
connection slave;
19
19
--real_sleep 3 # wait for I/O thread to have read updates
20
20
stop slave;
21
 
source include/wait_for_slave_to_stop.inc;
22
 
 
23
 
let $read_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
24
 
let $exec_pos= query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1);
25
 
if (`SELECT $read_pos = $exec_pos`)
26
 
{
27
 
  source include/show_rpl_debug_info.inc;
28
 
  echo 'Read_Master_Log_Pos: $read_pos' == 'Exec_Master_Log_Pos: $exec_pos';
29
 
  die Failed because Read_Master_Log_Pos is equal to Exec_Master_Log_Pos;
30
 
} 
 
21
--replace_result $MASTER_MYPORT MASTER_MYPORT
 
22
--replace_column 1 # 7 # 8 # 9 # 23 # 33 #
 
23
show slave status;
31
24
change master to master_user='root';
32
 
let $read_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1);
33
 
let $exec_pos= query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1);
34
 
if (`SELECT $read_pos <> $exec_pos`)
35
 
{
36
 
  source include/show_rpl_debug_info.inc;
37
 
  echo 'Read_Master_Log_Pos: $read_pos' <> 'Exec_Master_Log_Pos: $exec_pos';
38
 
  die Failed because Read_Master_Log_Pos is not equal to Exec_Master_Log_Pos;
39
 
}
40
 
 
 
25
--replace_result $MASTER_MYPORT MASTER_MYPORT
 
26
--replace_column 1 # 7 # 8 # 9 # 23 # 33 #
 
27
show slave status;
41
28
start slave;
42
29
sync_with_master;
43
30
select * from t1;