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