Bifrost icon indicating copy to clipboard operation
Bifrost copied to clipboard

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

Open Lxuty opened this issue 3 years ago • 1 comments

可能因为网络抖动或者网络拥塞导致,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连接时,如果检测到连接不存在,则主动发起重连机制。

Lxuty avatar May 27 '22 02:05 Lxuty

我也碰到了类似问题。 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位置也不再更新。

qw4285632q avatar Jul 04 '22 12:07 qw4285632q