Replication 1062&1205&1213错误解决
Replication 1062错误解决
Stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;
Start slave;
mysql> show slave status\G
Replication 1205错误解决
Last_Errno: 1205
Last_Error: Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'PIXOS_DB'.
Rep解决方法 直接start slave；
Replication 1213错误解决
Last_Errno: 1213
Last_Error: Error 'Deadlock found when trying to get lock; try restarting transaction' on query. Default database: 'PIXOS_DB'. Query: 'UPDATE TB_JOB SET VR_JOB_ISFACCEPTNO = 'PIFW83957426077'
, DT_JOB_ISFACCEPTDATE = '2010.06.17'
WHERE ID_JOB = 583238'
Rep解决方法 直接start slave；
Stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;
Start slave;
mysql> show slave status\G
Replication 1205错误解决
Last_Errno: 1205
Last_Error: Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'PIXOS_DB'.
Rep解决方法 直接start slave；
Replication 1213错误解决
Last_Errno: 1213
Last_Error: Error 'Deadlock found when trying to get lock; try restarting transaction' on query. Default database: 'PIXOS_DB'. Query: 'UPDATE TB_JOB SET VR_JOB_ISFACCEPTNO = 'PIFW83957426077'
, DT_JOB_ISFACCEPTDATE = '2010.06.17'
WHERE ID_JOB = 583238'
Rep解决方法 直接start slave；
评论
发表评论