怎么解决Mysql中的Last_Errno报错问题
本篇内容主要讲解“怎么解决Mysql中的Last_Errno报错问题”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“怎么解决Mysql中的Last_Errno报错问题”吧!
具体的报错信息Master_Log_File:mysql-bin.000283Read_Master_Log_Pos:715296037Relay_Log_File:relay-log.000294Relay_Log_Pos:245347818Relay_Master_Log_File:mysql-bin.000283Slave_IO_Running:NoSlave_SQL_Running:NoReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:mysql.%,test.%Last_Errno:1755Last_Error:Cannotexecutethecurrenteventgroupintheparallelmode.EncounteredeventStop,relay-logname./relay-log.000294,position245347905whichpreventsexecutionofthiseventgroupinparallelmode.Reason:possiblemalformedgroupofeventsfromanoldmaster.Skip_Counter:0Exec_Master_Log_Pos:245347659Relay_Log_Space:715297197Until_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_Error:Last_SQL_Errno:1755Last_SQL_Error:Cannotexecutethecurrenteventgroupintheparallelmode.EncounteredeventStop,relay-logname./relay-log.000294,position245347905whichpreventsexecutionofthiseventgroupinparallelmode.Reason:possiblemalformedgroupofeventsfromanoldmaster.Replicate_Ignore_Server_Ids:Master_Server_Id:2331597761Master_UUID:75f94423-e1c1-11e5-8da4-70e2840af125Master_Info_File:/ssd/mysql/mysql_48284/var/master.infoSQL_Delay:0SQL_Remaining_Delay:NULLSlave_SQL_Running_State:Semi_Sync_Group:Master_Retry_Count:86400Master_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:16031115:54:17Master_SSL_Crl:Master_SSL_Crlpath:Retrieved_Gtid_Set:Executed_Gtid_Set:Auto_Position:0
如上报错后,可stop slave后,将slave_parallel_workers设置为0,关闭并行复制,然后再start slave后,重新开启并行复制就没有问题。
到此,相信大家对“怎么解决Mysql中的Last_Errno报错问题”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。