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

因为mysql端failed on flush_net()导致的CDC中断 #188

Open
Lxuty opened this issue May 27, 2022 · 1 comment
Open

因为mysql端failed on flush_net()导致的CDC中断 #188

Lxuty opened this issue May 27, 2022 · 1 comment

Comments

@Lxuty
Copy link
Contributor

Lxuty commented May 27, 2022

可能因为网络抖动或者网络拥塞导致,mysql端发送数据包至bifrost时中断,但是bifrost端没感知。

mysql端报错为:
2022-05-26T01:11:21.005275+08:00 872213 [Note] Stop asynchronous binlog_dump to slave (server_id: 279)
2022-05-26T01:11:21.005483+08:00 872213 [Note] Aborted connection 872213 to db: 'xxx' user: 'root' host: '10.6.53.209' (failed on flush_net())

bifrost端报错为:
This.mysqlConn close, connectionID: 872213

原因为:bifrost的dump主线程中因为这种特殊情况并未收到EOF信号,所以并未启动重连。

建议修复:checkDumpConnection 后台检测dump连接时,如果检测到连接不存在,则主动发起重连机制。

@qw4285632q
Copy link

我也碰到了类似问题。
2022/07/03 19:09:30 channel default consume_channel over; CurrentThreadNum: 1
2022/07/03 19:09:30 channelConsume err: runtime error: invalid memory address or nil pointer dereference
2022/07/03 19:52:32 This.mysqlConn close ,connectionId: 3751278
BIF监控界面显示connstatus为running但是流量为0,position位置也不再更新。

This was referenced Sep 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants