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.