• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Resolved Plesk\Exception\Database

UHolthausen

Regular Pleskian
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.
 
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.
 

Attachments

  • phpmyadmin_error.png
    phpmyadmin_error.png
    20.2 KB · Views: 9
Back
Top