Cannot login to Plesk: SQLSTATE[HY000]: General error: 23 Out of resources

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:13:37 UTC

Modified:

2017-02-15 13:55:22 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot login to Plesk: SQLSTATE[HY000]: General error: 23 Out of resources

Symptoms

Panel is not accessible, the following error is shown:

ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_d47_0.MAI' (Errcode: 24) (Pdo.php:234)

Backup creation can fail with:

mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_8c2_2.MYI' (Errcode: 24 - Too many open files)'

Cause

Opened files limit is reached.

Resolution

For CentOS 7/RHEL 7:

# mkdir -p /etc/systemd/system/mariadb.service.d/

Add into /etc/systemd/system/mariadb.service.d/limits.conf the following:

[Service]
LimitNOFILE=20000

Restart Mariadb service:

# systemctl daemon-reload
# systemctl restart mariadb.service

For CentOS 6 and lower:

# echo -e "mysql soft nofile 10000\

mysql hard nofile 20000" >> /etc/security/limits.conf # service mysqld restart

Have more questions? Submit a request
Please sign in to leave a comment.