homepage Welcome to WebmasterWorld Guest from 184.73.87.85
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Error:- exceeded the 'max user connections' resource
driller41




msg:4102231
 10:37 am on Mar 22, 2010 (gmt 0)

Hi, I am getting this error.

Could not connect: User '#*$!xx' has exceeded the 'max_user_connections' resource (current value: 40)

on my php database, from what I can tell too many connections have been started and not closed down - for some reason, I dont know why.

I have checked the connection string and it is not the problem.

I am on a shared host so I have limited options.

any ideas on how to get the site up again?

 

coopster




msg:4103030
 2:16 pm on Mar 23, 2010 (gmt 0)

Your shared host will likely have to kill the jobs/connections or restart the mysql daemon. Next, you will need to figure out why your connections are hanging and update your code to resolve the issue.

If you are not certain where to start you could monitor the connection script by logging any errors with a full trace and dumping it to a log. (Throw a new exception error within a try/catch block).

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved