Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_corruption.result

raw
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