开发者社区 问答 正文

求助,启动canal server后报错

2017-11-13 10:41:41.588 [destination = example , address = /127.0.0.1:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : flush privileges com.alibaba.druid.sql.parser.ParserException: syntax error, expect TABLES, actual IDENTIFIER, pos 16, line 1, column 6, token IDENTIFIER privileges at com.alibaba.druid.sql.parser.SQLParser.acceptIdentifier(SQLParser.java:60) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseFlush(MySqlStatementParser.java:915) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseStatementListDialect(MySqlStatementParser.java:762) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:388) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:461) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:67) ~[canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.applyHistoryOnMemory(DatabaseTableMeta.java:387) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:121) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25-SNAPSHOT.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121] 2017-11-13 10:41:41.590 [destination = example , address = /127.0.0.1:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : flush privileges com.alibaba.druid.sql.parser.ParserException: syntax error, expect TABLES, actual IDENTIFIER, pos 16, line 1, column 6, token IDENTIFIER privileges at com.alibaba.druid.sql.parser.SQLParser.acceptIdentifier(SQLParser.java:60) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseFlush(MySqlStatementParser.java:915) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseStatementListDialect(MySqlStatementParser.java:762) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:388) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:461) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.5.jar:1.1.5] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:67) ~[canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.applyHistoryOnMemory(DatabaseTableMeta.java:387) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:121) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25-SNAPSHOT.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]

原提问者GitHub用户loveluckystar

展开
收起
绿子直子 2023-05-09 12:00:50 143 分享 版权
1 条回答
写回答
取消 提交回答
  • 这块只会记录异常日志,本身是try catch不影响功能

    原回答者GitHub用户agapple

    2023-05-10 11:07:31
    赞同 展开评论