我在主库insert一条数据后(insert的是一个业务表),就报错,报错的内容,涉及很多mysql的内部表,重启canan server、mysql、重置position均无效。只要主库有insert,update等,都报这个错
2018-01-04 20:51:50.268 [destination = example , address = /10.30.255.151:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address /10.30.255.151:3306 has an error, retrying. caused by com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: ErrorPacket [errorNumber=1146, fieldCount=-1, message=Table 'mysql.innodb_index_stats' doesn't exist, sqlState=42S02, sqlStateMarker=#] with command: show create table mysql.columns_priv;show create table mysql.db;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.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.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; Caused by: java.io.IOException: ErrorPacket [errorNumber=1146, fieldCount=-1, message=Table 'mysql.innodb_index_stats' doesn't exist, sqlState=42S02, sqlStateMarker=#] with command: show create table mysql.columns_priv;show create table mysql.db;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.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.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; 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:94) ~[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:745) [na:1.8.0_60]
原提问者GitHub用户rainLeelzr
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。