PDA

View Full Version : Mysql Too many connections


juancho_h
11-19-2009, 02:46 PM
I have a little problem currently i'm using resin 3.1.9 and don't have any problem. But when i move the same site to resin 4.0.1 I've an error "Mysql too many connections".
Anybody knows what is happening or how could i fix it?
Thanks and sorry by my english..

nam
11-19-2009, 07:12 PM
Hi,

I've submitted a bug report for this at:

http://bugs.caucho.com/view.php?id=3774

Does Resin print out a stack trace for this error?

juancho_h
11-20-2009, 02:55 AM
No, there is no stack trace or anything at all.
But, i found what was happening.
I'm migrating this site from Apache/Php to quercus, i found that when i check if i'm connected to mysql i'm using a "instaceof mysqli" but on this version this don't works, and for every query i'm connecting again to mysql, on a cicle I connect to db every time. This is my mistake,
Another thing is on the file web.xml I was configured max-connection setting to 10 and on the mysql server I have max connections to 200. I'm setting anything wrong on the web.xml or realy it's a bug?

Thanks again, and sorry for my bad english.

nam
11-21-2009, 10:41 AM
It looks like a bug. By the way, the instanceof for mysql is fixed for 4.0.2.

php/1f0c