SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug.

Refers to:

  • Plesk for Linux
  • MT:1751d5edcca5340f78144a4499e8c1d5
  • MG:d0f25df960992637dfb817d902adf8a5
  • MT:444fcb58755dda5d44a906b90cbef8d0
  • MT:6bbc102bb18b97d3b966d9d7cd20b861

Created:

2016-11-16 12:38:47 UTC

Modified:

2017-03-08 12:20:50 UTC

0

Was this article helpful?


Have more questions?

Submit a request

SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug.

Symptoms

The following error is being displayed in Plesk:

SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug.

Cause

MySQL service is used actively, which causes it to overuse the maximum available limits for process treads.

Resolution

For Ubuntu\Debian\Centos below 6:

Modify the '/etc/security/limits.conf' directly, and configure limits for MySQL as below:

mysql  soft  nproc  4096

For Centos 6 and above:

Create a file '/etc/security/limits.d/91-mysql.conf' and include the same configuration as described above. The additional files is needed to override the global limit specified in the '/etc/security/limits.d/90-nproc.conf' .

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