homepage Welcome to WebmasterWorld Guest from 54.196.159.11
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved