nicholasren / open-replicator

Automatically exported from code.google.com/p/open-replicator
0 stars 0 forks source link

Replicator fails to find databaseName #13

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Under MySQL 5.5 on Windows 7-64bit, OpenReplicator executed using JDK 1.7.0_71 
32bit

1. Using MIXED binlog output (for the purposes of 'unrelated app')
2. Using manually created batch files calling SQL statements to test behaviour
3. Using OpenReplicatorTest.java with only minor modifications to point to 
server etc.

Log output works for 'unrelated app' specified above, yest when running simple 
batch statements to modify test database content, openReplicator fails to 
produce a database name

12:54:01.442 [binlog-parser-1] INFO  c.google.code.or.OpenReplicatorTest - 
QueryEvent[header=BinlogEventV4HeaderImpl[timestamp=1415619828000,eventType=2,se
rverId=1234,eventLength=139,nextPosition=37033,flags=0,timestampOfReceipt=141562
4041442],threadId=19,elapsedTime=0,databaseNameLength=0,errorCode=0,statusVariab
lesLength=26,statusVariables=[QFlags2Code[flags=0], 
QSQLModeCode[sqlMode=1344274432], QCatalogNzCode[catalogName=std], 
QCharsetCode[characterSetClient=8,collationConnection=8,collationServer=8]],data
baseName=,sql=INSERT INTO `test`.`new_table`
(`TestTableID`,
`TextFieldOne`)
VALUES
(2,'XYZG')

Batch statements used to produce this:

INSERTRECORD.BAT
----------------------
mysql --user=****** --password=******<.\sql\CreateRecord.sql
pause

CREATERECORD.SQL
---------------------
INSERT INTO `test`.`new_table`
(`TestTableID`,
`TextFieldOne`)
VALUES
(2,'XYZG');

Original issue reported on code.google.com by simeon.i...@googlemail.com on 10 Nov 2014 at 1:08