mysql gtid 1236错误_解决mysql开启GTID主从同步出现1236错误问题

1、报错如下

Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.'

2、问题解决：

查看master gtid_purged

show global variables like '%gtid%';

找到gtid_purged的值

3、从库执行：

mysql> stop slave;

Query OK, 0 rows affected (0.18 sec)

mysql> reset slave;

Query OK, 0 rows affected (1.29 sec)

mysql> reset master;

Query OK, 0 rows affected (1.18 sec)

mysql> set @@global.gtid_purged='你的GITD值';

Query OK, 0 rows affected (2.12 sec)

mysql> change master to master_host='MASTER_IP',master_port=PORT,master_user='USERNAME',master_password='PASSWORD',master_auto_position=1;

Query OK, 0 rows affected, 2 warnings (5.55 sec)

mysql> start slave;

Query OK, 0 rows affected (0.40 sec)

mysql> show slave status \G

*************************** 1. row ***************************

Slave_IO_State: Queueing master event to the relay log

Master_Host: xxx

Master_User: xxx

Master_Port: xxx

Connect_Retry: 60

Master_Log_File: mysql-bin.002188

Read_Master_Log_Pos: 4925243

Relay_Log_File: mysql-relay.000002

Relay_Log_Pos: 117539

Relay_Master_Log_File: mysql-bin.002188

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB: xxx

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:xxx

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 117489

Relay_Log_Space: 4925493

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 73626

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: xxx

Master_UUID: xxx

Master_Info_File: /data02/mysql/master.info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: System lock

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set: xxx

Executed_Gtid_Set: GTID值

Auto_Position: 1

1 row in set (0.45 sec)

注意：设置gtid_purged值时，gtid_executed值必须为空否则报错，该值清空的方法就是reset  master命令