PleskMainDBException 0: common_func.php3:220

[DieterM]

Running Plesk Panel 11.0.9 on CentOS 6 successfully for 2 years now I suddenly get:

**********************
ERROR: PleskMainDBException
MySQL query failed:

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed:

0: common_func.php3:220
db_query(string 'SELECT id, name, descr, enabled FROM actions')
1: class.ActionLog.php:455
ActionLog::loadActions()
2: class.ActionLog.php:477
ActionLog::getActionId(string 'plesk_component_upgrade')
3: class.ActionLog.php:497
ActionLog->ActionLog(string 'plesk_component_upgrade')
4: ServiceNode.php:88
Db_Table_Row_ServiceNode->refreshProperties()
5: auth.php3:511


*******************

No login screen

Restarting the service does not help.

KB has not helped me finding a solution

TNX

DieterM

 

[IgorG]

First of all make sure that you have enough free disk space and inodes on your Plesk server.

 

[DieterM]

First of all make sure that you have enough free disk space and inodes on your Plesk server.

Just checked this: IUse around 2-3% on all partitions enough disk space as well...

Any other ideas ??

 

[IgorG]

Have you tried troubleshoot it with help of reading mysql, sw-cp-server, panel logs? This article may help with troubleshooting - http://kb.parallels.com/en/111283

 

[DieterM]

Have you tried troubleshoot it with help of reading mysql, sw-cp-server, panel logs? This article may help with troubleshooting - http://kb.parallels.com/en/111283

Yes, checked all logs especially related to PSA

Error log: /var/log/sw-cp-server/error_log

shows basically the same as the frontend , additonally:

PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given; Fi
le: /usr/local/psa/admin/plib/common_func.php3, Line: 209

Exception: PHP Warning: mysql_errno() expects parameter 1 to be resource, boolea
n given; File: /usr/local/psa/admin/plib/common_func.php3, Line: 209

file: /usr/local/psa/admin/smb/application/library/Smb/Exception/Syntax.php
line: 55
code: 0
trace: #0 [internal function]: Smb_Exception_Syntax::handleError(2, 'mysql_errno
() e...', '/usr/local/psa/...', 209, Array)
#1 /usr/local/psa/admin/plib/common_func.php3(209): mysql_errno(false)
#2 /usr/local/psa/admin/plib/common_func.php3(307): db_query('select cl_id fr...
')
#3 /usr/local/psa/admin/plib/elements.php3(985): db_query_ex('select cl_id fr...
', Array)
#4 /usr/local/psa/admin/plib/elements.php3(946): getCustomPageTitle(Object(UserN
one))
#5 /usr/local/psa/admin/plib/Form.php(160): getPleskTitle('')
#6 /usr/local/psa/admin/plib/PSAErrorForm.php(47): Form->assign()
#7 /usr/local/psa/admin/plib/common_func.php3(140): PSAErrorForm->assign('MySQL
query fai...', Array, 'ERROR: PleskMai...')
#8 /usr/local/psa/admin/plib/PleskException.php(32): psaerrorForm('MySQL query f
ai...', Array, 'ERROR: PleskMai...')
#9 /usr/local/psa/admin/plib/PleskException.php(106): report_crash('MySQL query
fai...', Array, 'PleskMainDBExce...', 500, Object(PleskMainDBException))
#10 /usr/local/psa/admin/plib/PleskException.php(8): PleskException->report()
#11 [internal function]: plesk_exception_handler(Object(PleskMainDBException))
#12 {main}

/var/log/sw-cp-server/sw-engine.log (not/available)

Access log: /usr/local/psa/admin/logs/httpsd_access_log
Panel log: /usr/local/psa/admin/logs/panel.log : no errors from this date

SSO

Logs
Error log: /var/log/sw-cp-server/error_log (none additional...)
SSO log: /var/log/sso/sso.log (empty)

Migration Manager

Logs
/usr/local/psa/PMM/logs/migration-<datetime> : all exit code 0 = OK

MySQL

Logs
/var/log/mysqld.log

Here I get following error several times a day:
**************************************
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 169 2320191477
140704 10:56:11 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
140704 10:56:11 InnoDB: Started; log sequence number 169 2320191477
140704 10:56:11 [Note] Event Scheduler: Loaded 0 events
140704 10:56:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
*******************************************************************

Dunno if that has to do with it, but I suppose not...

Tnx for help

DieterM

 

[DieterM]

Have you tried troubleshoot it with help of reading mysql, sw-cp-server, panel logs? This article may help with troubleshooting - http://kb.parallels.com/en/111283

addendum:

tried accessing the psa database via webmin and got error:

SQL show index from `APSApplicationItems` failed : Lost connection to MySQL server during query

seems the plesk-db is corrupted ??

tnx for help

greetings

DieterM

 

[DieterM]

Have you tried troubleshoot it with help of reading mysql, sw-cp-server, panel logs? This article may help with troubleshooting - http://kb.parallels.com/en/111283

addendum 2: tried accessing psa db directly through mysql-client
use psa; OK
show tables got error:
*******************
mysql> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 11
Current database: psa

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server
***********************

whoops ???

tnx for help

DieterM

 

[IgorG]

expects parameter 1 to be resource, boolean given

Looks like database inconsistency. I suggest you contact support team. They will check and fix this inconsistency directly on your server.