MYSQL-TIDB unsigned int同步失败
-
mysql 上下游主键采用无符号整型
同步id: 2221468691报错 (超过有符号数上限)
com.clougence.cloudcanal.base.service.task.exception.runtime.FullScanException: null.goods_data2.goods_history_price_info_v2 full extract occur an exception,msg:NumberFormatException: For input string: “2221468691”
at com.clougence.cloudcanal.base.service.task.parser.full.RdbNumbericPkSnapshotScanner.scanTable(RdbNumbericPkSnapshotScanner.java:136)
at com.clougence.cloudcanal.mysql.worker.reader.full.MySQLTableFullProducer.produce(MySQLTableFullProducer.java:94)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Cannot convert class java.lang.String to SQL type requested due to java.lang.NumberFormatException - For input string: “2221468691”
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.setObject(ClientPreparedStatement.java:1685)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setObject(DruidPooledPreparedStatement.java:469)
at com.clougence.cloudcanal.base.service.task.parser.full.RdbNumbericPkSnapshotScanner.scanTable(RdbNumbericPkSnapshotScanner.java:71)
… 4 more
Caused by: java.lang.NumberFormatException: For input string: “2221468691”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.valueOf(Integer.java:766)
at com.mysql.cj.AbstractQueryBindings.setObject(AbstractQueryBindings.java:779)
at com.mysql.cj.AbstractQueryBindings.setObject(AbstractQueryBindings.java:302)
at com.mysql.cj.jdbc.ClientPreparedStatement.setObject(ClientPreparedStatement.java:1678) -
2.1.0.14 后续我升级到最新版在尝试一下
-
@扯蛋的人生 我们确认下,之前应该有修复过类似问题,请问你的版本是什么?