Ugh...too scared to do that. I will try later, after some testing. Thanks! Regards, Saša Stamenković
On Thu, May 20, 2010 at 12:08 PM, Aleksey Zapparov <[email protected]>wrote: > Hello, > > Can you check one thing? Looks little bit dummy, but I never worked with > MySQLi in fact, so just to reveal my unknowlesge ;)) open up file: > > Zend/Db/Adapter/Mysqli.php > > and replace string (at line 282): > > if ($this->_connection) { > > with: > > if ($this->isConnected()) { > > > 2010/5/20 Саша Стаменковић <[email protected]>: > > > > 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 > >> > >> > > > > > > > > -- > Sincerely yours, > Aleksey V. Zapparov A.K.A. ixti > FSF Member #7118 > Mobile Phone: +34 617 179 344 > Homepage: http://www.ixti.ru > JID: [email protected] > > *Origin: Happy Hacking! >
