| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection slave; |
| 4 |
include/stop_slave.inc |
| 5 |
CHANGE MASTER TO MASTER_USE_GTID=NO; |
| 6 |
include/start_slave.inc |
| 7 |
connection master; |
| 8 |
call mtr.add_suppression('Found invalid event in binary log'); |
| 9 |
call mtr.add_suppression('Slave I/O: Relay log write failure: could not queue event from master'); |
| 10 |
call mtr.add_suppression('event read from binlog did not pass crc check'); |
| 11 |
call mtr.add_suppression('Replication event checksum verification failed'); |
| 12 |
call mtr.add_suppression('Event crc check failed! Most likely there is event corruption'); |
| 13 |
call mtr.add_suppression('Slave SQL: Error initializing relay log position: I/O error reading event at position .*, error.* 1593'); |
| 14 |
SET @old_master_verify_checksum = @@master_verify_checksum; |
| 15 |
# 1. Creating test table/data and set corruption position for testing |
| 16 |
connection master; |
| 17 |
* insert/update/delete rows in table t1 * |
| 18 |
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c VARCHAR(100)); |
| 19 |
include/stop_slave.inc |
| 20 |
# 2. Corruption in master binlog and SHOW BINLOG EVENTS |
| 21 |
SET @saved_dbug = @@global.debug_dbug; |
| 22 |
SET @@global.debug_dbug="d,corrupt_read_log_event_char"; |
| 23 |
SHOW BINLOG EVENTS; |
| 24 |
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error |
| 25 |
SET @@global.debug_dbug=@saved_dbug; |
| 26 |
# 3. Master read a corrupted event from binlog and send the error to slave |
| 27 |
SET @@global.debug_dbug="d,corrupt_read_log_event2_set"; |
| 28 |
connection slave; |
| 29 |
START SLAVE IO_THREAD; |
| 30 |
include/wait_for_slave_io_error.inc [errno=1236] |
| 31 |
connection master; |
| 32 |
SET @@global.debug_dbug=@saved_dbug; |
| 33 |
# 4. Master read a corrupted event from binlog and send it to slave |
| 34 |
connection master; |
| 35 |
SET GLOBAL master_verify_checksum=0; |
| 36 |
SET @@global.debug_dbug="d,corrupt_read_log_event2_set"; |
| 37 |
connection slave; |
| 38 |
START SLAVE IO_THREAD; |
| 39 |
include/wait_for_slave_io_error.inc [errno=1595,1743] |
| 40 |
connection master; |
| 41 |
SET @@global.debug_dbug=@saved_dbug; |
| 42 |
SET GLOBAL master_verify_checksum=1; |
| 43 |
# 5. Slave. Corruption in network |
| 44 |
connection slave; |
| 45 |
SET @saved_dbug_slave = @@GLOBAL.debug_dbug; |
| 46 |
SET @@global.debug_dbug="d,corrupt_queue_event"; |
| 47 |
START SLAVE IO_THREAD; |
| 48 |
include/wait_for_slave_io_error.inc [errno=1595,1743] |
| 49 |
SET @@global.debug_dbug=@saved_dbug_slave; |
| 50 |
# 6. Slave. Corruption in relay log |
| 51 |
SET @@global.debug_dbug="d,corrupt_read_log_event_char"; |
| 52 |
START SLAVE SQL_THREAD; |
| 53 |
include/wait_for_slave_sql_error.inc [errno=1593] |
| 54 |
SET @@global.debug_dbug=@saved_dbug_slave; |
| 55 |
# 7. Seek diff for tables on master and slave |
| 56 |
connection slave; |
| 57 |
include/start_slave.inc |
| 58 |
connection master; |
| 59 |
connection slave; |
| 60 |
include/diff_tables.inc [master:test.t1, slave:test.t1] |
| 61 |
# 8. Clean up |
| 62 |
connection master; |
| 63 |
set @@global.debug_dbug = @saved_dbug; |
| 64 |
SET GLOBAL master_verify_checksum = @old_master_verify_checksum; |
| 65 |
DROP TABLE t1; |
| 66 |
connection slave; |
| 67 |
include/rpl_end.inc |