#1  
Old 15th March 2012, 09:54
cgorms cgorms is offline
Junior Member
 
Join Date: Mar 2012
Posts: 13
Thanks: 6
Thanked 0 Times in 0 Posts
Default Slave not syncing

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?
Reply With Quote
Sponsored Links
  #2  
Old 15th March 2012, 09:55
cgorms cgorms is offline
Junior Member
 
Join Date: Mar 2012
Posts: 13
Thanks: 6
Thanked 0 Times in 0 Posts
Default

Also I have noticed that the "Jobqueue" is not being processed on the slave
Reply With Quote
  #3  
Old 15th March 2012, 11:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,678
Thanks: 819
Thanked 5,318 Times in 4,171 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
cgorms (16th March 2012)
  #4  
Old 15th March 2012, 16:01
cgorms cgorms is offline
Junior Member
 
Join Date: Mar 2012
Posts: 13
Thanks: 6
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5  
Old 15th March 2012, 16:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,678
Thanks: 819
Thanked 5,318 Times in 4,171 Posts
Default

Quote:
Only slave should have "Network Configuration" checked, also should the slave have an extra eth0:0 entry?
Dont use network configuration on mirrored setups on master or slave server.

Quote:
What should be in the /etc/resolv.conf file the local DNS 127.0.0.1 or the actual network DNS Servers?
The actual dns network servers.

Quote:
Also is there a way to clear the job queue? I have a job in there since this morning which will not go away:
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
cgorms (16th March 2012)
  #6  
Old 15th March 2012, 16:40
cgorms cgorms is offline
Junior Member
 
Join Date: Mar 2012
Posts: 13
Thanks: 6
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #7  
Old 15th March 2012, 16:53
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,678
Thanks: 819
Thanked 5,318 Times in 4,171 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following 2 Users Say Thank You to till For This Useful Post:
cgorms (16th March 2012), jtheed (23rd April 2012)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues with dummy slave mkreder Installation/Configuration 5 6th March 2012 10:00
Master failed -promote slave Toucan General 5 17th May 2011 09:31
Slave PowerDNS server does not respond/Security Linox91 Installation/Configuration 18 17th March 2011 05:16
MySQL Database Replication Problem black_magik HOWTO-Related Questions 11 6th July 2010 14:16
Pri & Slave DNS HOWTO (FC4) ppettigrew Suggest HOWTO 0 1st April 2006 15:35


All times are GMT +2. The time now is 06:48.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.