Open GoogleCodeExporter opened 9 years ago
Please try to provide a simple set of SQL events that can trigger this behavior.
Do the table or column names contain non alphanumeric characters?
Original comment by g.maxia
on 12 Dec 2013 at 2:36
We are having the same issue.
Version: Tungsten Replicator 2.1.0 build 343, MySQL 5.5
Topology: Master-Master
Error:
pendingExceptionMessage: java.sql.SQLSyntaxErrorException: Unknown column '' in
'field list'
Failing statement : INSERT INTO `testing`.`test` ( `id` , `image` , `` )
VALUES ( ? , UNHEX( ? ) , ? )
How to Reproduce:
1. Node A & B are in sync
2. Alter table "test" in Node A by adding one new column
3. Verify both Node A & B table schema are in sync
4. Run an INSERT statement to table "test" in Node B using PHP
5. Insert will be success in Node B using PHP, but the replicator sync will
stop with the error above
We also tested the follow steps and NO error occur:
1. Node A & B are in sync
2. Alter table "test" in Node A by adding one new column
3. Verify both Node A & B table schema are in sync
4. Use mysql command line and run "select * from test"
4. Run an INSERT statement in Node B using PHP
5. Insert will be success in BOTH Node A & B using PHP
Just guessing:
It seems the replicator has cached the table structure.
Thank you.
Original comment by fran...@franfran.com
on 14 Aug 2014 at 10:42
I can't reproduce this issue using the steps listed above. I am using
Tungsten-replicator 3.0.0-286. I would appreciate some more information. I
believe this problem may happen when the alter table and the subsequent insert
are too close to each other. I had no luck in finding the right sequence of
events that lead to the problem described in this issue.
Original comment by g.maxia
on 18 Aug 2014 at 3:37
Original issue reported on code.google.com by
bran...@seibelnet.ca
on 12 Dec 2013 at 2:28