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.

Sign up for GitHub

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

Jump to bottom

Canal1.1.5+MySQL8.0.28日志不停的刷WARN:Skipping unrecognized binlog event Unknown from: binlog.000005:20824 #4047

Closed
Sakura9797 opened this issue Jan 29, 2022 · 2 comments
Closed

Canal1.1.5+MySQL8.0.28日志不停的刷WARN:Skipping unrecognized binlog event Unknown from: binlog.000005:20824 #4047

Sakura9797 opened this issue Jan 29, 2022 · 2 comments

Comments

@Sakura9797
Copy link

Sakura9797 commented Jan 29, 2022 •
edited
Loading

最近在学习canal的时候遇到了这个问题，日志摘取如下图
image
另外我看了下我数据库中的binlog，发现最新的binlog的pos只到了20793，没有20824
image
另外结合canal的源码得知header.getLogPos()拿的是下一条日志的pos，于是我猜想是不是canal同步binlog的时候会拿到最新一条binlog的下一条，而下一条binlog实际上并不存在，所以报了这个错误呢（瞎猜的）？大家有没有遇到这种情况呢
image
@xiaoma20082008
Copy link
Contributor

应该跟这两个有关 #3975 #3976

@agapple
Copy link
Member

agapple commented May 16, 2022

LS正解

@agapple agapple closed this as completed May 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@agapple @xiaoma20082008 @Sakura9797