SQL error:...more than 'max_user_connections'

[Trunk]

I've been getting the below error the last few days, every so often.. usually when trying to access a thread.

 

SQL error: User taobums_dbuser already has more than 'max_user_connections' active connections

SQL error code:

Date: Monday 28th 2009f September 2009 09:32:36 AM

[Mal]

I've been getting that for a while, and quite a bit in the last few days. Mentioned it in passing in email to Sean last night.

 

We either need to be less popular (too many people accessing the database) or........ I'm not sure what the fix would be. Not sure if it's software or hardware bottleneck.

[Desert Eagle]

I get that error about two times a day, I thought it might be due to an auto backup down time or something similar.

[Mal]

Quick web search reveals quite a funny thread

http://www.webdeveloper.com/forum/showthread.php?t=165075

[lino]

I've been getting the below error the last few days, every so often.. usually when trying to access a thread.

 

SQL error: User taobums_dbuser already has more than 'max_user_connections' active connections

SQL error code:

Date: Monday 28th 2009f September 2009 09:32:36 AM

 

No way to really counter it other than changing software or moving to a more expensive account.

[Smile]

It was an attack on a few forums that would fake multiple connections to the webserver.

So if you have Mozilla FireFox settings for more then 8, set "network.http.pipelining.maxrequests" to no more then 8. If you have your mozilla set to, let's say 30, it will open 30 threads at the same time and you will be overloading the server.

[Marblehead]

Quick web search reveals quite a funny thread

http://www.webdeveloper.com/forum/showthread.php?t=165075

 

That was almost as good as TheThree Stooges. Thanks.

 

Happy Trails!

[Gerard]

I hope Sean reports this issue to the forum server because it is a mysql internal problem. It has got nothing to do with either him or us (forum browsers).

[sean]

I hope Sean reports this issue to the forum server because it is a mysql internal problem. It has got nothing to do with either him or us (forum browsers).

Has anyone received this error recently? Please let me know, yeah this is serious, I'll have to look into this.

 

Sean

[Aetherous]

Yes I got it about an hour ago.

[Taiji Bum]

I got it yesterday!

[sean]

Ok, I raised the max number of connections significantly. Please let me know if you get this error again and I'll raise it even more.

 

Thanks!

Sean

[MatthewQi]

Quick web search reveals quite a funny thread

http://www.webdeveloper.com/forum/showthread.php?t=165075

 

lmao, thanks

[-O-]

I've seen this error come up again in the last little while.

 

 

 

Might want to consider lazy loading regarding the db connection... here is a good article on the how toos of it.

 

 

 

http://jpipes.com/index.php?/archives/99-M...-Do-Things.html

[Gerard]

I have been experiencing lots of problems trying to access the site:

 

1. Slow loading

2. Sometimes messages don't get posted, they come up with an error message.

 

Is the server overloaded?

 

Cheers.