資源描述：
《mysql5.6gtid模式同步復(fù)制報(bào)錯(cuò)不能跳過解決方法》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、MySQL5.6GTID模式，同步復(fù)制報(bào)錯(cuò)不能跳過解決方法。數(shù)據(jù)庫版本：mysql>selectversion();+------------+
2、version()
3、+------------+
4、5.6.10-log
5、+------------+1rowinset(0.02sec)同步復(fù)制信息：mysql>showslavestatusG;***************************1.row***************************Slave_IO_State:WaitingformastertosendeventMaster_Host:192.168
6、.8.25Master_User:replMaster_Port:3306Connect_Retry:60Master_Log_File:mysql-bin.000007Read_Master_Log_Pos:5036Relay_Log_File:M2-relay-bin.000008Relay_Log_Pos:408Relay_Master_Log_File:mysql-bin.000007Slave_IO_Running:YesSlave_SQL_Running:NoReplicate_Do_DB:Replicate_Ignore_DB:mysqlReplicate_Do_
7、Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno:1062Last_Error:CouldnotexecuteWrite_rowseventontabletest.t;Duplicateentry'12'forkey'PRIMARY',Error_code:1062;handlererrorHA_ERR_FOUND_DUPP_KEY;theevent'smasterlogmysql-bin.000007,end_log_pos2267Skip_C
8、ounter:0Exec_Master_Log_Pos:2045Relay_Log_Space:3810Until_Condition:NoneUntil_Log_File:Until_Log_Pos:0Master_SSL_Allowed:NoMaster_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert:Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master:NULLMaster_SSL_Verify_Server_Cert:NoLast_IO_Errno:0Last_IO_E
9、rror:Last_SQL_Errno:1062Last_SQL_Error:CouldnotexecuteWrite_rowseventontabletest.t;Duplicateentry'12'forkey'PRIMARY',Error_code:1062;handlererrorHA_ERR_FOUND_DUPP_KEY;theevent'smasterlogmysql-bin.000007,end_log_pos2267Replicate_Ignore_Server_Ids:Master_Server_Id:25Master_UUID:cf716fda-74e2-1
10、1e2-b7b7-000c290a6b8fMaster_Info_File:/usr/local/mysql/data2/master.infoSQL_Delay:0SQL_Remaining_Delay:NULLSlave_SQL_Running_State:Master_Retry_Count:86400Master_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:13031307:24:43Master_SSL_Crl:Master_SSL_Crlpath:Retrieved_Gtid_Set:cf716fda-
11、74e2-11e2-b7b7-000c290a6b8f:141-151Executed_Gtid_Set:cf716fda-74e2-11e2-b7b7-000c290a6b8f:1-140Auto_Position:11rowinset(0.02sec)ERROR:Noqueryspecified提示主鍵沖突，由于是測(cè)試機(jī)，于是我直接跳過，mysql>setglobalsql_slave_skip_counter=1;ERROR1858(HY000):sql_slave_skip_coun
