#1  
Old 20th May 2010, 11:01
lifeisboost lifeisboost is offline
Senior Member
 
Join Date: Feb 2006
Posts: 122
Thanks: 0
Thanked 2 Times in 2 Posts
Default Major bug?

tonight i was working on our master server. I took it offline for a little bit and noticed something odd of all the slaves.

If a slave cannot connect to a master it crashes. The slaves are trying to constantly connect to the master with

Code:
DBI connect('database=dbispconfig;host=lb1a.xxxxxx.com:3306','ispcsrv5',...) fai$
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 255.
this happens every second it seems. when this does all apache2 servers crash with a max open failure and then an internal 500 error.

of course once the master is online and you restart apache on the slaves all is well. any thoughts on this? am i over looking something that would stop the slaves from causing the 500 error?

as it looks it does not allow you to mirror and then provide fail over as the slave is always looking for the master. if the master does in fact come offline for maintenance all slaves then crash
Reply With Quote
Sponsored Links
  #2  
Old 20th May 2010, 11:31
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,555
Thanks: 791
Thanked 4,977 Times in 3,899 Posts
Default

Looks as if the vlogger application does not handle DB errors correctly. What is the exact error message of this 500 error in the mail log?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th May 2010, 12:09
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,555
Thanks: 791
Thanked 4,977 Times in 3,899 Posts
Default

Please try to replace the script /usr/local/ispconfig/server/scripts/vlogger on your server with the vlogger script in the attached zip file and restart apache.

The modified script adds a try / catch block around the datababase connection functions to handle database connection errors without causeing the script and apache to fail.
Attached Files
File Type: zip vlogger.zip (5.5 KB, 86 views)
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 21st May 2010, 00:44
lifeisboost lifeisboost is offline
Senior Member
 
Join Date: Feb 2006
Posts: 122
Thanks: 0
Thanked 2 Times in 2 Posts
 
Default

here is the full line i napache2's error.log

Code:
DBI connect('database=dbispconfig;host=lb1a.xxx.com:3306','ispcsrv5',...) failed: Can't connect to MySQL server on 'lb1a.xxx.com' (113) at /usr/local/ispconfig/server/scripts/vlogger line 255
DBI Error:  at /usr/local/ispconfig/server/scripts/vlogger line 255.
piped log program ' /usr/local/ispconfig/server/scripts/vlogger -s access.log -t "%Y%m%d-access.log" -d "/etc/vlogger-dbi.conf" /var/log/ispconfig/httpd' failed unexpectedly
after about 3 minutes of that this is then registered in the sites error log and the sites all go to a 500 internal error.

Code:
24)Too many open files: /var/www/clients/client1/web1/web/error/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable

I will try the vlogger you have attached once it becomes later as this is a busy site to take down.
Reply With Quote
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


All times are GMT +2. The time now is 07:54.


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