UNSOLVED 增量数据时间错误(全量不会)
-
- 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)
-
时区处理暂时不支持0000这种格式,后续版本会兼容
Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2