Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
2 of 3 tasks
Icarus-Alpha opened this issue Apr 26, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@Icarus-Alpha
Copy link

Search before asking

  • 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 Icarus-Alpha added the bug Something isn't working label Apr 26, 2024
@maikouliujian
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
2 participants