canal 日志反馈正常,数据没有同步

9gm1akwq  于 2022-04-21  发布在  Java
关注(0)|答案(4)|浏览(539)

使用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

bz4sfanl

bz4sfanl1#

不知道你描述的问题是什么

niknxzdl

niknxzdl2#

我也碰到同样的问题,就是adapter收到了dml变更日志,但数据没有同步写入到es中

n53p2ov0

n53p2ov03#

我也是,也不报错,头大

ttp71kqs

ttp71kqs4#

应该是es的配置有问题

相关问题