同步部署在docker中的mysql时canal连接异常

mysql 版本 5.7.41
canal 版本 canal.deployer-1.1.6

java.io.IOException: connect /127.0.0.1:3306 failure
at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect(Mysqlconnector.java:85)[canal.parse.driver-1.1.6.jar.bak:na]
at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.reconnect(Mysqlconnector.java:94)[canal.parse.driver-1.1.6.jar.bak:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnector.reconnect(Mysqlconnector.java:93)[canal.parse-1.1.6.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParse$MysqlDetectingTimeTask.run(MysqlEventParse.java:229)[canal.parse.1.1.6.jar:na]
at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_301]
at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_301]
Caused by: java.net.SocketTimeoutException: Timeout occurred, failed to read total 4 bytes in 5000 milliseconds, actual read only 0 bytes
at com.alibaba.otter.canal.parse.driver.mysql.socket.BioSocketChannel.read(BioSocketChannel.java:91)[canal.parse.driver-1.1.6.jar.bak:na]
at com.alibaba.otter.canal.parse.driver.mysql.utils.PacketManager.readHeader(PacketManager.java:19)[canal.parse.driver-1.1.6.jar.bak:na]
at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.negotiate(MysqlConnector.java:162)[canal.parse.driver-1.1.6.jar.bak:na]
at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect(MysqlConnector.java:82)[canal.parse.driver-1.1.6.jar.bak:na]

原因:socket连接超时,暂时没尝试canal也打包到docker

解决方法:  重新编译lib/canal.parse.driver-1.1.6.jar  

源码位置:driver\src\main\java\com\alibaba\otter\canal\parse\driver\mysql\socket\BioSocketChannel.java     

修改变量:

static final int     DEFAULT_CONNECT_TIMEOUT = 10 * 60000;   //  根据实际修改

static final int     SO_TIMEOUT              = 60000;   //  根据实际修改

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值