Log in

View Full Version : Can't get into site?


Abronsyth
01-07-2013, 02:00 PM
Could not connect to database, the following error has occurred:
SQLSTATE[42000] [1203] User emkaldar_adopts already has more than 'max_user_connections' active connections

Got that error when trying to access my site. I'm not sure if it's not a problem with the host...I honestly just can't understand what it's telling me.

Hall of Famer
01-07-2013, 03:56 PM
I was wondering though, do you just happen to get this error today? How long does it persist? It appears that your site has too many concurrent mysql connections at the same time, usually this shouldnt be a problem as the connections are automatically closed after a while. Try again later and see if this problem still wont go away. In this case, you may have to define some mysql settings as specified here:
http://dev.mysql.com/doc/refman/5.0/en/user-resources.html

Another way is to contact your host and kill all processes on your site so all those connections are gone. It will make your site work for now, but not sure if it will come back some time later. There's a chance that your server aint getting rid of old connections properly.

Abronsyth
01-08-2013, 07:08 AM
Well, it's working fine now...first time that's ever happened...I will be upgrading my site/hosting plan, so maybe that can help to make sure it doesn't happen again...

Hall of Famer
01-08-2013, 01:56 PM
Well, it's working fine now...first time that's ever happened...I will be upgrading my site/hosting plan, so maybe that can help to make sure it doesn't happen again...

I am not sure if this does have anything to do with hosting plan, more like server misconfiguration if you ask me. The server aint killing off unneeded database connection properly.