otter mysql5.6_mysql5.6日期字段无法同步

最新推荐文章于 2022-05-25 19:13:59 发布

刘良运

最新推荐文章于 2022-05-25 19:13:59 发布

阅读量273

点赞数

文章标签： otter mysql5.6

本文链接：https://blog.csdn.net/weixin_42659194/article/details/113207555

版权

双向同步，开启了数据一致性。

otter 版本 4.2.8.

pid:3 nid:2 exception:setl:com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into scms_0801.sc_fsm_entity_state(CREATE_BY , CREATE_TIME , UPDATE_BY , UPDATE_TIME , ENTITY , ENTITY_ID , STATE_ID , ID) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update ID=values(ID) , CREATE_BY=values(CREATE_BY) , CREATE_TIME=values(CREATE_TIME) , UPDATE_BY=values(UPDATE_BY) , UPDATE_TIME=values(UPDATE_TIME) , ENTITY=values(ENTITY) , ENTITY_ID=values(ENTITY_ID) , STATE_ID=values(STATE_ID)]; Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:538)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:530)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:458)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:380)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:248)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:153)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$FastClassByCGLIB$$d932a4cb.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$EnhancerByCGLIB$$80fd23c2.load()

at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:198)

at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:189)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3560)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)

at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)

... 21 more

PairId: 6 , TableId: 4 , EventType : I , Time : 1392649496000

- Consistency : M , Mode :

---Pks

EventColumn[index=0,columnType=1,columnName=ID,columnValue=511021a297e411e3a579f01fafe49184,isNull=false,isKey=true,isUpdate=true]

---oldPks

---Columns

EventColumn[index=1,columnType=1,columnName=CREATE_BY,columnValue=6B5C696A8AA930225829D24788706553,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=2,columnType=93,columnName=CREATE_TIME,columnValue=1392678061000,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=3,columnType=1,columnName=UPDATE_BY,columnValue=6B5C696A8AA930225829D24788706553,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=4,columnType=93,columnName=UPDATE_TIME,columnValue=1392678061000,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=5,columnType=12,columnName=ENTITY,columnValue=order,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=6,columnType=1,columnName=ENTITY_ID,columnValue=511006e197e411e3a579f01fafe49184,isNull=false,isKey=false,isUpdate=true]

EventColumn[index=7,columnType=1,columnName=STATE_ID,columnValue=c54b50c0062511e38736001e6745fd59,isNull=false,isKey=false,isUpdate=true]

---Sql

insert into scms_0801.sc_fsm_entity_state(CREATE_BY , CREATE_TIME , UPDATE_BY , UPDATE_TIME , ENTITY , ENTITY_ID , STATE_ID , ID) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update ID=values(ID) , CREATE_BY=values(CREATE_BY) , CREATE_TIME=values(CREATE_TIME) , UPDATE_BY=values(UPDATE_BY) , UPDATE_TIME=values(UPDATE_TIME) , ENTITY=values(ENTITY) , ENTITY_ID=values(ENTITY_ID) , STATE_ID=values(STATE_ID)

Caused by: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into scms_0801.sc_fsm_entity_state(CREATE_BY , CREATE_TIME , UPDATE_BY , UPDATE_TIME , ENTITY , ENTITY_ID , STATE_ID , ID) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update ID=values(ID) , CREATE_BY=values(CREATE_BY) , CREATE_TIME=values(CREATE_TIME) , UPDATE_BY=values(UPDATE_BY) , UPDATE_TIME=values(UPDATE_TIME) , ENTITY=values(ENTITY) , ENTITY_ID=values(ENTITY_ID) , STATE_ID=values(STATE_ID)]; Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1