CanalParseException: java.io.IOException: ErrorPac

环境信息

canal version 1.0.26 mysql version 5.6

问题描述

2018-12-19 18:18:22.808 [destination = example , address = xxxxx.aliyuncs.com/xxxxx:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address haozu-xxx.mysql.rds.aliyuncs.com/xxxx:3306 has an error, retrying. caused by com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'xxx'@'xxxx' for table 'slow_log', sqlState=42000, sqlStateMarker=#] with command: show create table mysql.event;show create table mysql.func;show create table mysql.general_log;show create table mysql.help_category;show create table mysql.help_keyword;show create table mysql.help_relation;show create table mysql.help_topic;show create table mysql.proc;show create table mysql.slow_log;show create table mysql.time_zone;show create table mysql.time_zone_leap_second;show create table mysql.time_zone_name;show create table mysql.time_zone_transition;show create table mysql.time_zone_transition_type; Caused by: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'xxx'@'xxxx' for table 'slow_log', sqlState=42000, sqlStateMarker=#] with command: show create table mysql.event;show create table mysql.func;show create table mysql.general_log;show create table mysql.help_category;show create table mysql.help_keyword;show create table mysql.help_relation;show create table mysql.help_topic;show create table mysql.proc;show create table mysql.slow_log;show create table mysql.time_zone;show create table mysql.time_zone_leap_second;show create table mysql.time_zone_name;show create table mysql.time_zone_transition;show create table mysql.time_zone_transition_type; at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.queryMulti(MysqlQueryExecutor.java:109) ~[canal.parse.driver-1.0.26-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.queryMulti(MysqlConnection.java:99) ~[canal.parse-1.0.26-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:173) ~[canal.parse-1.0.26-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) ~[canal.parse-1.0.26-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) ~[canal.parse-1.0.26-SNAPSHOT.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) ~[canal.parse-1.0.26-SNAPSHOT.jar:na] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_151]

原提问者GitHub用户xinyangbest