Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    MYSQL-TIDB unsigned int同步失败

    问答区
    mysql-tidb同步
    2
    3
    9
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • 扯蛋的人生
      扯蛋的人生 last edited by

      mysql 上下游主键采用无符号整型

      同步id: 2221468691报错 (超过有符号数上限)

      WechatIMG140.png

      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)

      junyu-cloudcanal 1 Reply Last reply Reply Quote 0
      • 扯蛋的人生
        扯蛋的人生 last edited by

        2.1.0.14 后续我升级到最新版在尝试一下

        1 Reply Last reply Reply Quote 0
        • junyu-cloudcanal
          junyu-cloudcanal @扯蛋的人生 last edited by

          @扯蛋的人生 我们确认下,之前应该有修复过类似问题,请问你的版本是什么?

          1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            Last post
          Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2