[alibaba/canal]启动deployer日志中出现druid解析sql错误信息

2024-07-22 386 views
4

com.alibaba.druid.sql.parser.ParserException: illegal name, pos 24488, line 623, column 3, token TO at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:2370) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:981) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:435) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:296) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:245) at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:599) at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:468) at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:85) at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.buildMemFromSnapshot(DatabaseTableMeta.java:423) at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:166) at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:142) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:192) at java.lang.Thread.run(Thread.java:748) 2023-10-07 19:11:44.925 [destination = xx.xx.xx.xx, address = /xx.xx.xx.xx:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.000094,position=63919272,serverId=1,gtid=,timestamp=1696677103000] cost : 64ms , the next step is binlog dump

canal版本:canal-1.1.7-alpha-3 mysql版本: 5.6.41 deployer启动后好像需要通过druid解析一些建表sql,导致waraing info出现,异常出现时不影响数据同步

回答

1

希望大佬能看到,并进行回复,如果解决这种问题呢?

0

具体报错的日志没发出来啊,SQL解析报错的语句是啥

2

测试了,1.1.5 版本启动后正常打开了11112端口的

8

一样的错误,这样的日志真的没法调试...

7

看起来 oozie_email 这个表的 to 字段名是 MySQL 保留字,druid sql 解析失败