Database error persistant since 3 years! Please help

[Lynne]

This error:

User [my_database_name] already has more than 'max_user_connections' active connections

is a server error and if you don't tell your host exactly what error you are getting, then they aren't going to know how to fix this one. It can show up intermittently and so they may never see it. If you've never given the host the exact error, then it's really no wonder that they have never fixed it for you.

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

[ehabfouad22]

Originally Posted by Lynne

This error:

User [my_database_name] already has more than 'max_user_connections' active connections

is a server error and if you don't tell your host exactly what error you are getting, then they aren't going to know how to fix this one. It can show up intermittently and so they may never see it. If you've never given the host the exact error, then it's really no wonder that they have never fixed it for you.

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 very much, Lynne! I appreciate it.
The code you provided ($config['MasterServer']['usepconnect'] = 0 ) is already there in my config.php
Can I raise the limit myself? or should I contact the host for raising it. Is there any recommended value of that limit?
Many thanks, guys! That was really helpful

[Paul M]

No, you cannot raise it yourself. Contact your host.

[ehabfouad22]

Originally Posted by Paul M

No, you cannot raise it yourself. Contact your host.

Thank you Paul,
I got this reply from my host:
"Dear Ehab,

I am sorry you are having issues with your website. The reason you are experiencing this error is because the limit of mysql connections is 10. There is no way to increase this limit, but the error is most likely caused by your connections not being closed. Ensure that your websites code is closing the database connections immediately after use. This will decrease the chance of this error occurring"

Now do you see that the value (10) is so low that it may cause this frequent error? If so, I would change my host to another one which provides a higher limit.
If you see that the value is sufficient, I would be grateful if you give me information on how to make sure that the forum codes is closing the database connections immediately after use.
Thanks in advance!
Ehab

[Lynne]

10?!?! Wow. I have heard of some hosts keeping it as low as 25, but never 10. Yes, that is low.

Try disabling your mods for a few days and see if you still have the same problem.

[ehabfouad22]

Originally Posted by Lynne

10?!?! Wow. I have heard of some hosts keeping it as low as 25, but never 10. Yes, that is low.

Try disabling your mods for a few days and see if you still have the same problem.

Thank you, Lynne..
I've disabled the Chatbox mod for now, and I'm upgrading to a VPS hosting soon. I've been suffering for so long from the shared packages, and I think it's time to seek a little peace of mind. I hope this would be a solution.
Thanks a lot for your time, guys.
Sincerely, Ehab

[Gamelobby]

I have similar issues randomly once or twice a month.
I will keep an eye out for the source code next time it happens.

Originally Posted by ehabfouad22

Thank you Paul,
I got this reply from my host:
"Dear Ehab,

I am sorry you are having issues with your website. The reason you are experiencing this error is because the limit of mysql connections is 10. There is no way to increase this limit, but the error is most likely caused by your connections not being closed. Ensure that your websites code is closing the database connections immediately after use. This will decrease the chance of this error occurring"

Now do you see that the value (10) is so low that it may cause this frequent error? If so, I would change my host to another one which provides a higher limit.
If you see that the value is sufficient, I would be grateful if you give me information on how to make sure that the forum codes is closing the database connections immediately after use.Thanks in advance!
Ehab

That would be GREAT information.!!

Originally Posted by Lynne

10?!?! Wow. I have heard of some hosts keeping it as low as 25, but never 10. Yes, that is low.

Try disabling your mods for a few days and see if you still have the same problem.

Which host only gives you 10.?




Thanks

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

I got the error again.. here is what it said.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title> Database Error</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
	<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
	<style type="text/css">
	<!--	
	body { background-color: white; color: black; }
	#container { width: 400px; }
	#message   { width: 400px; color: black; background-color: #FFFFCC; }
	#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
	.bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
	a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
	a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
	-->
	</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
	<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
	<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The  database has encountered a problem.</td>
</tr>
<tr>
	<td colspan="2"><hr /></td>
</tr>
<tr>
	<td class="bodytext" colspan="2">
		Please try the following:
		<ul>
			<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
			<li>Open the <a href="/">www.gamelobby.com</a> home page, then try to open another page.</li>
			<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
		</ul>
	</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The www.gamelobby.com forum technical staff have been notified of the error, though you may <a href="mailto:Info@Gamelobby.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>
 
 
<!--
Database error in vBulletin :
 
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/content/m/i/l/milo327/html/Forum/includes/class_core.php on line 311
 
MySQL Error   : 
Error Number  : 
Request Date  : Monday, November 8th 2010 @ 01:05:46 PM
Error Date    : Monday, November 8th 2010 @ 01:05:46 PM
Script        : http://www.gamelobby.com/Forum/cmps_index
Referrer      : http://www.gamelobby.com/
IP Address    : 108.13.48.18
Username      : 
Classname     : vB_Database
MySQL Version : 
-->
 
 
</body>
</html>

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

latest error code..

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/content/m/i/l/milo327/html/Forum/includes/class_core.php on line 311

[ehabfouad22]

Originally Posted by Gamelobby

Which host only gives you 10.?

Network Solutions.

[thespi]

Heres one I get:

Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_medium help, vbenterprisetranslator_cache_medium cache WHERE help.originaltext='by+Aristotle+%0Ahttp%3A%2F%2Fwww.carpediem.im%2Fattachment.php%3Fattachmentid%3D49+%0ATranslation+by+W.+D.+Ross+%0A+%0ABook+I+%0ABook+II+%0ABook+III+%0ABook+IV+%0ABook+V+%0ABook+VI' AND help.tl='pt' AND cache.serie=help.serie;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, December 2nd 2010 @ 04:09:16 PM
Error Date    : Thursday, December 2nd 2010 @ 04:11:59 PM
Script        : http://www.carpediem.im/pt/showthread.php/1237-Nicomachean-Ethics-by-Aristotle?p=1664&viewfull=1
Referrer      :
IP Address    : 119.63.198.95
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[Lynne]

"MySQL Server has gone away" is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265