SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,027
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

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

    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.

    Anoox search engine volunteer

    www.anoox.com

  2. #2
    SitePoint Zealot j3ph's Avatar
    Join Date
    Jan 2006
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??

  3. #3
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,027
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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,



    Quote Originally Posted by j3ph View Post
    What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??

    Anoox search engine volunteer

    www.anoox.com

  4. #4
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,027
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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,


    Quote Originally Posted by j3ph View Post
    What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??

    Anoox search engine volunteer

    www.anoox.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •