• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Plesk Web Server/MYSQL inactive/active all 3 days

S

Sascha_Plobner

New Pleskian
I got 2 watchdog msg for "Plesk Web Server" and "MYSQL" goes inactiv and 10min later a msg for both go active again.
This happens all 2-3 days.
Here my error logs for that problem:

[2015-01-04 15:38:59] ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: Mysql.php:109
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: Abstract.php:459
Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
5: Abstract.php:93
CommonPanel_Application_Abstract::initDbAdapter()
6: Helper.php:150
Plesk\Session\Helper::initStorage()
7: auth.php:308
AutoPrepend->initUserSession()
8: auth.php:219
AutoPrepend->run()
9: auth.php:690
[04-Jan-2015 15:38:59 Europe/Berlin] Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
file: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php
line: 144
code: 2002
trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(459): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET sql_mode = ...', Array)
#3 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(19): Zend_Db_Adapter_Pdo_Abstract->query('SET sql_mode = ...', Array)
#4 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(93): Db_Adapter_Pdo_Mysql->query('SET sql_mode = ...')
#5 /opt/psa/admin/plib/Session/Helper.php(150): CommonPanel_Application_Abstract::initDbAdapter()
#6 /opt/psa/admin/plib/auth.php(308): Plesk\Session\Helper::initStorage()
#7 /opt/psa/admin/plib/auth.php(219): AutoPrepend->initUserSession()
#8 /opt/psa/admin/plib/auth.php(690): AutoPrepend->run()
#9 {main}
--
#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$AL...', Array)
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(459): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET sql_mode = ...', Array)
#4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(19): Zend_Db_Adapter_Pdo_Abstract->query('SET sql_mode = ...', Array)
#5 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(93): Db_Adapter_Pdo_Mysql->query('SET sql_mode = ...')
#6 /opt/psa/admin/plib/Session/Helper.php(150): CommonPanel_Application_Abstract::initDbAdapter()
#7 /opt/psa/admin/plib/auth.php(308): Plesk\Session\Helper::initStorage()
#8 /opt/psa/admin/plib/auth.php(219): AutoPrepend->initUserSession()
#9 /opt/psa/admin/plib/auth.php(690): AutoPrepend->run()
#10 {main}


Whats the problem? How can i fix it?
 
Sascha_Plobner said:
I got 2 watchdog msg for "Plesk Web Server" and "MYSQL" goes inactiv and 10min later a msg for both go active again.
This happens all 2-3 days.
Here my error logs for that problem:

[2015-01-04 15:38:59] ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: Mysql.php:109
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: Abstract.php:459
Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
5: Abstract.php:93
CommonPanel_Application_Abstract::initDbAdapter()
6: Helper.php:150
Plesk\Session\Helper::initStorage()
7: auth.php:308
AutoPrepend->initUserSession()
8: auth.php:219
AutoPrepend->run()
9: auth.php:690
[04-Jan-2015 15:38:59 Europe/Berlin] Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
file: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php
line: 144
code: 2002
trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(459): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET sql_mode = ...', Array)
#3 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(19): Zend_Db_Adapter_Pdo_Abstract->query('SET sql_mode = ...', Array)
#4 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(93): Db_Adapter_Pdo_Mysql->query('SET sql_mode = ...')
#5 /opt/psa/admin/plib/Session/Helper.php(150): CommonPanel_Application_Abstract::initDbAdapter()
#6 /opt/psa/admin/plib/auth.php(308): Plesk\Session\Helper::initStorage()
#7 /opt/psa/admin/plib/auth.php(219): AutoPrepend->initUserSession()
#8 /opt/psa/admin/plib/auth.php(690): AutoPrepend->run()
#9 {main}
--
#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$AL...', Array)
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(459): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET sql_mode = ...', Array)
#4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(19): Zend_Db_Adapter_Pdo_Abstract->query('SET sql_mode = ...', Array)
#5 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(93): Db_Adapter_Pdo_Mysql->query('SET sql_mode = ...')
#6 /opt/psa/admin/plib/Session/Helper.php(150): CommonPanel_Application_Abstract::initDbAdapter()
#7 /opt/psa/admin/plib/auth.php(308): Plesk\Session\Helper::initStorage()
#8 /opt/psa/admin/plib/auth.php(219): AutoPrepend->initUserSession()
#9 /opt/psa/admin/plib/auth.php(690): AutoPrepend->run()
#10 {main}


Whats the problem? How can i fix it?
Click to expand...

Hi Sascha,

thanks for posting in the Parallels Forums. It sounds like an file is missing stupidly. Did you already run the bootstrapper?

Kind regards
Henning
 
It doesent help. its getting worse 2 times "Plesk Web Server" down since i have done teh bootstrapper repair since yesterday.

but for that there are no error logs now in /usr/local/psa/admin/logs/panel.log
 
Try to find something useful in /var/log/sw-cp-server/error_log
 
I got this:

2015/01/14 04:30:23 [alert] 32017#0: worker process 32018 exited on signal 9


could be for this error whatchdog mail:

The Plesk Web Server service on host xxx.de is down.
The problem was discovered on Jan 14, 2015 04:30 .

Der Service Plesk Web Server auf dem Host xxx.de wurde am Jan 14, 2015 04:35 gestartet.



But this is the only error inside - the error_log.1 is only somthing from the Jan 08. Buit i have more errors mails from whatchdog (atm 2 a day) for the plesk web server. The mysql error are gone since days.
 
Last edited:
Signal 9 is KILL Unix signal. There can be a lot of different reasons of this. If this is VPS - lack of resources and kernel OOM killer as result, for example.
I suggest you contact Support Team for detailed investigation this issue directly on your server.
 
i disabled the plesk mobile extension and it seem they errors are gone for now - maybe to many cronjobs for the vps. CPU usage is freeaking low normaly never over 5% and RAM usage is 400MB from 4GB.
 
You must log in or register to reply here.

Similar threads

L
Issue Daily Maintenance Script Spawns Off A Bunch Of PHP-FPM processes Leading To Huge Load Spike
Replies
2
Views
404
Ladylinux
L
Christopher-James
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused: after Obsidian update 18.0.53
Replies
10
Views
6K
Peter Debik
P
S
Question High server resource and mysql error
Replies
7
Views
2K
Peter Debik
P
H
Question MariaDB doesn't start after upgrade
Replies
3
Views
823
Kaspar@Plesk
Kaspar@Plesk
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
2K
Crash79797
C
Back
Top