[MDEV-24773] slave_compressed_protocol doesn't work properly with semi-sync replication - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.3.29, 10.4.19, 10.5.10
Component/s: Replication
Labels:
None

Description

slave_compressed_protocol doesn't work properly with semi-sync replication. When it is enabled, It leads to intermittent SBM (Slave Behind Master) spikes and sometime gives below error.

2021-01-29 15:34:40 11 [ERROR] Read semi-sync reply magic number error

2021-01-29 15:34:50 9 [Warning] Timeout waiting for reply of binlog (file: master-bin.000001, pos: 479), semi-sync up to file master-bin.000001, position 329.

2021-01-29 15:34:50 9 [Note] Semi-sync replication switched OFF.

Looks like this is upstream bug. https://bugs.mysql.com/bug.php?id=86230
"The receiver thread for semisynchronous replication was not able to receive acknowledgements from slaves that used compression of the master/slave protocol (slave_compressed_protocol = ON) "

Attachments

Issue Links

causes

MDEV-32655 rpl_semi_sync_slave_compressed_protocol.test assert_only_after is wrong

Closed

relates to

MDEV-32551 "Read semi-sync reply magic number error" warnings on master

Closed

Activity

People

Assignee:: Sujatha Sivakumar (Inactive)

Reporter:: Nilnandan Joshi

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-02-03 06:08

Updated:: 2024-07-07 21:44

Resolved:: 2021-04-26 07:23

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.