DTStack / DTStack/chunjun

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

Open
#1,895 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [X] I had searched in the [issues](https://github.com/DTStack/chunjun/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](https://github.com/DTStack/chunjun/assets/73479298/caf83b26-b573-4282-a1c2-4699869af9ab)

经排查为chunjun的binlog connector使用的是canal1.1.6,对 mysql 8.0 版本的binlog部分格式无法识别,在canal1.1.7修复了这个问题。
[canal1.1.7](https://github.com/alibaba/canal/releases/tag/canal-1.1.7)

### What you expected to happen

正常打印数据变更记录。
![image](https://github.com/DTStack/chunjun/assets/73479298/b1682bf5-1d32-4eac-ad60-1a75ae14bf9a)

### 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

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.