2018-02-12 11:38:47.267 [destination = example , address = rm-xxxxx.mysql.rds.aliyuncs.com/47.206.15.124:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:example[com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'canal_monitor'@'122.177.246.186' for table 'db', sqlState=42000, sqlStateMarker=#] with command: show create table mysql.columns_priv;show create table mysql.db;show create table mysql.db_view;show create table mysql.dml_health_check;show create table mysql.event;show create table mysql.failover_info;show create table mysql.func;show create table mysql.general_log;show create table mysql.ha_health_check;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.innodb_index_stats;show create table mysql.innodb_table_stats;show create table mysql.ndb_binlog_index;show create table mysql.plugin;show create table mysql.proc;show create table mysql.procs_priv;show create table mysql.proxies_priv;show create table mysql.servers;show create table mysql.slave_master_info;show create table mysql.slave_relay_log_info;show create table mysql.slave_worker_info;show create table mysql.slow_log;show create table mysql.slow_log_view;show create table mysql.tables_priv;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;show create table mysql.user;show create table mysql.user_view; Caused by: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'canal_monitor'@'122.177.246.186' for table 'db', sqlState=42000, sqlStateMarker=#] with command: show create table mysql.columns_priv;show create table mysql.db;show create table mysql.db_view;show create table mysql.dml_health_check;show create table mysql.event;show create table mysql.failover_info;show create table mysql.func;show create table mysql.general_log;show create table mysql.ha_health_check;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.innodb_index_stats;show create table mysql.innodb_table_stats;show create table mysql.ndb_binlog_index;show create table mysql.plugin;show create table mysql.proc;show create table mysql.procs_priv;show create table mysql.proxies_priv;show create table mysql.servers;show create table mysql.slave_master_info;show create table mysql.slave_relay_log_info;show create table mysql.slave_worker_info;show create table mysql.slow_log;show create table mysql.slow_log_view;show create table mysql.tables_priv;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;show create table mysql.user;show create table mysql.user_view; at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.queryMulti(MysqlQueryExecutor.java:109) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.queryMulti(MysqlConnection.java:93) at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:173) at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) at java.lang.Thread.run(Thread.java:748)
原提问者GitHub用户millinchen
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。