Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_relay_log_recovery_positions.test

raw
1 #
2 # Test case for BUG#74089 scenario
3 #
4 --source include/force_restart.inc
5 --source include/have_binlog_format_statement.inc
6 --source include/master-slave.inc
7 --source include/rpl_connection_slave.inc
8
9 # Test starts here
10 --source include/rpl_reset.inc
11 --source include/rpl_connection_master.inc
12 --let $prefix= `SELECT UUID()`
13 --let $slave_error_log= $MYSQLTEST_VARDIR/tmp/$prefix.err
14
15 CREATE TABLE t1 (c1 INT);
16
17 --source include/sync_slave_sql_with_master.inc
18 CALL mtr.add_suppression("Recovery from source pos");
19
20 # stop the slave applier thread
21 --source include/stop_slave_sql.inc
22
23 --let $relay_log= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1)
24
25 --source include/rpl_connection_master.inc
26
27 INSERT INTO t1 VALUES (1);
28
29 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
30
31 # make sure that the slave copies everything, but does not apply
32 # this last insert statement
33 --source include/sync_slave_io_with_master.inc
34
35 # Verify that the positions are the ones we expect at this
36 # point in time (read all the binary log, applied just the
37 # create table).
38
39 --let $begin_of_insert_trx_pos_in_rl= query_get_value(SHOW RELAYLOG EVENTS in '$relay_log', Pos, 8)
40 --let $create_tbl_stmt_trx_pos_in_bl= query_get_value(SHOW RELAYLOG EVENTS in '$relay_log', End_log_pos, 7)
41 --let $end_of_insert_trx_log_pos_in_rl= query_get_value(SHOW RELAYLOG EVENTS in '$relay_log', End_log_pos, 11)
42
43 --let $exec_master_log_pos= query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1)
44 --let $read_master_log_pos= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1)
45 --let $relay_log_pos= query_get_value(SHOW SLAVE STATUS, Relay_Log_Pos, 1)
46
47 --let $assert_cond= $begin_of_insert_trx_pos_in_rl = $relay_log_pos
48 --let $assert_text= "Relay_log_pos points at the beginning of the INSERT trx."
49 --source include/assert.inc
50
51 --let $assert_cond= $create_tbl_stmt_trx_pos_in_bl = $exec_master_log_pos
52 --let $assert_text= "Exec_master_log_pos points at the CREATE TABLE statement."
53 --source include/assert.inc
54
55 --let $assert_cond= $end_of_insert_trx_log_pos_in_rl = $read_master_log_pos
56 --let $assert_text= "Read_master_log_pos points at the end of the INSERT trx."
57 --source include/assert.inc
58
59 #
60 # Restart the server with relay-log-recovery set - this will reset the positions
61 --let $rpl_server_parameters= --relay-log-recovery=1 --skip-replica-start --log_error=$slave_error_log --no-console
62 --let $rpl_omit_print_server_parameters= 1
63 --echo Omitting server parameters, since there is a path in one of them.
64 --source include/rpl_restart_server.inc
65
66 --let $exec_master_log_pos_restart= query_get_value(SHOW SLAVE STATUS, Exec_Master_Log_Pos, 1)
67 --let $read_master_log_pos_restart= query_get_value(SHOW SLAVE STATUS, Read_Master_Log_Pos, 1)
68 --let $relay_log_pos_restart= query_get_value(SHOW SLAVE STATUS, Relay_Log_Pos, 1)
69
70 # Assert that the entry in the log contains the old relay log positions as well
71 --let $assert_text= Assert that the expected entry is in the error log
72 --let $assert_file= $slave_error_log
73 --let $assert_select= Recovery from source pos $exec_master_log_pos and file $binlog_file for channel ''. Previous relay log pos and relay log file had been set to $relay_log_pos, .*$relay_log respectively.
74 --let $assert_count= 1
75 --source include/assert_grep.inc
76
77 --let $assert_cond=$relay_log_pos_restart = 4
78 --let $assert_text= "Relay_log_pos points at the beginning of the new relay log file now."
79 --source include/assert.inc
80
81 --let $assert_cond= $read_master_log_pos_restart = $create_tbl_stmt_trx_pos_in_bl
82 --let $assert_text= "Read_master_log_pos after restart points at the CREATE TABLE position."
83 --source include/assert.inc
84
85 #
86 # Show that even though the positions have changed, the
87 # relay logs have not yet been purged. Lets assume that
88 # the master is crashed and thus the slave cannot connect
89 # to it. This means that we could try to apply the existing
90 # relay logs (maybe they are indeed corrupt, maybe they are
91 # not).
92 #
93
94 --replace_result $relay_log_pos RELAY_LOG_POS $relay_log SLAVE_RELAY_LOG_FILE_NAME
95 --eval CHANGE REPLICATION SOURCE TO Relay_log_pos= $relay_log_pos, Relay_log_file='$relay_log'
96 --source include/start_slave_sql.inc
97 --let $wait_condition= SELECT COUNT(*)=1 FROM t1
98 --source include/wait_condition.inc
99
100 --source include/start_slave_io.inc
101 --source include/rpl_connection_master.inc
102
103 DROP TABLE t1;
104
105 --source include/sync_slave_sql_with_master.inc
106
107 --source include/rpl_end.inc