mysql error 1236_解决MySQL数据库同步1236错误

mysql>stop slave;

Query OK,0 rows affected (0.18sec)

mysql>reset slave;

Query OK,0 rows affected (1.29sec)

mysql>reset master;

Query OK,0 rows affected (1.18sec)

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

Query OK,0 rows affected (2.12sec)

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.55sec)

mysql>start slave;

Query OK,0 rows affected (0.40sec)

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:60Master_Log_File: mysql-bin.002188Read_Master_Log_Pos:4925243Relay_Log_File: mysql-relay.000002Relay_Log_Pos:117539Relay_Master_Log_File: mysql-bin.002188Slave_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:0Last_Error:

Skip_Counter:0Exec_Master_Log_Pos:117489Relay_Log_Space:4925493Until_Condition: None

Until_Log_File:

Until_Log_Pos:0Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master:73626Master_SSL_Verify_Server_Cert: No

Last_IO_Errno:0Last_IO_Error:

Last_SQL_Errno:0Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id:xxxMaster_UUID: xxxMaster_Info_File:/data02/mysql/master.infoSQL_Delay:0SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: System lock

Master_Retry_Count:86400Master_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)