Issue ERROR 500 Plesk \ Exception \ Database

[Jordi escandell riera]

Consulta DB fallida: SQLSTATE [42S02]: Tabla base o vista no encontrada: 1146 Tabla 'psa.sessions' no existe, la consulta fue: DESCRIBE `sessions`

hi, someone could help me!!!!!!! thanks!!!!!

 

[Jordi escandell riera]

ERROR al intentar encontrar la base de datos psa
Compruebe el motivo del error (consulte el archivo de registro: /var/log/plesk/install/plesk_17.8.11_repair .log), corrija y vuelva a intentarlo

 

[Brujo]

The forum language is english, so take into consider to translate your issue or at least describe a little bit more detailed what you are doing and when you get the error message.

Also check if there is not enough disk space or free inodes on your system

Well I guess you can do the following:

You could first try:
# plesk repair db -y

Then, if that did not solve the issue,
# plesk repair installation

If the issue still exist:
# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components

 

[Jordi escandell riera]

Type Plesk\Exception\Database
Message DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: replace into misc (param, val) valuesparam, :val)
File Mysql.php
Line 53

 

[m3lezZ]

Looks like that psa database is corrupted. You can:

1. Restore Database/table from valid Mysql backup.
2. Repair databases with System Administrator using Mysql troubleshoot guide - MySQL :: MySQL 8.0 Reference Manual :: 15.20.3 Troubleshooting InnoDB Data Dictionary Operations
3. Contact Parallels Support Team.

 

[Jordi escandell riera]

I execute:
# plesk repair installation
, and now shows me :

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_17.8.11_repair.log), fix and try again

 

[m3lezZ]

Connect to the server via SSH and change DUMP_D variable in /etc/psa/psa.conf file to the default value:

# cat /etc/psa/psa.conf | grep DUMP
DUMP_D /var/lib/psa/dumps
DUMP_TMP_D /tmp

 

[Jordi escandell riera]

Escriba Zend_Db_Adapter_Exception
Mensaje SQLSTATE [HY000] [1049] Base de datos desconocida 'psa'
Archivo Abstract.php
Línea 144

 

[Jordi escandell riera]

Type Zend_Db_Adapter_Exception
Message SQLSTATE[HY000] [1049] Unknown database 'psa'
File Abstract.php
Line 144


Now appers this

 

[MarkM]

Hopefully you have a dump.

Cannot open Plesk: ERROR: PleskFatalException Unable to connect to database: Unknown database psa