max_user_connections error

[joh]

my site keep emailing me this same message over and over
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/archive/index.php?f-8-p-8.html
Referrer :
IP Address : 194.8.75.229
Username :
Classname : vB_Database
MySQL Version :

my host responce was

"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]

check for this in the file...

/includes/config.php

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

[joh]

I looked in the file and it is set to 0

// ****** 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]

strange.... really...

[SEOvB]

I looked in the file and it is set to 0

// ****** 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]

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

[Dismounted]

Are you on shared hosting?

[Marco van Herwaarden]

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]

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]

Help me guys, please

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


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]

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]

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]

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]

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]

Tell your host to increase the "Wait_time" for MySQL