Bug #113116 master binlog_dump exit and then semi-sync slave report checksum error
Submitted: 17 Nov 2023 2:29 Modified: 17 Nov 2023 23:23
Reporter: phoenix Zhang (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.7.21 OS:SUSE
Assigned to: MySQL Verification Team CPU Architecture:Any

[17 Nov 2023 2:29] phoenix Zhang 
Description:
We deploy 1 master + 3 semi-sync slave + 1 async slave, at one time, all 3 semi-sync slaves' binlog_dump thread exit on master; and one second later, all 3 semi-sync slave node print checksum error and exit slave thread. While, the async slave work normal.

See for attach file for detail log info.

How to repeat:
Which happens once on online database.
[17 Nov 2023 2:37] phoenix Zhang 
The error log and binlog info

Attachment: log.txt (text/plain), 6.36 KiB.
[17 Nov 2023 3:07] phoenix Zhang 
The async slave is normal, and after 3 semi-sync nodes restart slave, also replicate normal.
[17 Nov 2023 23:23] MySQL Verification Team 
Hi,

This looks like duplicate of Bug#113115. Please try using recent release and let us know if you can reproduce the problem with latest release.