HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Monitor page problem (cluster.) (http://www.howtoforge.com/forums/showthread.php?t=61060)

SamTzu 21st March 2013 18:28

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.

SamTzu 21st March 2013 20:40

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.

SamTzu 1st April 2013 19:55

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


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

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