canal icon indicating copy to clipboard operation
canal copied to clipboard

Published 20 hours ago • verified publisher icon alibaba

阿里云RDS 同步到本地自建mysql时，一个奇怪的报错

Open hlz5857475 opened this issue 1 year ago • 1 comments

Question

canal使用的最新版本1.1.7 阿里云mysql版本是 8.0.25 本地自建mysql版本是 8.0.33

在adapter.log中出现如下错误 2023-08-10 08:00:08.222 [Thread-5] ERROR com.alibaba.otter.canal.connector.core.util.JdbcTypeUtil - table: tb_basis_info_public column: time_part, failed convert type 24:00:00 to 92 2023-08-10 08:00:11.232 [Thread-5] ERROR com.alibaba.otter.canal.connector.core.util.JdbcTypeUtil - table: tb_basis_info_public column: time_part, failed convert type 24:00:00 to 92

其中time_part 字段类型是time

hlz5857475 avatar Aug 10 '23 06:08 hlz5857475