General Error 1040 Too Many Connections

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Locked
User avatar
ForumMonkey
Registered User
Posts: 3
Joined: Fri Sep 29, 2006 11:15 am

General Error 1040 Too Many Connections

Post by ForumMonkey » Tue Jan 08, 2008 5:28 am

Hi all,

We have had this error a couple of times since we updated to phpBB3 and I am wondering if anybody on here has a solution for us.
1040 SQL Error.jpg
1040 SQL Error.jpg (42.12 KiB) Viewed 13474 times
We are aware, from a topic on the phpBB forums, that other people are having the problem. In addition, the phpBB main board seems to have had this problem at some stage.

viewtopic.php?f=6&t=29086&p=190073&hili ... 40#p190073

What was done to fix this problem? Just increase the connections? Never happened to us on phpBB2.

Thanks in advance.
Certified Speed Freak
Image

User avatar
Kevin Clark
Support Team
Support Team
Posts: 751
Joined: Thu Feb 10, 2005 5:34 pm
Location: UK
Contact:

Re: General Error 1040 Too Many Connections

Post by Kevin Clark » Tue Jan 08, 2008 8:56 am

The main support board at phpbb.com is the place to ask.

But....

It's purely a hosting issue. You're on a shared server and the total number of connections for all the sites on it is going over a preset value. Ask your hosts to move you to a quieter server or up the limit.
Image

AdeRickus
Registered User
Posts: 1
Joined: Wed Jan 16, 2008 10:32 am
Location: Staffordshire, UK
Contact:

Re: General Error 1040 Too Many Connections

Post by AdeRickus » Wed Jan 16, 2008 10:39 am

Although the general reply from you guys is its a server problem,

I also disagree,

We are using a dedicated server, serving about 5000 users, only 30 or so are online at any one time

We have reduced the timeout for the SQL down to 40 seconds, however, PHPBB3 seems to open connections so fast, the server sometimes cant close them fast enough

I agree this is a bug, and when reported as such, we are all getting the same response,

Does anyone else agree ?

User avatar
Acyd Burn
Posts: 1838
Joined: Tue Oct 08, 2002 5:18 pm
Location: Behind You
Contact:

Re: General Error 1040 Too Many Connections

Post by Acyd Burn » Wed Jan 16, 2008 11:07 am

Generally, the email MX and blackhole list check can consume a lot of time if the connection can't be established, resulting in the connection "waiting" and then closing before phpBB gets to close the connection.

Image

Kraboolah
Registered User
Posts: 2
Joined: Tue Mar 18, 2008 7:45 am

Re: General Error 1040 Too Many Connections

Post by Kraboolah » Tue Mar 18, 2008 7:50 am

We tried to disable the two "blacklists", on the two differents (physical) servers we're getting the problem (one has two phpbb3 boards, the other one only). Actually the IP list was already disabled and we disabled the MX one.

We did this sunday afternoon.
The problem arrised again on the server with the single board.

Next try (just set it up) is to lower mysql timeout.

Kraboolah
Registered User
Posts: 2
Joined: Tue Mar 18, 2008 7:45 am

Re: General Error 1040 Too Many Connections

Post by Kraboolah » Tue Mar 25, 2008 7:43 pm

Disabling the blacklists did not help at all.

We limited the SQL timeout to 20 seconds on one server (the one with one forum only), it's ok.
OTOH, we did not limit the timeout on the second one (the one with two fora) and we got three "too many connections" during the week-end 8-(

supertux
Registered User
Posts: 2
Joined: Mon Jul 09, 2007 8:06 pm

Re: General Error 1040 Too Many Connections

Post by supertux » Fri Apr 04, 2008 11:37 pm

This also occurs with forum. It seems overload at mysql database. This occurs mainly after updating the index of searching through the fulltext native. Sometimes solves re-synchronizing.
See it, for example:

http://www.phpbb.com/community/viewtopic.php?p=1638874

spawn_diabolik
Registered User
Posts: 1
Joined: Sun Jun 06, 2010 2:05 pm

Re: General Error 1040 Too Many Connections

Post by spawn_diabolik » Sun Jun 06, 2010 2:09 pm

i know it is an OLD post , but my searches let me here severeal times.

i have the same issue on :

MySQL version 5.0.77
php version : php-5.1.6-27.el5.i386
phpbb version : 3.0.7-PL1
on apache under fedora

a tip if you please ? Thank you.

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 1764
Joined: Thu Mar 02, 2006 4:29 pm
Location: Earth
Contact:

Re: General Error 1040 Too Many Connections

Post by DavidIQ » Sun Jun 20, 2010 8:53 pm

Please post in our official support forums on phpbb.com
Image

Locked