Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st March 2013, 17:28
SamTzu SamTzu is offline
HowtoForge Supporter
 
Join Date: Apr 2007
Location: Helsinki
Posts: 426
Thanks: 33
Thanked 55 Times in 38 Posts
Send a message via Skype™ to SamTzu
Default Monitor page problem (cluster.)

There seems to be some problem with the new (3.0.5) Monitor (Show Overview) page. Every now and then the new "white box" just keeps staying on the middle of the page and we get no Overview page at all. I think this started after upgrading to 3.0.5. It also looks like the Search function dies after a certain time has passed and the server has to be rebooted to get it working again.
__________________

Sami Mattila
Internet-Content

Telephone:
00358942833310
Email: firstname.lastname@internet-content.org
Shop: http://shop.internet-content.net
Site: http://www.internet-content.net
Blog: http://www.internet-content.net/en/blog
FB: https://www.facebook.com/internetcontent


Last edited by SamTzu; 21st March 2013 at 19:40.
Reply With Quote
Sponsored Links
  #2  
Old 21st March 2013, 19:40
SamTzu SamTzu is offline
HowtoForge Supporter
 
Join Date: Apr 2007
Location: Helsinki
Posts: 426
Thanks: 33
Thanked 55 Times in 38 Posts
Send a message via Skype™ to SamTzu
Default

I'm definitely seeing a pattern here (not just in ISPConfig servers.)
It seems that there is a something wrong with PhpMyAdmin that causes a some kind of problem with MySQL that results in a system that can't restart in OpenVZ containers. Only hardware level reboot fixes this.

After trying to restart MySQL service I got the Show Overview to show but it had this error message...

Quote:
DB::query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) -> mysqli_query Server shutdown in progress#0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:157] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:192] #2 _getServerState(1, account.internet-content.net, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:113] #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63] DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Quote:
DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
After trying that OpenVZ control panel (Proxmox) shows this Syslog error message again and again...
Quote:
Mar 21 20:40:04 czc63519z7 pvedaemon[159375]: command '/usr/sbin/vzctl exec 110 /bin/cat /proc/net/dev' failed: exit code 8
This has happened on several different MySQL servers now on different hardware.
All Debian Squeeze OpenVZ containers.
__________________

Sami Mattila
Internet-Content

Telephone:
00358942833310
Email: firstname.lastname@internet-content.org
Shop: http://shop.internet-content.net
Site: http://www.internet-content.net
Blog: http://www.internet-content.net/en/blog
FB: https://www.facebook.com/internetcontent


Last edited by SamTzu; 21st March 2013 at 20:08.
Reply With Quote
The Following User Says Thank You to SamTzu For This Useful Post:
aehnzswift1905 (22nd March 2013)
  #3  
Old 1st April 2013, 18:55
SamTzu SamTzu is offline
HowtoForge Supporter
 
Join Date: Apr 2007
Location: Helsinki
Posts: 426
Thanks: 33
Thanked 55 Times in 38 Posts
Send a message via Skype™ to SamTzu
 
Default

Problem clearly lies in the new kernel.
I had to go back to 2.6.32-17 kernel.
__________________

Sami Mattila
Internet-Content

Telephone:
00358942833310
Email: firstname.lastname@internet-content.org
Shop: http://shop.internet-content.net
Site: http://www.internet-content.net
Blog: http://www.internet-content.net/en/blog
FB: https://www.facebook.com/internetcontent

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing mysql cluster bunty Server Operation 0 6th November 2012 21:14
Courier Imap is not working HellMind General 5 12th April 2012 01:04
table lookup problem aurelius Installation/Configuration 5 2nd November 2011 19:12
Ispconfig3 High availability cluster: mysql problem stevegjacobs Installation/Configuration 2 12th May 2010 11:47
Loadbalanced High-Availability Apache Cluster - DNS Problem pimadaum HOWTO-Related Questions 3 24th January 2007 13:04


All times are GMT +2. The time now is 20:28.


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