vb.org Archive - max_user_connections error

Page 1 of 2

Show 40 post(s) from this thread on one page

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

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

- - max_user_connections error (https://vborg.vbsupport.ru/showthread.php?t=199352)

joh	12-20-2008 11:14 AM

max_user_connections error

my site keep emailing me this same message over and over

Quote:

Database error in vBulletin :

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

MySQL Error :
Error Number :
Request Date : Saturday, December 20th 2008 @ 07:26:58 AM
Error Date : Saturday, December 20th 2008 @ 07:26:58 AM
Script : http://www.nsraweb.com/forums/archiv...p?f-8-p-8.html
Referrer :
IP Address : 194.8.75.229
Username :
Classname : vB_Database
MySQL Version :

my host responce was

Quote:

"The max_user_connections error means you've hit the limit of mysql connections available to shared accounts. The limit is in place to prevent one user account from using all available connections and denying service to other customers on the server. We cannot increase the limit without affecting the server's stability.

vBulletin should have an option to disable persistent connections. Check that to make sure it is disabled- it will ensure that mysql connections are closed after a database query is run.

does vBulletin have the option to disable persistent connections. if so where do i find it?

nexialys

12-20-2008 12:15 PM

check for this in the file...

Quote:

/includes/config.php

$config['MasterServer']['usepconnect'] = 0;

joh	12-20-2008 01:11 PM

I looked in the file and it is set to 0

PHP Code:


		
			
// ****** MASTER DATABASE SERVER NAME AND PORT ******  // This is the hostname or IP address and port of the database server.  // If you are unsure of what to put here, leave the default values. $config['MasterServer']['servername'] = 'localhost'; $config['MasterServer']['port'] = 3306; // ****** MASTER DATABASE USERNAME & PASSWORD ******  // This is the username and password you use to access MySQL.  // These must be obtained through your webhost. $config['MasterServer']['username'] = 'nsraweb_ooo0'; $config['MasterServer']['password'] = '00000'; // ****** MASTER DATABASE PERSISTENT CONNECTIONS ******  // This option allows you to turn persistent connections to MySQL on or off.  // The difference in performance is negligible for all but the largest boards.  // If you are unsure what this should be, leave it off. (0 = off; 1 = on) $config['MasterServer']['usepconnect'] = 0; // ****** SLAVE DATABASE CONFIGURATION ******  // If you have multiple database backends, this is the information for your slave  // server. If you are not 100% sure you need to fill in this information,  // do not change any of the values here. $config['SlaveServer']['servername'] = ''; $config['SlaveServer']['port'] = 3306; $config['SlaveServer']['username'] = ''; $config['SlaveServer']['password'] = ''; $config['SlaveServer']['usepconnect'] = 0;

so what do i do now?

nexialys

12-20-2008 01:25 PM

strange.... really...

SEOvB

12-20-2008 03:37 PM

Quote:

Originally Posted by joh (Post 1689503)

I looked in the file and it is set to 0

PHP Code:


		
			
// ****** MASTER DATABASE SERVER NAME AND PORT ******  // This is the hostname or IP address and port of the database server.  // If you are unsure of what to put here, leave the default values. $config['MasterServer']['servername'] = 'localhost'; $config['MasterServer']['port'] = 3306; // ****** MASTER DATABASE USERNAME & PASSWORD ******  // This is the username and password you use to access MySQL.  // These must be obtained through your webhost. $config['MasterServer']['username'] = 'nsraweb_ooo0'; $config['MasterServer']['password'] = '00000'; // ****** MASTER DATABASE PERSISTENT CONNECTIONS ******  // This option allows you to turn persistent connections to MySQL on or off.  // The difference in performance is negligible for all but the largest boards.  // If you are unsure what this should be, leave it off. (0 = off; 1 = on) $config['MasterServer']['usepconnect'] = 0; // ****** SLAVE DATABASE CONFIGURATION ******  // If you have multiple database backends, this is the information for your slave  // server. If you are not 100% sure you need to fill in this information,  // do not change any of the values here. $config['SlaveServer']['servername'] = ''; $config['SlaveServer']['port'] = 3306; $config['SlaveServer']['username'] = ''; $config['SlaveServer']['password'] = ''; $config['SlaveServer']['usepconnect'] = 0;

so what do i do now?

Disable modifications you don't need, or upgrade hosting, or both.

badboyz

12-21-2008 01:05 AM

ur hosting has proly 100 connections per min ask them ot increase it or some one ddosing u

Dismounted

12-21-2008 02:45 AM

Are you on shared hosting?

Marco van Herwaarden

12-22-2008 11:00 AM

If your server control panel (and your host, which i doubt) allows creating multiple MySQL accounts for the same database, then there might be a trick to raise this limit. Otherwise you will need to reduce the number of connection (users) active or move to a higher hosting plan.

joh	12-23-2008 08:20 PM

I am on a shared hosting.
I think they up my level seen that the error stop when I told them that I was going to move my site to a new host and not one of the big buck plans they had.

thanks for all the help.

Cla75

02-24-2010 03:56 PM

Help me guys, please

about 1 hours continuous receive email (at least 5000) with this error

Quote:

Database error in vBulletin :

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

MySQL Error :
Error Number :
Request Date : Wednesday, February 24th 2010 @ 05:35:49 PM
Error Date : Wednesday, February 24th 2010 @ 05:35:49 PM
Script : http://www.XXXXXXXXXXXXXX.com/index.php
Referrer :
IP Address : XXXXXXXXXXXXXXX
Username :
Classname : vB_Database
MySQL Version :

My hosting service says it can not increase the maximum number of connections and advised me to remove the e-mailing of this error. You know how?

Other tips to solve this problem??

help please

All times are GMT. The time now is 01:13 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01065 seconds Memory Usage 1,750KB 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 (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: