Resolved ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 23 Out of resources when open...

[Bénédicte]

Hello,
I have a big problem. My plesk don't stop to crash. Completely random . Usually, once per day. When I try to connected me to my plesk, this error :
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/....' (Errcode: 24 "Too many open files") (Pdo.php:234)
(the file change everytime)

And all my sites using my database are out services. Other work.

I did the update 13, and she crashed, I have the impression that everything came from there.

I added the " max_connections ", " wait_timeout "
" Interactive_timeout "
in /etc/mysql/my.cnf file

And I followed the procedure by modifying /etc/security/limits.conf : https://kb.plesk.com/en/124356

But nothing !! I'm desperate.
Please, can you help me ?
My plesk is 12.5.30 update number 23, Linux Debian 8.0 Jessie.

 

[IgorG]

There is really the problem with reaching of limit for opened files limit. And if mentioned KB article didn't help, I would suggest you ask assistance of Support Team.

 

[Bénédicte]

Thanks for your answer !
I try to connect with , but I can not send mail because " It was identified that your Plesk license was purchased from one of Plesk . Plesk partners Partners should use their support codes to contact Plesk technical support team . " But I do not have this code -__- '


You think I have to change the values 10000 or 2000 ?
Knowing that the rest of my file is commented :

#*  soft  core  0
#root  hard  core  100000
#*  hard  rss  10000
#@student  hard  nproc  20
#@faculty  soft  nproc  20
#@faculty  hard  nproc  50
#ftp  hard  nproc  0
#ftp  -  chroot  /ftp
#@student  -  maxlogins  4
mysql  soft  nofile  10000
nmysql  hard  nofile  20000

For information I have 40 client on my plesk.

 

[IgorG]

Try to increase current values

mysql  soft  nofile  10000
mysql  hard  nofile  20000

to

mysql  soft  nofile  15000
mysql  hard  nofile  25000

 

[Bénédicte]

Ok I try ! Fingers crossed !!

 

[Bénédicte]

Ok, it's doesn't work.... Crash yesterday. I feel like it takes longer before crashing. But it's maybe on my head !
Can I increase these values?

I updated my plesk n°24. And my plesk indicated "update number 25" wtf ?
I hope it will solve my problem.

 

[IgorG]

MU#25 has been released less that half hour ago.

Can I increase these values?

I think that you can.

 

[Bénédicte]

Can you explain what those values ? What are they for ? I don't understand....

 

[Bénédicte]

I see the plugin Admin-Ahead Arch for Apache Plesk Extension". You think it's help me if i install it ?

 

[Bénédicte]

I changed the value but nothing changes .
When I do the command "ulimit -a " :
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 255199
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 255199
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

I think this is the open files value that is too large , but I don't know where I have to change it. Do you have any idea about that ?

 

[Bénédicte]

Up please ?

 

[Bénédicte]

Hello,
We find the solution, if someone need :

cp /etc/mysql/my.cnf /etc/mysql/my.cnf.old
and in my.cnf under the line [mysqld]
add :

open_files_limit = 4096

and under the line [mysqld_safe] add :

open_files_limit = 4096

And after reboot the service with :

/etc/init.d/mysql stop
/etc/init.d/mysql start

You can tchek if the values is good :
Login at your database and do

show global variables like 'open%';

And the result must be 4096.

 

[360webfirm]

Can you explain o me how I go in and change this, I tried to do this with vi my.cnf and there is nothing there.

 

[Bénédicte]

You doesn’t have my.conf of you doesn’t have the entry « open_files_limit »?

You can add this entry on your my.conf if he doesn’t be here

 

[360webfirm]

How do I add it, open the file using VI and then add what lines? can you please help me?

 

[360webfirm]

Like this ? There is TWO areas that show [mysqld]

 

[Bénédicte]

I explained above the steps to follow. now that you have increment your entry, restart mysql and connect you to your database to see if the changes have been taken into account.

 

[Bénédicte]

You can change with vi, save with w.

 

[360webfirm]

That is my settings above now. I saved that file and restarted server and then re checked. My question is will this work with:

Version Plesk Onyx v17.8.11_build1708180301.19 os_Debian 8.0
OS Debian 8.11

 

[Bénédicte]

yes normally, if you have this error.