• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

Christopher-James
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused: after Obsidian update 18.0.53
Replies
10
Views
4K
Peter Debik
P
S
Question High server resource and mysql error
Replies
7
Views
2K
Peter Debik
P
nethubonline
Resolved Plesk install failure on AlmaLinux 9
Replies
3
Views
1K
nethubonline
nethubonline
O
Resolved Cannot create subscription - fails on "Configuring mail"
Replies
8
Views
1K
octet
O
A
Issue DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
1
Views
1K
IgorG
IgorG
Back
Top