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!
