mysql 1932 1146错误处理—— 筑梦之路

报错信息：

Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist

Table 'mysql.gtid_slave_pos' doesn't exist in engine

分析思路：

查看报错表的信息，主要拍查该表是否不存在或者损坏

解决办法：

#查看表
use mysql;

show tables;

desc gtid_slave_pos;

#这里查看结果依然是报错,也没找到该表

#创建该表

CREATE TABLE `gtid_slave_pos` (
    `domain_id` int(10) unsigned NOT NULL,
    `sub_id` bigint(20) unsigned NOT NULL,
    `server_id` int(10) unsigned NOT NULL,
    `seq_no` bigint(20) unsigned NOT NULL,
    PRIMARY KEY (`domain_id`,`sub_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Replication slave GTID state';


#查看验证
desc gtid_slave_pos;

参考：

MySQL主从报错解决：Table ‘mysql.gtid_slave_pos’ doesn’t exist_数据库-免费资源网