Replication is not running all of a sudden! How to fix this?

[WorldNews]

Hello,

We have 2 servers in replication mode.
The Slave server all of a sudden is not getting updated with the data from Master. That is when one issues the command Show Slave Status on slave server all one sees is:
Seconds_Behind_Master: NULL

I am MySQL developer but not the MySQL Admin.
Our Admin is gone away for a long end of the year holidays, so I am at my wits end to get this URGENT problem fixed.

Your help in this matter is greatly appreciated.

[j3ph]

What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??

[WorldNews]

Hi,

MySQL running on Master & Slave server is:
mysql Ver 14.7 Distrib 4.1.11, for redhat-linux-gnu (i686)

About whether server was recently started, I think yes.

Well we have a start slave script, batch file to be exact, which I have issued many times. It is: start_slave
which contains this directive:

/usr/bin/mysql --user=root --password=xxxx95 --execute "SLAVE START;"

And still nothing, the Replication keeps not running, with this result:
Seconds_Behind_Master: NULL
indicating that Replication is not running.

Thanks for your help on this urgent matter.
BTW, I am prepared to pay you even to have this problem resolved at once since it is so urgent. I think it should not take more than 1 hour of some one who is really competent in MySQL with some expertise in Replication to figure out quickly want went wrong all of a sudden that has caused Replication to stop running.

Regards,

What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??

[WorldNews]

Hi,

Just wanted to let you know of some more related info.
I went MyTop and observed the MySQL processes running on Slave server,
and saw that it seems to be hanging at this point: That is at PID 8671

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
8674 root localhost test 0 Query show full processlist
8671 system us 200 Connec Has read all relay log; waiting for the slave I/O thread to up


In fact this process was up to 145000 Seconds until I killed it and re-started Slave. After I restarted Slave then again it started hanging at this process that is reporting:

Has read all relay log; waiting for the slave I/O thread to up

Regards,

What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??