Plesk Debian 8 General error: 23 Out of resources when opening
On a Debian 8 server with Plesk control panel, on the Plesk login page, I got the following error message
1 2 |
500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_353d_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE `sessions` |
This error is due to MySQL open_files_limit value is set low. To verify, run the command
1 |
SHOW VARIABLES LIKE 'open%'; |
You need to increase the limit.
On Debian 8, edit the file
1 |
vi /etc/mysql/my.cnf |
Find
1 |
[mysqld] |
Add below
1 |
open_files_limit = 102400 |
Restart MySQL
1 |
systemctl restart mysql |
If you have other version of Operating System, see MariaDB Change Open Files Limit.
Back to Plesk