Resolved Plesk\Exception\Database

[UHolthausen]

Hello

i started yesterday morning a complete backup of the server and the domains.
It worked and in the evening i took a look and saw, the server harddisk were full.
Deleted the file and restart the server, didnt work very well.

When i try to access pelsk:

DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

i have tryed to repair it, but no chance.
The database is marked only read.
OS: Debian 9:12
Plesk: Onyx incl. all updates.


panel log:

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.clients' doesn't exist, query was: DESCRIBE `clients`
[2020-03-24 06:27:08.600] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:08.600] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.295] ERR [panel] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:53
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `sessions`')
1: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Adapter/Pdo/Mysql.php:171
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'sessions', NULL null)
2: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:836
Zend_Db_Table_Abstract->_setupMetadata()
3: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:875
Zend_Db_Table_Abstract->_setupPrimaryKey()
4: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:983
Zend_Db_Table_Abstract->info()
5: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Select.php:100
Zend_Db_Table_Select->setTable(object of type Plesk\Session\Storage_DbTable_Sessions)
6: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Select.php:78
Zend_Db_Table_Select->__construct(object of type Plesk\Session\Storage_DbTable_Sessions)
7: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:1019
Zend_Db_Table_Abstract->select()
8: /opt/psa/admin/plib/Session/Storage/DbTable.php:165
Plesk\Session\Storage_DbTable->_removeSessions(boolean true)
9: /opt/psa/admin/plib/Session/Storage/DbTable.php:146
Plesk\Session\Storage_DbTable->removeExpiredSessions()
10: /opt/psa/admin/plib/Application/Web.php:175
Plesk\Application_Web->loadSession()
11: /opt/psa/admin/plib/auth.php:278
AutoPrepend->initUserSession()
12: /opt/psa/admin/plib/auth.php:203
AutoPrepend->run()
13: /opt/psa/admin/plib/auth.php:579
[2020-03-24 06:27:18.296] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.296] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.298] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.298] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.712] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.clients' doesn't exist, query was: DESCRIBE `clients`
[2020-03-24 06:27:08.600] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:08.600] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.295] ERR [panel] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:53
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `sessions`')
1: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Adapter/Pdo/Mysql.php:171
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'sessions', NULL null)
2: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:836
Zend_Db_Table_Abstract->_setupMetadata()
3: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:875
Zend_Db_Table_Abstract->_setupPrimaryKey()
4: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:983
Zend_Db_Table_Abstract->info()
5: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Select.php:100
Zend_Db_Table_Select->setTable(object of type Plesk\Session\Storage_DbTable_Sessions)
6: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Select.php:78
Zend_Db_Table_Select->__construct(object of type Plesk\Session\Storage_DbTable_Sessions)
7: /opt/psa/admin/plib/vendor/plesk/zendframework/library/Zend/Db/Table/Abstract.php:1019
Zend_Db_Table_Abstract->select()
8: /opt/psa/admin/plib/Session/Storage/DbTable.php:165
Plesk\Session\Storage_DbTable->_removeSessions(boolean true)
9: /opt/psa/admin/plib/Session/Storage/DbTable.php:146
Plesk\Session\Storage_DbTable->removeExpiredSessions()
10: /opt/psa/admin/plib/Application/Web.php:175
Plesk\Application_Web->loadSession()
11: /opt/psa/admin/plib/auth.php:278
AutoPrepend->initUserSession()
12: /opt/psa/admin/plib/auth.php:203
AutoPrepend->run()
13: /opt/psa/admin/plib/auth.php:579
[2020-03-24 06:27:18.296] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.296] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.298] ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.298] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
[2020-03-24 06:27:18.712] ERR [1] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

mysql.log:

020-03-24 8:57:04 140058644096768 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2020-03-24 8:57:04 140058644512128 [Note] /usr/sbin/mysqld: ready for connections.

 

[IgorG]

Unable to access Plesk: Table 'psa.table_name' doesn't exist

Applicable to: Plesk for Linux Plesk for Windows Symptoms Plesk is not accessible with one of the following error messages in a web-browser: PLESK_INFO: ERROR: Zend_Db_Statement_Exception: SQL...

support.plesk.com

 

[UHolthausen]

Thanks Igor

tryed it:

Error 1036 (HY000) at line 185: Table !ApiRPCCallStat' is read only.

 

[IgorG]

Error 1036 (HY000) at line 185: Table !ApiRPCCallStat' is read only.

Try to restart mysql service.

 

[UHolthausen]

Restarted the mysqlservice, but still the same problem.

 

[UHolthausen]

Hello

i have solved it tody.
The database is unlocked and i could repair the plesk installation:

Unable to access Plesk: Table 'psa.table_name' doesn't exist

Applicable to: Plesk for Linux Plesk for Windows Symptoms Plesk is not accessible with one of the following error messages in a web-browser: PLESK_INFO: ERROR: Zend_Db_Statement_Exception: SQL...

support.plesk.com

 

[UHolthausen]

Hello

plesk runs again.
Phpmyadmin can only be used on the server, the domains are denied,but the MySQL errors cannot be fixed by Diagnosis & Repair.. See appendix
It must be possible to change phpmyadmin back to the original user (root and password yes)
Despite intensive search, I cannot find the config file for Phpmyadmin.