Debian Codegraph @

mysql-test/suite/rpl/r/rpl_corruption.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression('Found invalid event in binary log');
7 call mtr.add_suppression("Replica I/O for channel '': Relay log write failure: could not queue event from source");
8 call mtr.add_suppression('event read from binlog did not pass crc check');
9 call mtr.add_suppression('Replication event checksum verification failed');
10 call mtr.add_suppression('Event crc check failed! Most likely there is event corruption');
11 call mtr.add_suppression("Replica SQL for channel '': Error initializing relay log position: I/O error reading event at position .*, Error_code: MY-013117");
12 SET @old_source_verify_checksum = @@source_verify_checksum;
13 # 1. Creating test table/data and set corruption position for testing
14 * insert/update/delete rows in table t1 *
15 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c VARCHAR(100));
16 include/sync_slave_sql_with_master.inc
17 include/stop_slave.inc
18 # 2. Corruption in master binlog and SHOW BINLOG EVENTS
19 # Adding debug point 'corrupt_read_log_event' to @@GLOBAL.debug
20 SHOW BINLOG EVENTS;
21 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Error reading Log_event at position #: Failed decoding event: Event crc check failed! Most likely there is event corruption.
22 # 3. Master read a corrupted event from binlog and send the error to slave
23 START SLAVE IO_THREAD;
24 Warnings:
25 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
26 include/wait_for_slave_io_error.inc [errno=13114]
27 # 4. Master read a corrupted event from binlog and send it to slave
28 SET GLOBAL source_verify_checksum=0;
29 START SLAVE IO_THREAD;
30 Warnings:
31 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
32 include/wait_for_slave_io_error.inc [errno=13122,13115]
33 # Removing debug point 'corrupt_read_log_event' from @@GLOBAL.debug
34 SET GLOBAL source_verify_checksum=1;
35 # 5. Slave. Corruption in network
36 # Adding debug point 'corrupt_queue_event' to @@GLOBAL.debug
37 START SLAVE IO_THREAD;
38 Warnings:
39 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
40 include/wait_for_slave_io_error.inc [errno=13122,13115]
41 # 6. Slave. Corruption in relay log
42 # Adding debug point 'corrupt_read_log_event' to @@GLOBAL.debug
43 START SLAVE SQL_THREAD;
44 Warnings:
45 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
46 include/wait_for_slave_sql_error.inc [errno=13117]
47 # 7. Seek diff for tables on master and slave
48 # Removing debug point 'corrupt_read_log_event' from @@GLOBAL.debug
49 # Removing debug point 'corrupt_queue_event' from @@GLOBAL.debug
50 include/start_slave.inc
51 include/sync_slave_sql_with_master.inc
52 include/diff_tables.inc [master:t1, slave:t1]
53 # 8. Clean up
54 SET GLOBAL source_verify_checksum = @old_source_verify_checksum;
55 DROP TABLE t1;
56 include/sync_slave_sql_with_master.inc
57 include/rpl_end.inc