search

zkfan / tungsten-replicator

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

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

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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

Original issue reported on code.google.com by venu.rap...@gmail.com on 23 Jun 2011 at 12:21

GoogleCodeExporter commented 9 years ago 
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

Original comment by stephane...@gtempaccount.com on 23 Jun 2011 at 12:46