Resolved Open MySql or create new database

[Puma7]

Hi,

I get following error message if I try to open mysql or to create a database via the Web interface.

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_5e2_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `sessions`

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Mysql.php:53)

Does anyone know what it means or why it happends?
It crashes the whole server and only a restart helps.

 

[Bitpalast]

Please see https://talk.plesk.com/threads/comp...n-auto-backuping-database.340852/#post-815436 for the solution.

 

[Puma7]

Worked! thanks!

I needed to set the limit above 30000. I used now 50000 and hope that is enought for a while.