使用canal.adapter-1.1.5 同步mysql 5.6.16版本。目标数据库没有数据同步,查看adapter.log 有DML 日志输出,。如下:
2021-10-09 00:55:11.722 [pool-85-thread-1] INFO c.a.o.canal.client.adapter.logger.LoggerAdapterExample - DML: {"data":[{"id":5688712,"creater_name":"用户","create_time":1633712111000,"bind_time":1633712111000,"lock_time":null,"lock_fail_cnt":0,"lock_fail_desc":null,"status":1}],"database":"core","destination":"example","es":1633712111000,"groupId":"g1","isDdl":false,"old":null,"pkNames":["id"],"sql":"","table":"device_bind_sim","ts":1633712111722,"type":"INSERT"}
2021-10-09 00:55:11.724 [pool-14-thread-1] DEBUG c.a.o.canal.client.adapter.rdb.service.RdbSyncService - DML: {"data":{"id":5688712,"creater_name":"用户","create_time":1633712111000,"bind_time":1633712111000,"lock_time":null,"lock_fail_cnt":0,"lock_fail_desc":null,"status":1},"database":"core","destination":"example","old":null,"table":"device_bind_sim","type":"INSERT"}
已开启binlog
binlog_format : ROW
4条答案
按热度按时间bz4sfanl1#
不知道你描述的问题是什么
niknxzdl2#
我也碰到同样的问题,就是adapter收到了dml变更日志,但数据没有同步写入到es中
n53p2ov03#
我也是,也不报错,头大
ttp71kqs4#
应该是es的配置有问题