Welcome to WebmasterWorld Guest from 23.20.157.174

Forum Moderators: open

Message Too Old, No Replies

Error:- exceeded the 'max user connections' resource

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

Preferred Member

5+ Year Member

joined:Nov 29, 2007
posts: 385
votes: 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?
2:16 pm on Mar 23, 2010 (gmt 0)

Administrator

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

joined:July 31, 2003
posts:12547
votes: 2


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