Error:- exceeded the 'max user connections' resource

Forum Moderators: open

Message Too Old, No Replies

Error:- exceeded the 'max user connections' resource

driller41

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

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