Bug #27171 mysqlbinlog produces different output depends from option -R

Submitted: 15 Mar 2007 12:50 Modified: 24 Apr 2007 1:34
Reporter: Sveta Smirnova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 BK OS:Linux (Linux (Redhat))
Assigned to: Sergei Golubchik CPU Architecture:Any
Tags: bfsm_2007_04_19

[15 Mar 2007 12:50] Sveta Smirnova
Description:
mysqlbinlog data/foo.bin and mysqlbinlog -R foo.bin produce different output

How to repeat:
Run 

mysqlbinlog -u root -pxxxxxx -h dbnj07a.int --database=rhuddleston_nj3 --start-position=18351401 --stop-position=18739540 -R replicatelogs.000030 | tail

and then

mysqlbinlog --database=rhuddleston_nj3 --start-position=18351401 --stop-position=18739540 /data/binlogs/replicatelogs.000030 | tail

on attached hidden binary log file. There is no last COMMIT in the output of mysqlbinlog -R ...
[22 Mar 2007 15:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22647

ChangeSet@1.2488, 2007-03-22 16:55:39+02:00, serg@sergbook.mysql.com +1 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  Server starts any binlog dump from Format_description_log_event,
  this shifted all offset calculations in mysqlbinlog and made it
  to stop the dump earlier than --stop-position. Now mysqlbinlog
  takes Format_description_log_event into account
[22 Mar 2007 15:50] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22654

ChangeSet@1.2488, 2007-03-22 17:51:05+02:00, serg@sergbook.mysql.com +3 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  Server starts any binlog dump from Format_description_log_event,
  this shifted all offset calculations in mysqlbinlog and made it
  to stop the dump earlier than --stop-position. Now mysqlbinlog
  takes Format_description_log_event into account
[22 Mar 2007 17:26] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22673

ChangeSet@1.2406, 2007-03-22 19:27:01+02:00, serg@sergbook.mysql.com +3 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  Server starts any binlog dump from Format_description_log_event,
  this shifted all offset calculations in mysqlbinlog and made it
  to stop the dump earlier than --stop-position. Now mysqlbinlog
  takes Format_description_log_event into account
[22 Mar 2007 18:55] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22680

ChangeSet@1.2406, 2007-03-22 20:55:59+02:00, serg@sergbook.mysql.com +3 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  Server starts any binlog dump from Format_description_log_event,
  this shifted all offset calculations in mysqlbinlog and made it
  to stop the dump earlier than --stop-position. Now mysqlbinlog
  takes Format_description_log_event into account
[2 Apr 2007 7:47] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/23504

ChangeSet@1.2428, 2007-04-02 09:43:39+02:00, serg@janus.mylan +1 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  a better fix, that works with 4.1 servers which don't send a fake
  Format_description_log_event.
[5 Apr 2007 12:07] Guilhem Bichot
comments sent by mail.
[10 Apr 2007 13:30] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/24170

ChangeSet@1.2428, 2007-04-10 15:26:35+02:00, serg@janus.mylan +1 -0
  Bug#27171 mysqlbinlog produces different output depends from option -R
  a better fix, that works with 4.1 servers which don't send a fake
  Format_description_log_event.
[10 Apr 2007 15:22] Sergei Golubchik
pushed in 5.0-marvel
[18 Apr 2007 15:46] Bugs System
Pushed into 5.1.18-beta
[18 Apr 2007 15:47] Bugs System
Pushed into 5.0.42
[24 Apr 2007 1:34] Paul DuBois
Noted in 5.0.42, 5.1.18 changelogs.

mysqlbinlog produced different output with the -R option than without
it.
[15 May 2007 5:31] Mats Kindahl
The patch for this bug also fixed BUG#27037.

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

Page generated in 0.086 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.