Closed tianfengLiang closed 2 weeks ago
adapter日志文件打印如下： 2024-11-08 10:17:48.456 [pool-3-thread-1] DEBUG c.a.o.canal.client.adapter.es.core.service.ESSyncService - DML: {"data":null,"database":"test","destination":"search","es":17310322681111,"groupId":"g1","isDdl":false,"old":null,"pkNames":[],"sql":"UPDATE kl_doc SET view_count = view_count + 1 WHERE del_flag = '0' AND (id = 86)","table":"starms_kl_doc","ts":1731032268456,"type":"UPDATE"} Affected indexes: kl_doc 其中data字段为空，没捕捉到变动，所以es没更新么，是不是必须把binlog格式修改为row
Question
adapter日志文件打印如下： 2024-11-08 10:17:48.456 [pool-3-thread-1] DEBUG c.a.o.canal.client.adapter.es.core.service.ESSyncService - DML: {"data":null,"database":"test","destination":"search","es":17310322681111,"groupId":"g1","isDdl":false,"old":null,"pkNames":[],"sql":"UPDATE kl_doc SET view_count = view_count + 1 WHERE del_flag = '0' AND (id = 86)","table":"starms_kl_doc","ts":1731032268456,"type":"UPDATE"} Affected indexes: kl_doc 其中data字段为空，没捕捉到变动，所以es没更新么，是不是必须把binlog格式修改为row