Welcome to WebmasterWorld Guest from 54.205.74.11

Forum Moderators: open

Error:- exceeded the 'max user connections' resource

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

5+ Year Member



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?
2:16 pm on Mar 23, 2010 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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).
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month