For resolving above error run below command on MySql Slave Server:
mysql> stop slave;
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
mysql> start slave;
Then, check Slave status:
mysql> show slave status\G;
Now “Slave_IO_Running” and “Slave_SQL_Running” will be “Yes”.
wonderful!!! it works.... thanks a lot.
ReplyDeleteSeema