Theater
03-29-2009, 03:42 PM
This one is for the people who like challenges. I have a vBulletin community which has been plagued by database crashes and hang-ups for over a month now. At first we thought it was the server we were on since it was single core, but our concurrent users have been relatively low (less than 200) due partly from all the instability. So we bought a dedicated quad-core mysql server box with plenty of RAM, but the errors keep coming.
Some of them have been specific database table crashes. Such as threads, users, and tagsearch. The vast majority however is this one:
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User <snipped>_dbase already has more than 'max_user_connections' active connections
/usr/home/<snipped>/public_html/<snipped>/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Sunday, March 29th 2009 @ 12:01:03 AM
Error Date : Sunday, March 29th 2009 @ 12:01:03 AM
Script : <snipped>
Referrer : <snipped>
IP Address : <snipped>
Username :
Classname : vB_Database
MySQL Version :
I double-checked with my host provider and the max connection setting is set at 650 for the new server. Again, these aren't new errors. I actually have quite literally over 30,000 error reports in my Gmail inbox... :p
I don't think it's a server setting at this point because we've been on two servers with this happening. Especially now that we're using our own MySQL dedicated server box.
I've used some mods from here, but I'm not sure what would be causing those connection slots to be used. I currently have installed these mods:
AddonChat Bridge Mod - 3.7.0.0
All Albums - 2.5
AME - 2.5.4
Automatic Thread Tagger - 1.2.0
CinVin Forum Listing - 2.4.1
Cyb Adv Forum Stats - 5.8.1
Cyb Adv Registration - 1.6
Cyb - Last Post Info Enhancements - 1.2
Cyb - Sub-forum Manager - 2.2
ibProArcade - 2.6.8
Icons for UserCP - 1.3
Post Thank You - 7.7
ProvB Adv Forums - 1.0.0
Quick Editor Improver - 3.0
Radio and TV - 2.0
Separate Sticky and Normal Threads - 1.0.5
Social Group Homepage Stats - 1.0
Social Group Message Quote - 1.0
vB Post Templates - 1.5.0
vBadvanced CMPS - 3.1.0
vBadvanced Links Director - 3.1.0
vBulletin Blog - 2.0.1 PL1
vMoods by Zone365.com - 1.1.3
YoBroMoFo Playlist - 3.0
Youtube/Google Downloader - 2.2
[V i e t VBB.VN] Attach Stats - 3.8.002 **
We're running the latest 3.8.1 PL1 vBulletin build as well with no file modifications other than renaming index.php to forum.php.
** I just uninstalled that last one considering the name of the modification is censored out here so I put spaces in it in case there is something really wrong with it since I did have it installed. :confused:
Any advice or suggestions are appreciated. Thank you!
Some of them have been specific database table crashes. Such as threads, users, and tagsearch. The vast majority however is this one:
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User <snipped>_dbase already has more than 'max_user_connections' active connections
/usr/home/<snipped>/public_html/<snipped>/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Sunday, March 29th 2009 @ 12:01:03 AM
Error Date : Sunday, March 29th 2009 @ 12:01:03 AM
Script : <snipped>
Referrer : <snipped>
IP Address : <snipped>
Username :
Classname : vB_Database
MySQL Version :
I double-checked with my host provider and the max connection setting is set at 650 for the new server. Again, these aren't new errors. I actually have quite literally over 30,000 error reports in my Gmail inbox... :p
I don't think it's a server setting at this point because we've been on two servers with this happening. Especially now that we're using our own MySQL dedicated server box.
I've used some mods from here, but I'm not sure what would be causing those connection slots to be used. I currently have installed these mods:
AddonChat Bridge Mod - 3.7.0.0
All Albums - 2.5
AME - 2.5.4
Automatic Thread Tagger - 1.2.0
CinVin Forum Listing - 2.4.1
Cyb Adv Forum Stats - 5.8.1
Cyb Adv Registration - 1.6
Cyb - Last Post Info Enhancements - 1.2
Cyb - Sub-forum Manager - 2.2
ibProArcade - 2.6.8
Icons for UserCP - 1.3
Post Thank You - 7.7
ProvB Adv Forums - 1.0.0
Quick Editor Improver - 3.0
Radio and TV - 2.0
Separate Sticky and Normal Threads - 1.0.5
Social Group Homepage Stats - 1.0
Social Group Message Quote - 1.0
vB Post Templates - 1.5.0
vBadvanced CMPS - 3.1.0
vBadvanced Links Director - 3.1.0
vBulletin Blog - 2.0.1 PL1
vMoods by Zone365.com - 1.1.3
YoBroMoFo Playlist - 3.0
Youtube/Google Downloader - 2.2
[V i e t VBB.VN] Attach Stats - 3.8.002 **
We're running the latest 3.8.1 PL1 vBulletin build as well with no file modifications other than renaming index.php to forum.php.
** I just uninstalled that last one considering the name of the modification is censored out here so I put spaces in it in case there is something really wrong with it since I did have it installed. :confused:
Any advice or suggestions are appreciated. Thank you!