canal ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - parse events has an error

wz8daaqr  于 4个月前  发布在  Mysql
关注(0)|答案(5)|浏览(79)

canal-admin 1.1.5
canal.deployer-1.1.5
配置了实例,启动报错
2022-06-27 15:30:02.455 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Properties resource not found: class path resource [myexample2/instance.properties] cannot be opened because it does not exist
2022-06-27 15:30:02.539 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Properties resource not found: class path resource [myexample2/instance.properties] cannot be opened because it does not exist
2022-06-27 15:30:02.756 [main] INFO c.a.otter.canal.instance.spring.CanalInstanceWithSpring - start CannalInstance for 1-myexample2
2022-06-27 15:30:02.760 [main] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^...$
2022-06-27 15:30:02.760 [main] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table black filter :
2022-06-27 15:30:02.762 [main] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - start successful....
2022-06-27 15:30:02.764 [destination = myexample2 , address = null , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - parse events has an error
com.alibaba.otter.canal.parse.exception.CanalParseException: illegal connection is null
2022-06-27 15:30:02.886 [canal-instance-scan-0] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop CannalInstance for null-myexample2
2022-06-27 15:30:02.892 [canal-instance-scan-0] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop successful....

请问这个问题怎么解决?

c2e8gylq

c2e8gylq2#

看下destinations的配置

s4n0splo

s4n0splo3#

@yreezy 本地启动了

w6mmgewl

w6mmgewl4#

canal.destinations = example,myexample3,user1,user0624,myexample2,myexample4,myexample5
@yreezy

wooyq4lh

wooyq4lh5#

@yreezy 在admin控制后增加了destinations,同时在canal.properties增加了,在admin控制台是重启server:canal 重启是不起作用的,不能创建目录。需要手动重启deployer才能创建目录。

业务后续单独同步表是不能事先知道表名的,不可能提前把所有目录创建出来。

当配置myexample8时

在admin重启canal,conf目录下myexample8目录没有创建出来。

相关问题