Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_until.test

raw
1 -- source include/have_binlog_format_row.inc
2 -- source include/master-slave.inc
3
4 ##############################################################################
5 # The test is dependent on binlog positions. The test is divided into two
6 # sections. The first section checks START SLAVE UNTIL MASTER_LOG_FILE =
7 # 'log_name', MASTER_LOG_POS = log_pos followed by a couple of failure
8 # scenarios. The second section checks START SLAVE UNTIL RELAY_LOG_FILE =
9 # 'log_name', RELAY_LOG_POS = log_pos.
10 ##############################################################################
11
12 # Create some events on master
13 connection master;
14 CREATE TABLE t1(n INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
15 INSERT INTO t1 VALUES (1),(2),(3),(4);
16 # Save master log position for query DROP TABLE t1
17 let $master_pos_drop_t1= query_get_value(SHOW MASTER STATUS, Position, 1);
18 DROP TABLE t1;
19 # Save master log position for query DROP TABLE t1
20 save_master_pos;
21 #let $master_pos_drop_t1= query_get_value(SHOW BINLOG EVENTS, Pos, 10);
22 let $master_log_file= query_get_value(SHOW BINLOG EVENTS, Log_name, 10);
23
24 # Save master log position for query CREATE TABLE t2
25 let $master_pos_create_t2= query_get_value(SHOW MASTER STATUS, Position, 1);
26 CREATE TABLE t2(n INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
27 #show binlog events;
28
29 INSERT INTO t2 VALUES (1),(2);
30 # Save master log position for query INSERT INTO t2 VALUES (1),(2);
31 let $master_pos_insert1_t2= query_get_value(SHOW MASTER STATUS, Position, 1);
32 INSERT INTO t2 VALUES (3),(4);
33 DROP TABLE t2;
34 # Save master log position for query DROP TABLE t2;
35 let $master_pos_drop_t2= query_get_value(SHOW MASTER STATUS, Position, 1);
36 sync_slave_with_master;
37 #show binlog events;
38
39 --source include/stop_slave.inc
40 # Reset slave.
41 --source include/reset_slave.inc
42 --replace_result $MASTER_MYPORT MASTER_MYPORT
43 eval CHANGE MASTER TO MASTER_USER='root', MASTER_CONNECT_RETRY=1, MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT;
44
45 # Try to replicate all queries until drop of t1
46
47 connection slave;
48 --replace_result $master_pos_drop_t1 master_pos_drop_t1
49 eval START SLAVE UNTIL MASTER_LOG_FILE='$master_log_file', MASTER_LOG_POS=$master_pos_drop_t1;
50 --source include/wait_for_slave_sql_to_stop.inc
51
52 # Here table should be still not deleted
53 SELECT * FROM t1;
54 --let $slave_param= Exec_Master_Log_Pos
55 --let $slave_param_value= $master_pos_drop_t1
56 --source include/check_slave_param.inc
57
58 # This should fail right after start
59 START SLAVE UNTIL MASTER_LOG_FILE='master-no-such-bin.000001', MASTER_LOG_POS=291;
60 --source include/wait_for_slave_sql_to_stop.inc
61 # again this table should be still not deleted
62 SELECT * FROM t1;
63
64 --let $slave_param= Exec_Master_Log_Pos
65 --let $slave_param_value= $master_pos_drop_t1
66 --source include/check_slave_param.inc
67
68 # clean up
69 START SLAVE;
70 --source include/wait_for_slave_to_start.inc
71 connection master;
72 sync_slave_with_master;
73 --source include/stop_slave.inc
74
75 # This should stop immediately as we are already there
76 --replace_result $master_pos_create_t2 master_pos_create_t2
77 eval START SLAVE SQL_THREAD UNTIL MASTER_LOG_FILE='$master_log_file', MASTER_LOG_POS=$master_pos_create_t2;
78 let $slave_param= Until_Log_Pos;
79 let $slave_param_value= $master_pos_create_t2;
80 --source include/wait_for_slave_param.inc
81 --source include/wait_for_slave_sql_to_stop.inc
82 # here the sql slave thread should be stopped
83 --let $slave_param= Exec_Master_Log_Pos
84 --let $slave_param_value= $master_pos_drop_t2
85 --source include/check_slave_param.inc
86
87 #testing various error conditions
88 --replace_result 561 MASTER_LOG_POS
89 --error 1277
90 START SLAVE UNTIL MASTER_LOG_FILE='master-bin', MASTER_LOG_POS=561;
91 --replace_result 561 MASTER_LOG_POS 12 RELAY_LOG_POS
92 --error 1277
93 START SLAVE UNTIL MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=561, RELAY_LOG_POS=12;
94 --error 1277
95 START SLAVE UNTIL MASTER_LOG_FILE='master-bin.000001';
96 --error 1277
97 START SLAVE UNTIL RELAY_LOG_FILE='slave-relay-bin.000009';
98 --replace_result 561 MASTER_LOG_POS
99 --error 1277
100 START SLAVE UNTIL RELAY_LOG_FILE='slave-relay-bin.000002', MASTER_LOG_POS=561;
101 --replace_result 740 MASTER_LOG_POS
102 START SLAVE UNTIL MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=740;
103
104 # Explicit wait for slave thread start and then stop. Otherwise the STOP SLAVE
105 # command can abort the slave connecting to the master, and an error state
106 # left which makes stop_slave.inc throw an error.
107 --source include/wait_for_slave_io_to_start.inc
108 --source include/wait_for_slave_sql_to_stop.inc
109 --source include/stop_slave_io.inc
110 --source include/reset_slave.inc
111 --source include/start_slave.inc
112
113 ##############################################################################
114 # The second section - checks START SLAVE UNTIL RELAY_LOG_FILE =# 'log_name',
115 # RELAY_LOG_POS = log_pos. This section of the test does the following:
116 # 1) At master, create a table and inserts a value. Let slave replicate this.
117 # 2) Stop slave sql thread.
118 # 3) Insert some more values at master. Note that io thread copies this insert
119 # 4) Use start slave until to start the sql thread and check if it
120 # stops at the correct position.
121 ##############################################################################
122
123 --source include/rpl_reset.inc
124
125 --connection master
126 CREATE TABLE t1 (a INT);
127 INSERT INTO t1 VALUES (1);
128
129 --sync_slave_with_master
130 --source include/stop_slave_sql.inc
131
132 --connection master
133 INSERT INTO t1 VALUES (2);
134 --let $master_log_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
135 INSERT INTO t1 VALUES (3);
136
137 --source include/sync_slave_io_with_master.inc
138
139 --let $relay_log_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File,1)
140 --source include/get_relay_log_pos.inc
141
142 --replace_result $relay_log_pos relay_log_pos
143 --eval start slave until relay_log_file='$relay_log_file', relay_log_pos=$relay_log_pos
144 --source include/wait_for_slave_sql_to_stop.inc
145
146 --let $assert_cond= COUNT(*) = 2 FROM t1
147 --let $assert_text= table t1 should have two rows.
148 --source include/assert.inc
149
150 #cleanup
151 --source include/start_slave.inc
152 --connection master
153 DROP TABLE t1;
154 --sync_slave_with_master
155 --source include/rpl_end.inc