MYSQL主从复制GTID错误处理

解决MySQL GTID错误

最新推荐文章于 2025-05-20 00:46:03 发布

qq_28710983

最新推荐文章于 2025-05-20 00:46:03 发布

阅读量781

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL

本文链接：https://blog.youkuaiyun.com/qq_28710983/article/details/80914769

MySQL 专栏收录该内容

39 篇文章

订阅专栏

复制出错 |  SQL类出错 



GTID的错误

1:SQL类错误（主键冲突、表存在等）


查看到出错的信息
mysql> show slave status\G;



				Last_SQL_Error: Error 'Can't drop database 'def'; database doesn't exist' on query. Default database: 'def'. Query: 'drop database  def'
				Replicate_Ignore_Server_Ids: 
				Master_Server_Id: 100
                                Master_UUID: 753cfe11-7cd2-11e8-935c-d05349b146f5
				Master_Info_File: /usr/local/mysql/data/master.info
                                SQL_Delay: 0
				SQL_Remaining_Delay: NULL
				Slave_SQL_Running_State: 
				Master_Retry_Count: 86400
                                Master_Bind: 
				Last_IO_Error_Timestamp: 
				Last_SQL_Error_Timestamp: 180704 16:12:27
				Master_SSL_Crl: 
				Master_SSL_Crlpath: 
				Retrieved_Gtid_Set: 753cfe11-7cd2-11e8-935c-d05349b146f5:1-16  #当前正在执行的
				Executed_Gtid_Set: 1da4862e-7ece-11e8-a4da-000c290de34b:1-5,   #已经执行过


mysql> show variables like '%gtid%';


mysql> stop slave;
mysql> set gtid_next='753cfe11-7cd2-11e8-935c-d05349b146f5:16';
mysql> begin;
mysql> commit;
mysql> set gtid_next='AUTOMATIC';
mysql> start slave;



GTID相关参数
gtid_executed				执行过的所有GTID
gtid_purged					丢弃掉的GTID
gtid_mode					gtid模式
gtid_next					session级别的变量，下一个gtid
gtid_owned					正在运行的gtid
enforce_gtid_consistency	保证GTID安全的参数



出现这个错误
Last_SQL_Error: Error 'Can't drop database 'def'; database doesn't exist' on query. Default database: 'def'. Query: 'drop database  def'
mysql> stop slave;
mysql> create database def;
mysql> start slave;