Skip to content

启动deployer日志中出现druid解析sql错误信息 #4899

@Dkbei

Description

@Dkbei

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出现,异常出现时不影响数据同步

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions