Database Errors Since 3.8 Upgrade

[otpsoft]

Hi,

Since upgrading to 3.8 last Saturday I have had many complaints that the forum is slow to load and I have now had the following error twenty times in the past three days.

How do I fix it:

Database error in vBulletin :

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

MySQL Error :
Error Number :
Request Date : Thursday, January 22nd 2009 @ 02:52:31 AM
Error Date : Thursday, January 22nd 2009 @ 02:52:32 AM
Script : http://www.buellersdownunder.com/picture.php?pictureid=1338&albumid=95&dl=1228042945&thumb=1
Referrer : http://www.buellersdownunder.com/album.php?albumid=95
IP Address : 60.230.201.203
Username :
Classname : vB_Database
MySQL Version :


Any help will be greatly appreciated.

Otpsoft

[Marco van Herwaarden]

You will need to contact your host to raise the maximum number of connections

[otpsoft]

They have already upped the Apache "Max_Connections.
The above error is in the VB Database ........
Using the diagnostics tool in admincp shows that max_user_connections is set in the MySQL database at 30 ............................. how do I lift this limit ?

[Marco van Herwaarden]

Your host will need to change the MySQL configuration.

[whaase]

They have already upped the Apache "Max_Connections.
The above error is in the VB Database ........
Using the diagnostics tool in admincp shows that max_user_connections is set in the MySQL database at 30 ............................. how do I lift this limit ?

I just went through this exact same thing. My hosting company was great in helping me figure this out, so ill pass it on :)

When your database gets errors it will create "overhead". A bit is ok, but I had 22 megs lol. When vBulletin makes a connection to your database, it should release it. When you have a lot of errors in the database, it locks or freezes connections forcing vBulletin to make another.

What I had to do was have the hosting company clear all those forzen/locked connections. Then do a repair/optimize on the database. And stay on top of it. I now do a repair daily just because. I'm also trying to track down what it is that is causing most of my errors. Add ons/plugins can do it, but you have to figure out which one is the culprit lol

30 connections should be more then enough for even a big forum. I was amazed how much faster the forum has been running after getting this all fixed.

Hope it helps

[TNCclubman]

Did you turn off your forum before the upgrade? Sounds like you built up a bunch of errors while you were upgrading as mentioned above and now its clogging your system.

[whaase]

Just another note

My system was so clogged, I could not even run the database repair. I couldn't connect to it until the host company killed some of those connections.

I have a small forum, maybe 20-25 users on at once. My Max connections is set at 65. You can do the math on that one lol upping the max connections is a bandaid solution, you will have to find the cause first. I would start with getting it cleared out, optimize the database, then start searching the logs to see what errors are going on. I've noticed quite a few with our acrade, I may turn it off to see what happens. I've also seen quite a few with the 'search' button. I'm not sure yet what to do with that one.

Walter