Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MySQL 5.7 mysqlbinlog fails with compression protocol enabled

Description

Description:
The mysqlbinlog utility fails to retrieve binlogs directly from a remote server when the compression protocol is enabled, the error returned is "ERROR: Could not construct log event object: Sanity check failed".
How to repeat:

  1. THIS WORKS:
    $ /usr/bin/mysqlbinlog mysql-bin.132834 --raw --read-from-remote-server --stop-never --host 10.10.10.10 --port 3306

  1. THIS DOESNT WORK:
    $ /usr/bin/mysqlbinlog mysql-bin.132834 --raw --read-from-remote-server --stop-never --host 10.10.10.10 --port 3306 --compress
    ERROR: Could not construct log event object: Sanity check failed
    Suggested fix:
    Current workaround is to collect binlogs with compression protocol disabled

Environment

Debian GNU/Linux 9
Linux XXX 4.9.0-4-amd64 #1 SMP Debian 4.9.51-1 (2017-09-28) x86_64 GNU/Linux

  • Percona Server 5.7

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:07 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

Oleksandr Kachan July 1, 2021 at 6:54 PM

The main.percona_mysqlbinlog_ssl_compress test should be also fixed in scope of this task. It should be improved to use proper binlog format as described in .

Lalit Choudhary August 27, 2018 at 11:00 AM
Edited

Hello Nick,

Thank you for the report.

Validated as described. Tested with percona server 5.7.22-22, 5.6.41,5.5.61

 

 

With and without --raw option error will be same. 

Won't Do

Details

Assignee

Reporter

Labels

Affects versions

Priority

Smart Checklist

Created August 10, 2018 at 12:35 PM
Updated March 4, 2025 at 9:07 PM
Resolved March 4, 2025 at 9:07 PM