Skip to content

Receiving multiple TableMapEvents when there is no change in table for a subsequent event #11

@GoogleCodeExporter

Description

@GoogleCodeExporter
What steps will reproduce the problem?
1. Connecting to a database with multiple tables say Table1 and Table2. 
Generate one event on Table1, followed by two events on Table2.

What is the expected output? What do you see instead?

TableMapEvent1: For table: T1 ( obfuscated name )
-------------------------------------------------

2014-04-24 22:20:15,455 +17574 [binlog-parser-1] (INFO) 
{EspressoOREventProducer} processTableMapEvent invoked with tme = 
TableMapEvent[header=BinlogEventV4HeaderImpl[timestamp=1398220088000,eventType=1
9,serverId=18357032,groupId=5159307
9467,eventLength=91,nextPosition=1054567879,flags=0,timestampOfReceipt=139837801
5455],tableId=267,reserved=1,databaseNameLength=11,databaseName=D1,tableNameLeng
th=13,tableName=T1,columnCount=13,columnTypes={8,8,15,8,8,15,8,15,16,15,8,-4,2},
columnMetadataCount=11,columnMetadata=Metadata[metadata={0,0,30,0,0,30,0,30,1024
,768,0,4,0}],columnNullabilities=0000000011110]

TableMapEvent 2: For table: T2 ( obfuscated name )
-------------------------------------------------

2014-04-24 22:20:15,455 +17574 [binlog-parser-1] (INFO) 
{EspressoOREventProducer} processTableMapEvent invoked with tme = 
TableMapEvent[header=BinlogEventV4HeaderImpl[timestamp=1398220088000,eventType=1
9,serverId=18357032,groupId=5159307
9467,eventLength=90,nextPosition=1054568225,flags=0,timestampOfReceipt=139837801
5455],tableId=196,reserved=1,databaseNameLength=11,databaseName=D1,tableNameLeng
th=13,tableName=T2,columnCount=12,columnTypes={8,8,15,8,1
5,8,15,16,15,8,-4,2},columnMetadataCount=11,columnMetadata=Metadata[metadata={0,
0,30,0,30,0,30,1024,768,0,4,0}],columnNullabilities=000000011110]


TableMapEvent 3: For table: T1 ( obfuscated name )
-------------------------------------------------

2014-04-24 22:20:15,456 +17575 [binlog-parser-1] (INFO) 
{EspressoOREventProducer} processTableMapEvent invoked with tme = 
TableMapEvent[header=BinlogEventV4HeaderImpl[timestamp=1398220088000,eventType=1
9,serverId=18357032,groupId=5159307
9467,eventLength=91,nextPosition=1054568556,flags=0,timestampOfReceipt=139837801
5456],tableId=267,reserved=1,databaseNameLength=11,databaseName=D1,tableNameLeng
th=13,tableName=T1,columnCount=13,columnTypes={8,8,15,8,8
,15,8,15,16,15,8,-4,2},columnMetadataCount=11,columnMetadata=Metadata[metadata={
0,0,30,0,0,30,0,30,1024,768,0,4,0}],columnNullabilities=0000000011110]

TableMapEvent 4: For table: T1 ( obfuscated name )
-------------------------------------------------

2014-04-24 22:20:15,457 +17576 [binlog-parser-1] (INFO) 
{EspressoOREventProducer} processTableMapEvent invoked with tme = 
TableMapEvent[header=BinlogEventV4HeaderImpl[timestamp=1398220088000,eventType=1
9,serverId=18357032,groupId=5159307
9467,eventLength=91,nextPosition=1054568899,flags=0,timestampOfReceipt=139837801
5456],tableId=267,reserved=1,databaseNameLength=11,databaseName=D1,tableNameLeng
th=13,tableName=T1,columnCount=13,columnTypes={8,8,15,8,8
,15,8,15,16,15,8,-4,2},columnMetadataCount=11,columnMetadata=Metadata[metadata={
0,0,30,0,0,30,0,30,1024,768,0,4,0}],columnNullabilities=0000000011110]


Question : Why are we getting the 4th TableMap event, when there is no change 
in table for which the event is being generated ? Is that expected or an error ?

What version of the product are you using? On what operating system?

1.0.5. Linux

Please provide any additional information below.


Original issue reported on code.google.com by phanindr...@gmail.com on 24 Apr 2014 at 10:49

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions