Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   Can't get into site? (http://www.mysidiaadoptables.com/forum/showthread.php?t=3951)

Abronsyth 01-07-2013 02:00 PM

Can't get into site?
 
Quote:

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

Quote:

Originally Posted by Iris-spider (Post 25646)
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.


All times are GMT -5. The time now is 01:56 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.