Base table or view not found: 1146 Table 'psa.sessions' doesn't exist (Pdo.php:234)

[JVallet]

hello,

This titled error when i try to connect plesk...

it happened after a general error :
Error: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
due to a saturated partition

When i made free space, and restarted, all servers/services were ok, except plesk access :
ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist (Pdo.php:234)
trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(169): Db_Adapter_Pdo_Mysql->query('DESCRIBE `sessi...')
#1 /opt/psa/admin/externals/Zend/Db/Table/Abstract.php(835): Zend_Db_Adapter_Pdo_Mysql->describeTable('sessions', NULL)
#2 /opt/psa/admin/externals/Zend/Db/Table/Abstract.php(874): Zend_Db_Table_Abstract->_setupMetadata()
#3 /opt/psa/admin/externals/Zend/Db/Table/Abstract.php(982): Zend_Db_Table_Abstract->_setupPrimaryKey()
#4 /opt/psa/admin/externals/Zend/Db/Table/Select.php(100): Zend_Db_Table_Abstract->info()
#5 /opt/psa/admin/externals/Zend/Db/Table/Select.php(78): Zend_Db_Table_Select->setTable(Object(Plesk\Session\Storage_DbTable_Sessions))
#6 /opt/psa/admin/externals/Zend/Db/Table/Abstract.php(1018): Zend_Db_Table_Select->__construct(Object(Plesk\Session\Storage_DbTable_Sessions))
#7 /opt/psa/admin/plib/Session/Storage/DbTable.php(144): Zend_Db_Table_Abstract->select()
#8 /opt/psa/admin/plib/Application/Web.php(174): Plesk\Session\Storage_DbTable->removeExpiredSessions()
#9 /opt/psa/admin/plib/auth.php(346): Plesk\Application_Web->loadSession()
#10 /opt/psa/admin/plib/auth.php(223): AutoPrepend->initUserSession()
#11 /opt/psa/admin/plib/auth.php(699): AutoPrepend->run()
#12 {main}

Then i used:
/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair

and obtained:
DATABASE ERROR!!!
Database psa found, but version undefined

ERROR while trying to find psa database
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again

***** problem report *****
ERROR while trying to find psa database
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again

Does anybody know how to fix this issue please ?
thank you very much.

 

[JVallet]

Do you think this article (https://kb.plesk.com/en/122876) may be appropriate to me? Because in my case, Plesk didn't fail after an upgrade, but the error message is the same...

 

[IgorG]

I'd suggest you try to use "Database psa found, but version undefined" phrase for KB search. There are several appropriate KB articles.