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..
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.
It looks like a bug. By the way, the instanceof for mysql is fixed for 4.0.2.
php/1f0c
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.