View Single Post
  #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