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`

[bigbear67]

Server operating system version

Ubuntu 22.04 x86_64

Plesk version and microupdate number

Plesk Obsidian 18.0.63.4

Hello everyone after restoring OPT/psa/
when I click on repair kit, it keeps asking me for the password
but does nothing
in SSH I have this:
[2024-09-08 12:51:51.889] 42420:66dd81c7d8fc3 ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.misc' doesn't exist in engine, query was: select param, val from misc
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.clients' doesn't exist in engine, query was: DESCRIBE `clients`

which file to restore to find a plesk in good shape?
where find the file for this database?

 

[Martin Dias]

https://support.plesk.com/hc/en-us/articles/12376967822231-How-to-restore-Plesk-system-databases-from-a-Plesk-daily-pre-upgrade-dump

 

[bigbear67]

https://support.plesk.com/hc/en-us/articles/12376967822231-How-to-restore-Plesk-system-databases-from-a-Plesk-daily-pre-upgrade-dump

Thank you so much :
ERROR 1005 (HY000) at line 34: Can't create table `apsc`.`aps_application` (errno: 184 "Tablespace already exists")

 

[Martin Dias]

Either you can try to drop the tables affected or even the full psa DB before restore, alternatively check for corruptions 1st:

https://support.plesk.com/hc/en-us/articles/12377798484375-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-MariaDB-databases-on-Plesk-for-Linux

 

[bigbear67]

Either you can try to drop the tables affected or even the full psa DB before restore, alternatively check for corruptions 1st:

https://support.plesk.com/hc/en-us/articles/12377798484375-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-MariaDB-databases-on-Plesk-for-Linux

one more time i says thank s
but
Failed to stop plesk-web-socket.service: Unit plesk-web-socket.service not loaded.

 

[Martin Dias]

That does not provide any information, check the status of the service and logs, for information why it fails.
Alternatively, contact Plesk support team on this topic.

To sign-in to support, please go to https://support.plesk.com

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-