Re: User already has more than 'max_user_connections' active connections
Posted by: Pepijn Bicker
Date: February 11, 2008 11:37AM

Are there any connection open when viewing in MySQL admin?

I have a similar problem with my site. I use connection pooling. It seems to occur when the host system runs out of memory. In this case the open connections are not closed properly. It seems that the variable that holds the numbers of open connections is not updated properly. So even when the connections are closed by itself (on wait_timeout), the connector still thinks they are open. At least, that is what I think what happens.

It would help a lot if the connector somehow could be reset. I havnt realy found a solution for this. Right now I have to restart the workerprocess in order to get my site running again. So I need to do a manual operation, else this error will remain, and the site will be down. Any help or advice would be very welcome.

Options: ReplyQuote


Subject
Written By
Posted
Re: User already has more than 'max_user_connections' active connections
February 11, 2008 11:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.