| 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 |