SQLSTATE[HY000]: General error: 5 database is locked

Created:

2017-04-27 08:52:56 UTC

Modified:

2017-08-08 13:28:46 UTC

0

Was this article helpful?


Have more questions?

Submit a request

SQLSTATE[HY000]: General error: 5 database is locked

Issue Symptoms

- Plesk Multi-Server is in use

- Unable to log in as customer

- Unable to open Nodes and Tasks tab of Multi-Server

- The following error in /var/log/plesk/panel.log can be found:

[2017-04-27 05:41:49] ERR [panel] SQLSTATE[HY000]: General error: 5 database is locked, query was: INSERT INTO "tokens" ("nodeId", "token", "masterToken", "login", "clientIpAddress") VALUES (?, ?, ?, ?, ?):
0: /usr/local/psa/admin/externals/Zend/Db/Statement/Pdo.php:235
        Zend_Db_Statement_Pdo->_execute(array)

...

16: /usr/local/psa/admin/externals/Zend/Controller/Dispatcher/Standard.php:308
        Zend_Controller_Dispatcher_Standard->dispatch(object of type Zend_Controller_Request_Http, object of type Zend_Controller_Response_Http)
17: /usr/local/psa/admin/externals/Zend/Controller/Front.php:954
        Zend_Controller_Front->dispatch()
18: /usr/local/psa/admin/plib/pm/Application.php:99
        pm_Application->run()
19: /usr/local/psa/admin/htdocs/modules/plesk-multi-server/index.php:5

- This and this articles did not help.

Conditions

Plesk Multi-server database was locked by the daily-sync-nodes process.

Resolution

Please contact Plesk Technical Support team in order to fix the  issue.

Have more questions? Submit a request
Please sign in to leave a comment.