Log on master 2023-10-16T11:58:00.005675+08:00 6570675 [Note] Stop semi-sync binlog_dump to slave (server_id: 2021541053) 2023-10-16T11:58:00.005760+08:00 6570673 [Note] Stop semi-sync binlog_dump to slave (server_id: -2040033105) 2023-10-16T11:58:00.005802+08:00 6570677 [Note] Stop semi-sync binlog_dump to slave (server_id: 2060010103) 2023-10-16T12:07:33.793510+08:00 7997260 [Note] Semi-sync replication switched OFF. 2023-10-16T12:07:33.793828+08:00 7997260 [Note] Semi-sync replication disabled on the master. 2023-10-16T12:07:33.808181+08:00 0 [Note] Stopping ack receiver thread Log on semi-sync-slave-1: 2023-10-16T11:58:01.108302+08:00 21885789 [ERROR] Slave I/O for channel '': Replication event checksum verification failed while reading from network. Error_code: 1743 2023-10-16T11:58:01.126442+08:00 21885789 [ERROR] Slave I/O for channel '': Relay log write failure: could not queue event from master, Error_code: 1595 2023-10-16T11:58:01.126637+08:00 21885789 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.041499', position 516968340 Log on semi-sync-slave-2: 2023-10-16T11:58:01.109431+08:00 4130779 [ERROR] Slave I/O for channel '': Replication event checksum verification failed while reading from network. Error_code: 1743 2023-10-16T11:58:01.110636+08:00 4130779 [ERROR] Slave I/O for channel '': Relay log write failure: could not queue event from master, Error_code: 1595 2023-10-16T11:58:01.110655+08:00 4130779 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.041499', position 516968340 Log on semi-sync-slave-3: 2023-10-16T11:58:01.109384+08:00 3020606 [ERROR] Slave I/O for channel '': Replication event checksum verification failed while reading from network. Error_code: 1743 2023-10-16T11:58:01.149741+08:00 3020606 [ERROR] Slave I/O for channel '': Relay log write failure: could not queue event from master, Error_code: 1595 2023-10-16T11:58:01.149765+08:00 3020606 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.041499', position 516968340 All slave report checksum error for the same binlog_file + binlog_pos. And we parse the binlog file from master. mysqlbinlog -vv --start-position=516967823 --stop-position=516969451 mysql-bin.041499 > mysql-bin.041499.516967823-516969451 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 274 #231016 11:56:21 server id 2132200274 end_log_pos 123 CRC32 0xdc6b83d2 Start: binlog v 4, server v 5.7.21-log created 231016 11:56:21 BINLOG ' ZbQsZQ9SyxZ/dwAAAHsAAAAAAAQANS43LjIxLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA AdKDa9w= '/*!*/; # at 516967823 #231016 11:58:00 server id 2132200274 end_log_pos 516967888 CRC32 0x54966d85 GTID last_committed=18360 sequence_number=18378 rbr_only=yes original_committed_timestamp=0 immediate_commit_timestamp=0 transaction_length=0 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; # original_commit_timestamp=0 (1970-01-01 08:00:00.000000 CST) # immediate_commit_timestamp=0 (1970-01-01 08:00:00.000000 CST) /*!80001 SET @@session.original_commit_timestamp=0*//*!*/; /*!80014 SET @@session.original_server_version=0*//*!*/; /*!80014 SET @@session.immediate_server_version=0*//*!*/; SET @@SESSION.GTID_NEXT= 'a5ba25de-5890-11ea-bdfe-c29207a1edf8:750614626'/*!*/; # at 516967888 #231016 11:58:00 server id 2132200274 end_log_pos 516967981 CRC32 0xbb231bce Query thread_id=7940558 exec_time=0 error_code=0 SET TIMESTAMP=1697428680.004052/*!*/; SET @@session.pseudo_thread_id=7940558/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!80005 &~0x1003ff00*//*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=46/*!*/; SET @@session.time_zone='SYSTEM'/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; # at 516967981 #231016 11:58:00 server id 2132200274 end_log_pos 516968270 CRC32 0x49a560a0 Rows_query # at 516968270 #231016 11:58:00 server id 2132200274 end_log_pos 516968340 CRC32 0x9cb04d11 Table_map: `xxxx`.`xxxx` mapped to number 276 # at 516968340 #231016 11:58:00 server id 2132200274 end_log_pos 516968606 CRC32 0xee7bc200 Update_rows: table id 276 flags: STMT_END_F # at 516968606 #231016 11:58:00 server id 2132200274 end_log_pos 516968637 CRC32 0xbc187fd6 Xid = 19499444783 COMMIT/*!*/; # at 516968637 #231016 11:58:00 server id 2132200274 end_log_pos 516968702 CRC32 0x96f7abf7 GTID last_committed=18360 sequence_number=18379 rbr_only=yes original_committed_timestamp=0 immediate_commit_timestamp=0 transaction_length=0 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; # original_commit_timestamp=0 (1970-01-01 08:00:00.000000 CST) # immediate_commit_timestamp=0 (1970-01-01 08:00:00.000000 CST) /*!80001 SET @@session.original_commit_timestamp=0*//*!*/; /*!80014 SET @@session.original_server_version=0*//*!*/; /*!80014 SET @@session.immediate_server_version=0*//*!*/; SET @@SESSION.GTID_NEXT= 'a5ba25de-5890-11ea-bdfe-c29207a1edf8:750614627'/*!*/; # at 516968702 #231016 11:58:00 server id 2132200274 end_log_pos 516968795 CRC32 0x4023836f Query thread_id=7931220 exec_time=0 error_code=0 SET TIMESTAMP=1697428680.004236/*!*/; BEGIN /*!*/; # at 516968795 #231016 11:58:00 server id 2132200274 end_log_pos 516969084 CRC32 0x15489cd0 Rows_query # at 516969084 #231016 11:58:00 server id 2132200274 end_log_pos 516969154 CRC32 0x6a83b056 Table_map: `xxxx`.`xxxx` mapped to number 276 # at 516969154 #231016 11:58:00 server id 2132200274 end_log_pos 516969420 CRC32 0x300814a2 Update_rows: table id 276 flags: STMT_END_F # at 516969420 #231016 11:58:00 server id 2132200274 end_log_pos 516969451 CRC32 0xbdefb933 Xid = 19499444790 COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;