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

您所在的位置:网站首页 mysql更换端口 同步部署在docker中的mysql时canal连接异常

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

2023-06-04 00:18| 来源: 网络整理| 查看: 265

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;   //  根据实际修改



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3