Navigation

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

    UNSOLVED 增量数据时间错误(全量不会)

    问答区
    startrocks同步
    2
    2
    211
    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.
    • D.Lin
      D.Lin last edited by

      • cloudcanal版本:2.1.0.22
      • mysql版本: 5.7
      • StarRocks :1.19.1
      • mysql数据同步到StarRocks 失败:
        异常信息
      Caused by: java.time.format.DateTimeParseException: Text '0000-00-00 00:00:00' could not be parsed: Invalid value for YearOfEra (valid values 1 - 999999999/1000000000): 0
      	at java.time.format.DateTimeFormatter.createError(DateTimeFormatter.java:1920)
      	at java.time.format.DateTimeFormatter.parse(DateTimeFormatter.java:1855)
      	at java.time.LocalDateTime.parse(LocalDateTime.java:492)
      	at com.clougence.cloudcanal.starrocks.worker.util.StarRocksDataHelper.processByTimeZone(StarRocksDataHelper.java:201)
      	at com.clougence.cloudcanal.starrocks.worker.util.StarRocksDataHelper.genRowBytesForIncre(StarRocksDataHelper.java:146)
      	at com.clougence.cloudcanal.starrocks.worker.writer.executor.incre.StarRocksIncreStreamLoadExecutor.doInsert(StarRocksIncreStreamLoadExecutor.java:226)
      	at com.clougence.cloudcanal.starrocks.worker.writer.executor.incre.StarRocksIncreStreamLoadExecutor.runBatch(StarRocksIncreStreamLoadExecutor.java:182)
      	... 6 more
      Caused by: java.time.DateTimeException: Invalid value for YearOfEra (valid values 1 - 999999999/1000000000): 0
      	at java.time.temporal.ValueRange.checkValidValue(ValueRange.java:311)
      	at java.time.temporal.ChronoField.checkValidValue(ChronoField.java:703)
      
      1 Reply Last reply Reply Quote 0
      • CloudCanal-万少
        CloudCanal-万少 last edited by

        时区处理暂时不支持0000这种格式,后续版本会兼容

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