Bug #18108 MIXED mode with UUID missed table map event
Submitted: 9 Mar 2006 14:54 Modified: 14 Mar 2006 13:24
Reporter: Lars Thalmann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1.8 (source tree) OS:
Assigned to: Guilhem Bichot CPU Architecture:Any

[9 Mar 2006 14:54] Lars Thalmann
Description:
rpl_rbr_to_sbr.test show that UUID in MIXED mode generate a log without
any table map event.  The binwrite is this:

# at 293
#060309 15:38:07 server id 1  end_log_pos 410 
# Position  Timestamp   Type   Master ID        Size      Master Pos    Flags 
# 00000125 cf 3d 10 44   14   01 00 00 00   75 00 00 00   9a 01 00 00   10 00
# 00000138 0f 00 00 00 00 00 01 00  02 ff fc 03 00 00 00 24 |................|
# 00000148 00 00 38 31 38 35 61 38  66 32 2d 30 30 63 61 2d |..8185a8f2.00ca.|
# 00000158 31 30 32 39 2d 61 65 33  32 2d 30 30 31 34 33 38 |1029.ae32.001438|
# 00000168 61 37 34 31 37 61 fc 04  00 00 00 24 00 00 38 31 |a7417a........81|
# 00000178 38 36 31 33 66 61 2d 30  30 63 61 2d 31 30 32 39 |8613fa.00ca.1029|
# 00000188 2d 61 65 33 32 2d 30 30  31 34 33 38 61 37 34 31 |.ae32.001438a741|
# 00000198 37 61                                            |7a|
#       Write_rows: table id 15
BINLOG '
zz0QRBQBAAAAdQAAAJoBAAAQAA8AAAAAAAEAAv/8AwAAACQAADgxODVhOGYyLTAwY2EtMTAyOS1h
ZTMyLTAwMTQzOGE3NDE3YfwEAAAAJAAAODE4NjEzZmEtMDBjYS0xMDI5LWFlMzItMDAxNDM4YTc0
MTdh
';

How to repeat:
rpl_rbr_to_sbr.test

Suggested fix:
Check that table map is generated
[14 Mar 2006 13:23] 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/3826
[14 Mar 2006 13:24] Guilhem Bichot
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Can't repeat, bug was very probably fixed by this changeset:
ChangeSet@1.2158.5.1, 2006-03-13 15:34:30+01:00, guilhem@mysql.com
  Fixes to the replication mixed mode (patch approved by Monty) <etc>

Nothing to document (mixed mode was pushed after 5.1.8 so was not released yet).
[14 Mar 2006 13:26] Guilhem Bichot
by the way I re-enabled the test.