• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Resolved Plesk\Exception\Database

UHolthausen

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
You must log in or register to reply here.

Similar threads

B
Issue DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.sessions' doesn't exist in engine, query was: DESCRIBE `sessions`
Replies
5
Views
2K
Martin Dias
Martin Dias
L
Issue Scheduled Backup warning.
Replies
0
Views
478
lema
L
C
Question Server Error 500 Plesk\Exception\Database
Replies
1
Views
545
Raul A.
R
F
Issue Server Error 500 Plesk\Exception\Database
Replies
3
Views
415
scsa20
scsa20
L
Issue Wp Tool Kit Hopelessly Broke
Replies
4
Views
1K
Ladylinux
L
Back
Top