chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard

[Bug] [chunjun-connector-binlog] Skipping unrecognized binlog event Unknown type:41 from: mysql-bin.xxx

Open Icarus-Alpha opened this issue 1 year ago • 1 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

What happened

mysql版本:8.0.31 当我使用local-test模式,运行example中binlog的同步任务时,无法正常解析binlog日志。

WARN com.taobao.tddl.dbsync.binlog.LogDecoder - Skipping unrecognized binlog event Unknown type:41 from: mysql-bin.000002:1963402 WARN com.taobao.tddl.dbsync.binlog.LogDecoder - Skipping unrecognized binlog event Unknown type:41 from: mysql-bin.000002:1963402 image

经排查为chunjun的binlog connector使用的是canal1.1.6,对 mysql 8.0 版本的binlog部分格式无法识别,在canal1.1.7修复了这个问题。 canal1.1.7

What you expected to happen

正常打印数据变更记录。 image

How to reproduce

使用mysql版本8.0.31,运行binlog_stream.json

Anything else

No response

Version

master

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

Icarus-Alpha avatar Apr 26 '24 07:04 Icarus-Alpha

我也遇到了这个warn: Skipping unrecognized binlog event Unknown type:41 from: mysql-bin.000002:1963402,而且任务正常运行,但是binlog不采集了,canal版本是1.1.6,请问1.1.7能解决么?

maikouliujian avatar Aug 28 '24 02:08 maikouliujian