Bug #93957 slave_compressed_protocol doesn't work with semi-sync replication in MySQL-5.7

Submitted: 17 Jan 2019 8:25 Modified: 1 Oct 2019 9:49
Reporter: Pavel Katiushyn Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.7.24 OS:Any
Assigned to: CPU Architecture:Any
Tags: compression, protocol, replication, semisynchronous

[17 Jan 2019 8:25] Pavel Katiushyn
Description:
Semi-synchronouse replication does not work, when slave_compressed_protocol is enabled.
The issue was reported and closed earlier: Bug #86230.
But I experienced the same problem on 5.7.24.

How to repeat:
See Bug #86230 for the steps.
Basically, install master and slave with 5.7.24.
Configure semi-sync replication according to documentation: https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html

Enable slave_compressed_protocol=1 on slave, re-connect slave to master and try to write any data.
[17 Jan 2019 8:31] Pavel Katiushyn
Forgot to add, that the tested case was with GTID replication enabled.
[17 Jan 2019 12:52] MySQL Verification Team
Hello Pavel,

Thank you for the report.

regards,
Umesh
[5 May 2019 9:15] chaofei yu
In which version will this problem be fixed?
[1 Oct 2019 9:49] Pavel Katiushyn
Any updates on this?
[13 Jul 2023 3:11] Biao You
my db is 5.7.28 still see the same ERROR messages...

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.