search

alibaba / otter

阿里巴巴分布式数据库同步系统(解决中美异地机房)
Apache License 2.0
8.06k stars 2.49k forks source link

单向数据同步，同步一直报错 #319

Open heroghost opened 7 years ago

heroghost commented 7 years ago

你好，单向同步无法同步，一直报这个异常 pid:1 nid:1 exception:canal:canal1:java.lang.NullPointerException at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.loadBinlogChecksum(MysqlConnection.java:284) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:113) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:209) at java.lang.Thread.run(Thread.java:745)

heroghost commented 7 years ago

otter和node一起更换到4.2.13解决这个问题。据说是4.2.14的Bug

heroghost commented 7 years ago

image

我用这种映射方式，会报错 pid:1 nid:2 exception:setl:com.alibaba.otter.node.etl.transform.exception.TransformException: name is not found in column pairs: {id=[account_id]}