vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   MySQL problem!! Please help! (https://vborg.vbsupport.ru/showthread.php?t=100503)

The Chief 11-10-2005 12:40 AM
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!

akanevsky 11-10-2005 12:43 AM
This is hoster's fault. Tell him about it, as he is the only one who can fix it.

The Chief 11-10-2005 12:56 AM
Well I have contacted them, I really hope they will respond soon, I thought maybe it had something to do with vB???

stonyarc 11-10-2005 10:37 AM
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;

The Geek 11-10-2005 10:56 AM
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.

Marco van Herwaarden 11-10-2005 11:14 AM
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


All times are GMT. The time now is 11:42 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01026 seconds
  • Memory Usage 1,722KB
  • 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
  • (4)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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