vb.org Archive - max_user_connections error

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

Speysider

02-24-2010 06:06 PM

o_O, 2 year old thread?
You could have just read the responses in this thread when it gives you the same error for a solution.

Cla75

02-24-2010 07:26 PM

I tried to control this

/includes/config.php
$config['MasterServer']['usepconnect'] = 0;

but equal.

I tried to ask my host to increase the connections but it is not possible.

I asked the VB technical support advised me to write here to get a change to the code kindly for not having the constant sending of email for this error.
Can someone help me please?

Speysider

02-24-2010 07:51 PM

Why would you need them to change a code for vBulletin? Just go to your Error Logging Options in vBulletin Options (x2) in the acp to fix the settings.

Marco van Herwaarden

02-25-2010 07:39 AM

Ignoring the error email does not solve the problem your users are having it only hides it from you.

Each of these error mails is the result of a user trying to visit your board and gets an error page.

ChopSuey

02-25-2010 12:46 PM

Tell your host to increase the "Wait_time" for MySQL

All times are GMT. The time now is 10:30 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01251 seconds Memory Usage 1,760KB 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)post_thanks_navbar_search (1)printthread (15)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: