← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/t/rpl_flushlog_loop.test

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/t/rpl_flushlog_loop.test
36
36
# 2. Insert into t1 on slave (2nd) when the event (1st) for t1 replicated.
37
37
# 3. Master waits until the event (2nd) for t1 will be replicated.
38
38
 
39
 
--disable_query_log
40
39
CREATE TABLE t1 (a INT KEY) ENGINE= MyISAM;
41
40
let $wait_binlog_event= CREATE TABLE t1;
42
41
--source include/wait_for_binlog_event.inc
44
43
 
45
44
connection master;
46
45
INSERT INTO t1 VALUE(1);
47
 
--enable_query_log
48
46
FLUSH LOGS;
49
 
let $slave_param_value= query_get_value(SHOW MASTER STATUS, Position, 1);
50
 
 
51
 
connection slave;
52
 
let $slave_param= Exec_Master_Log_Pos;
53
 
source include/wait_for_slave_param.inc;
54
 
 
55
 
--disable_query_log
 
47
sync_slave_with_master;
 
48
 
56
49
INSERT INTO t1 VALUE(2);
57
50
let $slave_param_value= query_get_value(SHOW MASTER STATUS, Position, 1);
58
 
--enable_query_log
59
 
 
60
 
connection master;
61
 
let $slave_param= Exec_Master_Log_Pos;
62
 
source include/wait_for_slave_param.inc;
63
 
 
64
 
--enable_query_log
65
 
 
66
 
#
67
 
#  Show status of slave
68
 
#
69
 
--replace_result $SLAVE_MYPORT SLAVE_PORT $slave_param_value POSITION
70
 
--replace_column 1 # 8 # 9 # 16 # 23 # 33 # 34 # 35 #
71
 
--query_vertical SHOW SLAVE STATUS
 
51
sync_slave_with_master master;
 
52
 
 
53
#
 
54
# Check that the master server's slave threads are still running and show
 
55
# Relay_Log_File
 
56
#
 
57
--source include/check_slave_is_running.inc
 
58
--let status_items= Relay_Log_File
 
59
--source include/show_slave_status.inc
72
60
 
73
61
--disable_query_log
74
62
connection master;