Issue 128 in tungsten-replicator: Caused by: java.sql.BatchUpdateException: Variable 'sql_mode' can't be set to the value of 'MODE_NO_ENGINE_SUBSTITUTION'

[tungsten-...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium FoundIn

New issue 128 by venu.rap...@gmail.com: Caused by:
java.sql.BatchUpdateException: Variable 'sql_mode' can't be set to the
value of 'MODE_NO_ENGINE_SUBSTITUTION'
http://code.google.com/p/tungsten-replicator/issues/detail?id=128

Caused by: java.sql.BatchUpdateException: Variable 'sql_mode' can't be set
to the value of 'MODE_NO_ENGINE_SUBSTITUTION'

am also sets my.conf file As:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Please help me......

2011-06-23 17:08:22,085 ERROR replicator.applier.JdbcApplier Statement
failed: UPDATE tungsten.heartbeat SET source_tstamp= '2011-06-23 17:07:14',
salt= 0, name= 'MASTER_ONLINE' WHERE id= 1 /* ___SERVICE___ = [replicator]
*/
2011-06-23 17:08:22,093 ERROR replicator.pipeline.SingleThreadStageTask
[q-to-dbms-0] Event application failed: seqno=13 fragno=0
message=java.sql.SQLException: Statement failed on slave but succeeded on
master
com.continuent.tungsten.replicator.applier.ApplierException:
java.sql.SQLException: Statement failed on slave but succeeded on master
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:624)
at
com.continuent.tungsten.replicator.applier.JdbcApplier.apply(JdbcApplier.java:1205)
at
com.continuent.tungsten.replicator.applier.ApplierWrapper.apply(ApplierWrapper.java:100)
at
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(SingleThreadStageTask.java:438)
at
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThreadStageTask.java:148)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Statement failed on slave but succeeded
on master
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:581)
... 5 more
Caused by: java.sql.BatchUpdateException: Variable 'sql_mode' can't be set
to the value of 'MODE_NO_ENGINE_SUBSTITUTION'
at
com.mysql.jdbc.StatementImpl.executeBatchUsingMultiQueries(StatementImpl.java:1154)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:961)
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:567)
... 5 more
2011-06-23 17:08:22,154 ERROR replicator.management.OpenReplicatorManager
Received error notification, shutting down services: Event application
failed: seqno=13 fragno=0 message=java.sql.SQLException: Statement failed
on slave but succeeded on master
com.continuent.tungsten.replicator.applier.ApplierException:
java.sql.SQLException: Statement failed on slave but succeeded on master
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:624)
at
com.continuent.tungsten.replicator.applier.JdbcApplier.apply(JdbcApplier.java:1205)
at
com.continuent.tungsten.replicator.applier.ApplierWrapper.apply(ApplierWrapper.java:100)
at
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(SingleThreadStageTask.java:438)
at
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThreadStageTask.java:148)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Statement failed on slave but succeeded
on master
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:581)
... 5 more
Caused by: java.sql.BatchUpdateException: Variable 'sql_mode' can't be set
to the value of 'MODE_NO_ENGINE_SUBSTITUTION'
at
com.mysql.jdbc.StatementImpl.executeBatchUsingMultiQueries(StatementImpl.java:1154)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:961)
at
com.continuent.tungsten.replicator.applier.JdbcApplier.applyStatementData(JdbcApplier.java:567)
... 5 more
2011-06-23 17:08:22,193 INFO replicator.pipeline.SingleThreadStageTask
[q-to-dbms-0] Terminating processing for stage

[tungsten-...@googlecode.com]

Updates:
Status: Duplicate

Comment #1 on issue 128 by stephane...@continuent.com: Caused by:

java.sql.BatchUpdateException: Variable 'sql_mode' can't be set to the
value of 'MODE_NO_ENGINE_SUBSTITUTION'
http://code.google.com/p/tungsten-replicator/issues/detail?id=128

Hi Venu,
This is a duplicate off issue #112
(http://code.google.com/p/tungsten-replicator/issues/detail?id=112)
This was fixed some time ago. Please test a newer snapshot.
Cheers
Stephane