开发者社区> 问答> 正文

使用canal同步数据的时候,在连接mysql数据库连接不上?报错

2017-08-01 09:27:36.766 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [canal.properties]
2017-08-01 09:27:36.770 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [example/instance.properties]
2017-08-01 09:27:36.850 [main] WARN org.springframework.beans.TypeConverterDelegate - PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
2017-08-01 09:27:36.971 [main] INFO c.a.otter.canal.instance.spring.CanalInstanceWithSpring - start CannalInstance for 1-example
2017-08-01 09:27:36.987 [main] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - start successful....
2017-08-01 09:27:44.004 [destination = example , address = /192.168..:**** , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address /192.168.30.46:3306 has an error, retrying. caused by
com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: connect /192.168..:**** failure:java.net.ConnectException: Connection timed out
at sun.nio.ch.Net.connect0(Native Method)
at sun.nio.ch.Net.connect(Net.java:364)
at sun.nio.ch.Net.connect(Net.java:356)
at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:623)
at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect(MysqlConnector.java:70)
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.connect(MysqlConnection.java:56)
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.preDump(MysqlEventParser.java:86)
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:157)
at java.lang.Thread.run(Thread.java:722)
报错信息如上,我不知道是不是这个/的问题,但是我在配置文件并没有/的,看了源码也没有,不知道是什么原因,求助!!!!万分感谢

展开
收起
爱吃鱼的程序员 2020-06-08 11:56:03 2712 0
3 条回答
写回答
取消 提交回答
  • 连mysql太多报错 去mysql清理一下(flush hosts) 我的是mysql驱动不对

    2023-03-13 10:12:21
    赞同 展开评论 打赏
  • dump address /192.168.30.46:3306 你的地址是不是多了一个“/”,发配置文件看看

    2021-12-09 21:24:31
    赞同 展开评论 打赏
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    换个example试试

    回复 @OMBGZ:canal.destinations改个名你指的example是什么?
    2020-06-08 11:56:18
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
2022 DTCC-阿里云一站式数据库上云最佳实践 立即下载
云时代的数据库技术趋势 立即下载
超大型金融机构国产数据库全面迁移成功实践 立即下载

相关镜像