About 100 DB error messages-too many connections?

[MTGDarkness]

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User <snip> already has more than 'max_user_connections' active connections
<snip>forums/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, April 15th 2009 @ 07:00:20 PM
Error Date : Wednesday, April 15th 2009 @ 07:00:20 PM
Script : http://forums.mtgdarkness.com/ajax.p...ownewresponses


Referrer : http://forums.mtgdarkness.com/play-me-mws-p96469.html


IP Address : 203.10.76.15
Username :
Classname : vB_Database
MySQL Version :

The referrer is different every time. What does this mean, and why did I get about 100 messages telling me about it?

[snakes1100]

It means your host has set a limit as to how many times your db user can connect to your db, talk to your host about raising the limit of connections for that user.

[TigerC10]

Originally Posted by MTGDarkness

The referrer is different every time. What does this mean, and why did I get about 100 messages telling me about it?

Either you have way more people accessing your site than your host will allow, or you have a lot of spider bots checking your site.

Alternatively, you could have installed/created a modification that tries to connect to the database manually, and if the developer forgot to close the connection to the database connection then it would leave the connection open and start a new one.

[Brandon Sheley]

Get a better host
what type of plan are you on now, shared vps dedicated?
who is your host

good luck

[MickDoneDee]

Originally Posted by snakes1100

It means your host has set a limit as to how many times your db user can connect to your db, talk to your host about raising the limit of connections for that user.

If you are on a shared plan like I am and your site is crawled by many bots at the same time this error will be flagged. Since my ISP had already raised the connection limit for my site I had to block the Yahoo! Slurp Spider because there would be as many as 200 visiting my site at the same time. I asked Yahoo to limit the number of crawlers to my site. When they ignored my request I blocked the crawler using .htaccess.

I put this code at the bottom of the .htaccess file:

 # Deny access to Yahoo! Slurp spider
 RewriteCond %{HTTP_USER_AGENT} Slurp
 RewriteRule .* - [F,L]

Now, I get about 2 Yahoo! Slurp Spiders a day instead of hundreds. I've never received a 'max_user_connections' error since.