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


Reply via email to