vb.org Archive - About 100 DB error messages-too many connections?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - About 100 DB error messages-too many connections? (https://vborg.vbsupport.ru/showthread.php?t=211333)

MTGDarkness

04-16-2009 01:33 AM

About 100 DB error messages-too many connections?

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

04-16-2009 02:38 AM

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

04-16-2009 02:42 AM

Quote:

Originally Posted by MTGDarkness (Post 1792138)

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

04-16-2009 02:58 AM

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

good luck

MickDoneDee

04-16-2009 05:08 AM

Quote:

Originally Posted by snakes1100 (Post 1792163)

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:

Code:

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

All times are GMT. The time now is 07:09 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01024 seconds Memory Usage 1,724KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: