1############################################################################### 2# Bug#24901077: RESET SLAVE ALL DOES NOT ALWAYS RESET SLAVE 3# 4# Problem: 5# ======= 6# If you have a relay log index file that has ended up with 7# some relay log files that do not exists, then RESET SLAVE 8# ALL is not enough to get back to a clean state. 9############################################################################### 10# Remove all slave-relay-bin.0* files (do not remove slave-relay-bin.index) 11# During server restart rli initialization will fail as there are no 12# relay logs. In case of bug RESET SLAVE will not do the required clean up 13# as rli is not inited and subsequent START SLAVE will fail. 14# Disable "Warning 1612 Being purged log ./slave-relay-bin.0* was not found" 15# because it is different on Unix and Windows systems. 16 17--source include/have_binlog_format_mixed.inc 18--source include/master-slave.inc 19 20--connection master 21CREATE TABLE t1 (c1 INT); 22INSERT INTO t1 (c1) VALUES (1); 23--sync_slave_with_master 24 25--connection slave 26--source include/stop_slave_sql.inc 27--let $MYSQLD_SLAVE_DATADIR= `select @@datadir` 28 29--connection master 30# Generate more relay logs on slave. 31FLUSH LOGS; 32FLUSH LOGS; 33INSERT INTO t1 (c1) VALUES (2); 34 35--source include/sync_slave_io_with_master.inc 36call mtr.add_suppression("File '.*slave-relay-bin."); 37call mtr.add_suppression("Could not open log file"); 38call mtr.add_suppression("Failed to open the relay log"); 39call mtr.add_suppression("Failed to initialize the master info structure"); 40 41# Stop slave 42--let $rpl_server_number= 2 43--source include/rpl_stop_server.inc 44 45# Delete file(s) 46--echo # Removing $remove_pattern file(s) 47--let $remove_pattern= slave-relay-bin.0* 48--remove_files_wildcard $MYSQLD_SLAVE_DATADIR $remove_pattern 49 50# Start slave 51--let $rpl_server_number= 2 52--source include/rpl_start_server.inc 53 54# Start slave must fail because of the removed file(s). 55--error ER_MASTER_INFO 56START SLAVE; 57 58# Try a second time, it must fail again. 59--error ER_MASTER_INFO 60START SLAVE; 61 62# Retrieve master executed position before reset slave. 63--let $master_exec_file= query_get_value("SHOW SLAVE STATUS", Relay_Master_Log_File, 1) 64--let $master_exec_pos= query_get_value("SHOW SLAVE STATUS", Exec_Master_Log_Pos, 1) 65 66# Reset slave. 67# Disable "Warning 1612 Being purged log ./slave-relay-bin.0* was not found" 68# because it is different on Unix and Windows systems. 69--disable_warnings 70RESET SLAVE; 71--enable_warnings 72DROP TABLE t1; 73--replace_result $master_exec_file MASTER_LOG_FILE $master_exec_pos MASTER_LOG_POS 74--eval START SLAVE UNTIL MASTER_LOG_FILE= '$master_exec_file', MASTER_LOG_POS= $master_exec_pos; 75--source include/wait_for_slave_sql_to_stop.inc 76--source include/stop_slave_io.inc 77 78# Start slave. 79--source include/start_slave.inc 80 81--connection master 82--sync_slave_with_master 83# Check consistency. 84--let $diff_tables= master:t1, slave:t1 85--source include/diff_tables.inc 86 87# Cleanup 88--connection master 89DROP TABLE t1; 90--sync_slave_with_master 91--source include/rpl_end.inc 92