Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2005, 12:40 AM
The Chief's Avatar
The Chief The Chief is offline
 
Join Date: Aug 2005
Location: Montreal
Posts: 1,037
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL problem!! Please help!

Ok, there have been two problems so far with my MySQl table while I was gone, and I recieved over 100 emails from my vBulletin board telling me that there has been an error.

Here are the 3 emails:

De: <thechief@gamebgs.com>
?: <thechief@gamebgs.com>
Objet: vBulletin Database Error!
Date: November 9, 2005 7:23 PM

Database error in vBulletin :

Code:
mysql_connect(): User gamebgs_admin has already more than 'max_user_connections' active connections
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error  :
Error Number :
Date         : Thursday, November 10th 2005 @ 12:23:31 AM
Script       : http://etalk.gamebgs.com/forums/index.php
Referrer     :
IP Address   : 69.230.135.249
Username     :
Classname    : vb_database
Here is another email...

Code:
Database error in vBulletin :

mysql_connect(): Too many connections
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error  :
Error Number :
Date         : Thursday, November 10th 2005 @ 02:01:44 AM
Script       : http://etalk.gamebgs.com/forums/index.php
Referrer     : http://etalk.gamebgs.com/index.html
IP Address   : 205.188.116.10
Username     :
Classname    : vb_database
And the last one...


Code:
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error  :
Error Number :
Date         : Thursday, November 10th 2005 @ 02:10:41 AM
Script       : http://etalk.gamebgs.com/forums/index.php
Referrer     :
IP Address   : 64.12.116.9
Username     :
Classname    : vb_database



Can some please help me fix this, my users can't login bvecause of this and they keep getting errors!!

Thanks!
Reply With Quote
  #2  
Old 11-10-2005, 12:43 AM
akanevsky akanevsky is offline
 
Join Date: Apr 2005
Posts: 3,972
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is hoster's fault. Tell him about it, as he is the only one who can fix it.
Reply With Quote
  #3  
Old 11-10-2005, 12:56 AM
The Chief's Avatar
The Chief The Chief is offline
 
Join Date: Aug 2005
Location: Montreal
Posts: 1,037
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well I have contacted them, I really hope they will respond soon, I thought maybe it had something to do with vB???
Reply With Quote
  #4  
Old 11-10-2005, 10:37 AM
stonyarc stonyarc is offline
 
Join Date: Aug 2005
Location: Leuven (Belgium)
Posts: 930
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well it might be

Can you please check your /includes/config.php for this line and tell us what the value is?

If the value is 1 try setting it to 0
Code:
	//	****** 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;
Reply With Quote
  #5  
Old 11-10-2005, 10:56 AM
The Geek's Avatar
The Geek The Geek is offline
 
Join Date: Sep 2003
Location: Behind you
Posts: 2,779
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Im not a master admin, however unless you have access to your mysql conig file, your host will need to change it. It may also be some rouge script that has hijacked mysql resources. I had this once. Only solution was to periodically reboot which was a serious pain. I eventually moved servers and left behind whatever script caused it (my personal feelings was that it was with a particular email program that plugged into vb).

Personally, I would be my money its a rouge script.
Reply With Quote
  #6  
Old 11-10-2005, 11:14 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Using pconnect can also cause these symptoms.

What vB version are you using? If you look at vb.com you will see an increased number of reports on similar errors since 3.5.1
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:34 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04045 seconds
  • Memory Usage 2,210KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete