Backup stopped working !! Slave_SQL_Running: No

Hello everyone,

My latest issues are just piling up and i am not able to get them all sorted :frowning:

To add to my chaos, now my backup server too is giving me issues.

When i run the command :-

TheSlave|mysql> SHOW SLAVE STATUS \G
...
Slave_IO_Running: Yes
Slave_SQL_Running: No

see that "Slave_SQL_Running" is “NO” !!

i tried to stop and start the replication service, but in vein :frowning:

My log files are throwing up this error :-


tail -f /var/log/messages

Oct 8 13:32:37 DatabackupSRV xinetd[3396]: EXIT: nrpe status=0 pid=3295 duration=0(sec)
Oct 8 13:34:19 DatabackupSRV xinetd[3396]: START: nrpe pid=3300 from=10.222.32.22
Oct 8 13:34:19 DatabackupSRV xinetd[3396]: EXIT: nrpe status=0 pid=3300 duration=0(sec)
Oct 8 13:34:29 DatabackupSRV xinetd[3396]: START: nrpe pid=3305 from=10.222.32.22
Oct 8 13:34:29 DatabackupSRV xinetd[3396]: EXIT: nrpe status=0 pid=3305 duration=0(sec)

It was working all this while, But i guess the recent start / stop of mysql services and the server of the master is causing this issue.

Any suggestions to rectify this would be of great help.

Thank you