vb.org Archive - Database error: too many connections includes/class

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Database error: too many connections includes/class_core.php (https://vborg.vbsupport.ru/showthread.php?t=279197)

temsamane

02-26-2012 07:22 PM

Database error: too many connections includes/class_core.php

every day i got a lot of these database errors in my mail inbox.

the message is the same, but ip adresses are different.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/jamalbbb/public_html/WEBSITE.nl/forums/includes/class_core.php on line 315

MySQL Error :
Error Number :
Request Date : Sunday, February 26th 2012 @ 09:45:33 AM
Error Date : Sunday, February 26th 2012 @ 09:45:33 AM
Script : http://www.WEBSITE.nl/forums/showthread.php?t=2314
Referrer :
IP Address : 76.72.167."""
Username :
Classname : vB_Database
MySQL Version :

Lynne

02-26-2012 08:29 PM

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:

PHP Code:


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

But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages

BigAl205

02-26-2012 09:29 PM

Are you using Hostgator as your host? I used to get it all the time, but since I switched to Gigapros, I haven't had any more problems.

temsamane

02-26-2012 10:37 PM

i am using arvixe

--------------- Added [DATE]1330303775[/DATE] at [TIME]1330303775[/TIME] ---------------

Quote:

Originally Posted by Lynne (Post 2303723)

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:

PHP Code:


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

But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages

thank you for this respons

i tried this, but its not working lynne

Lynne

02-27-2012 03:54 PM

If that's not working, then you need to contact your host about the error.

temsamane

02-28-2012 11:42 AM

the host is telling me this:

Quote:

this error indicates that your account has too many active connections to the database server at any one time. This is usually due to the site being too busy, or having some error that is not closing database connections after they are being made.
Are your database connections all coming from the same user, or do you have a unique user for each script/database that is configured?

but i don't have a lot of page views, just 1000 a day. ( i have only only database user).

The hosting cant solve this problem.

what do they mean about: 'some error that is not closing database connections after they are being made'?

can i solve this?

Lynne

02-28-2012 04:34 PM

You solve it by getting a host that allows more connections.

Sarteck

02-28-2012 08:09 PM

What Lynne said is true, but several years ago I was running into the same problem, and it was some stuff that I wrote as well as some third-party modifications that were causing the problem, clogging stuff up. So, if switching hosts is not a feasible solution for you and you do have some addons, try disabling them. If that "solves" your problem, you know the issue is with one of them--if not, then you're pretty much SoL, and just have to get a better host. XD

temsamane

03-02-2012 08:48 AM

Quote:

Originally Posted by Lynne (Post 2304332)

You solve it by getting a host that allows more connections.

i think that's the best solution

--------------- Added [DATE]1330685400[/DATE] at [TIME]1330685400[/TIME] ---------------

Quote:

Originally Posted by Sarteck (Post 2304404)

i will disable all the mods for some days. We have to try everything before we leave to another host. Thanks Sarteck

Sarteck

03-04-2012 02:17 PM

Hey temsamane, just checking back to see if you got this somewhat resolved. Do you need a new host, or was it a plugin causing the problem?

toutatis

11-30-2013 11:34 PM

hey i need an answer too. please tell us truth about it.

All times are GMT. The time now is 04:13 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01734 seconds Memory Usage 1,738KB 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 (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (11)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
Messages: