[MDEV-18750] Failed to get the result using mysqlbinlog flashback option on big binlog file Created: 2019-02-27  Updated: 2019-06-10  Resolved: 2019-06-10

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.3.10, 10.2.22
Fix Version/s: 10.2.25

Type: Bug Priority: Minor
Reporter: Zicheng Huang Assignee: Andrei Elkin
Resolution: Fixed Votes: 0
Labels: flashback, mysqlbinlog
Environment:

Debian 9.5, kernel version 4.9.0-6-amd64


Attachments: JPEG File parsefailed.jpg    

 Description   

Failed to get the result using mysqlbinlog flashback option on large binlog file , failing case is as shown in the attachment pictures.
I've already figured it out - as long as the io_cache used within the flashback operation larger than 2147479552, which is the max value for read_buffer_size according to the mysql doc, flashback failure should happend.

I've created a pull request: https://github.com/MariaDB/server/pull/1214, please check

update at 2018.03.08:
Actually, I later realized that this bug was already fixed in release 10.3.13(seems like the same problem according to the commit message of mysys/mf_iocache.c) , but since it is not yet applied to branch 10.2, I still made this pull request , plus adding the required mtr test and result file.



 Comments   
Comment by Sergey Vojtovich [ 2019-06-05 ]

PR was merged, Elkin please update this task accordingly.

Comment by Andrei Elkin [ 2019-06-10 ]

The pushed patch backports b68d8a05d326 of 10.3.

Generated at Thu Feb 08 08:46:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.