• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

Resolved Open MySql or create new database

P

Puma7

New Pleskian
Hi,

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

Code: 
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.
 
Worked! thanks!

I needed to set the limit above 30000. I used now 50000 and hope that is enought for a while.
 
You must log in or register to reply here.

Similar threads

F
Issue Server Error 500 Plesk\Exception\Database
Replies
3
Views
933
scsa20
scsa20
C
Question Server Error 500 Plesk\Exception\Database
Replies
3
Views
985
Raul A.
R
G
Resolved DB query failed - Deadlock
Replies
16
Views
5K
miguelcarmona
M
bonar
Resolved General error: 1 Can't create/write to file '/var/tmp/#sql_677_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`I’m
Replies
4
Views
3K
bonar
bonar
N
Issue 500 Plesk\Exception\Database
Replies
7
Views
2K
gautica
G
Back
Top