Slave not syncing

Discussion in 'General' started by cgorms, Mar 15, 2012.

  1. cgorms

    cgorms New Member

    My slave server is not updating. I have received various errors over the last couple of hours:

    DB::connect()-> mysql_select_db MySQL server has gone away
    Unable to connect to master server

    What have a done wrong? The slave server will not see the master unless I remove all DNS servers from /etc/resolv.conf

    I have also notice on the slave eth0 is a entry for the master ip address eth0:0 is this normal?
     
  2. cgorms

    cgorms New Member

    Also I have noticed that the "Jobqueue" is not being processed on the slave
     
  3. till

    till Super Moderator

    If you use a mirror setup, then check that the "Network configuration" checkbox is not enabled on the mster.Otherwise the network configuration is mirrored from master to slave too. After you disabled that checkbox, restore the original network configuration on the slave and ensure that the /etc/hosts files on master and slave contain the correct records for master and slave server as described in the multiserver tutorials.
     
  4. cgorms

    cgorms New Member

    Hi Till,

    Again thank you very much for you response. So just to clarify:

    Only slave should have "Network Configuration" checked, also should the slave have an extra eth0:0 entry?

    What should be in the /etc/resolv.conf file the local DNS 127.0.0.1 or the actual network DNS Servers?

    Also is there a way to clear the job queue? I have a job in there since this morning which will not go away:

    2012-03-15 08:44 - server1.example.local - Update - server
     
  5. till

    till Super Moderator

    Dont use network configuration on mirrored setups on master or slave server.

    The actual dns network servers.

    The jobqueue will get cleared as soon as your setup is fixed. Dont try to delete any records manually in the database as this will mess up the transaction system.
     
  6. cgorms

    cgorms New Member

    That's great I have made those amendments but the job it keeps trying to process is produces these errors, including this additional eth0:0 on the slave.

    Changed Network settings
    SIOCDELRT: No such device
    DB::connect()-> mysql_select_db MySQL server has gone away
    Segmentation fault
     
  7. till

    till Super Moderator

    Set the filed updated in the ispconfig server table to the hghest datalog_ifd that you find in the sys_datalog table to skip all pending changes.
     

Share This Page