I can have max 15 connections on this shared hosting. Because the connection I use is not persistanrt, but use pooling instead, every query counts as new connection (not sure)? Also, I thought the problem will dissapear when I remove loop, and use IN(ids) approach, but looks like quoteInto() loops something that kills server for each ID in array.
Regards, Saša Stamenković On Thu, May 20, 2010 at 12:00 PM, Thomas D. <[email protected]> wrote: > Hi, > > > [...] > > but I still get similar error: > > > > 2010-05-20T10:08:40+02:00 ERR (3): exception > 'Zend_Db_Adapter_Mysqli_Exception' > > with message 'User *** already has more than 'max_user_connections' > active > > connections' in Zend/Db/Adapter/Mysqli.php:333 > > Stack trace: > > #0 Zend/Db/Adapter/Abstract.php(832): Zend_Db_Adapter_Mysqli->_connect() > > #1 Zend/Db/Adapter/Abstract.php(902): > Zend_Db_Adapter_Abstract->quote('582', NULL) > > #2 Zend/Db/Select.php(1000): > Zend_Db_Adapter_Abstract->quoteInto('table...', '582', NULL) > > #3 Zend/Db/Select.php(475): Zend_Db_Select->_where('table...', '582', > NULL, true) > > [...] > > I don't think that this problem is related to Zend_Db and/or is caused by a > loop. > Zend_Db will use the same adapter for every table. So the script should > only have one connection. > > => The problem should have another source. > > > Are you running on a shared host? Have you control over your mysqld? Then > check your connections using mtop/MySQL Administrator to see what's the > other connections and where they came from. > > At least you should check what's the webservers max. connections. If your > webserver can handle 1000 connections, but your mysqld allows only 100, then > there is a configuration mismatch. > > > -- > Regards, > Thomas > > >
