开发者社区> 问答> 正文

canal server同步主库时,报错com.alibaba.otter.canal.parse.

我在主库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

展开
收起
绿子直子 2023-05-09 11:55:48 128 0
1 条回答
写回答
取消 提交回答
  • 没权限吧

    原回答者GitHub用户agapple

    2023-05-10 10:22:03
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载