Forum SQL error: Too many connections

peter&basti
Posts: 5577
Joined: 09.01.2012, 22:09
Location: Vienna, Austria

Re: Forum SQL error: Too many connections

Post by peter&basti » 08.11.2018, 09:47

Hi Rob,

until 6 am the users increased, later it looked ok with 15 guests.
08:27
Insgesamt sind 18 Besucher online: 3 registrierte, 0 unsichtbare und 15 Gäste (basierend auf den aktiven Besuchern der letzten Minute)
Der Besucherrekord liegt bei 691 Besuchern, die am 08.11.2018, 05:51 gleichzeitig online waren.
What happened betweet 5:51 am and 8:27 am? Any reset?

Obviously the # of guest users increases steadily since 8:27
09:37
Insgesamt sind 212 Besucher online: 2 registrierte, 0 unsichtbare und 210 Gäste (basierend auf den aktiven Besuchern der letzten Minute)
Der Besucherrekord liegt bei 691 Besuchern, die am 08.11.2018, 05:51 gleichzeitig online waren.
09:43
Insgesamt sind 263 Besucher online: 3 registrierte, 0 unsichtbare und 260 Gäste (basierend auf den aktiven Besuchern der letzten Minute)
Der Besucherrekord liegt bei 691 Besuchern, die am 08.11.2018, 05:51 gleichzeitig online waren.
The session length is not the key from my point of view, because in this case also the amount of registered users shall increase significant if there is something going wrong.

rjversluis
Site Admin
Posts: 37093
Joined: 10.04.2006, 08:48
Location: Speyer, Germany
Contact:

Re: Forum SQL error: Too many connections

Post by rjversluis » 08.11.2018, 10:15

I have no idea how to solve this...

peter&basti
Posts: 5577
Joined: 09.01.2012, 22:09
Location: Vienna, Austria

Re: Forum SQL error: Too many connections

Post by peter&basti » 08.11.2018, 11:21

Hi Rob,

when i take a look on the sub-forums eg EN DE NL IT FR, actually there are only 0-4 guests reported. Maybe a misinterpretation because i do not know how this figures are measured in phpBB.

In the total view i can see actual 263 guests, but this is a summary of the last minute. calculated about 4 guests per second.
This does not match to the reported figures i can see in the sub-forums.

Do you have access to a more detailed reporting in the phpBB Environment?

rjversluis
Site Admin
Posts: 37093
Joined: 10.04.2006, 08:48
Location: Speyer, Germany
Contact:

Re: Forum SQL error: Too many connections

Post by rjversluis » 08.11.2018, 11:38

Hi Peter,

I'm Forum Admin, but I do not like to change much; It runs for years.

Maybe I should upgrade the phpBB, but this is not easy...

PaulXpress
Posts: 125
Joined: 06.12.2016, 13:27
Location: France

Re: Forum SQL error: Too many connections

Post by PaulXpress » 08.11.2018, 11:50

For information, from the beginning I never had the problem and the number of users was normal. The accounting must be done by forum.
Utilisateurs.png
You do not have the required permissions to view the files attached to this post.

PaulXpress
Posts: 125
Joined: 06.12.2016, 13:27
Location: France

Re: Forum SQL error: Too many connections

Post by PaulXpress » 11.11.2018, 11:35

Hi Rob,

I just had the problem while the number of users was not important: 4 guests + me. On the other hand I realized that the time displayed for my message is not at the good hour, that can explain the problems of connection.

Regards,
Jean-Paul

smitt48
Posts: 5034
Joined: 04.04.2014, 01:07
Location: Kralendijk, Bonaire - Dutch Caribbean

Re: Forum SQL error: Too many connections

Post by smitt48 » 11.11.2018, 13:00

Hi Jean-Paul,

You have to change the forum time yourself (twice a year). :roll:
User control panel-Board preferences

Tom

PaulXpress
Posts: 125
Joined: 06.12.2016, 13:27
Location: France

Re: Forum SQL error: Too many connections

Post by PaulXpress » 11.11.2018, 13:33

Hi Tom,

Always as efficient and responsive.

Regards,
Jean-paul

cds
Posts: 4707
Joined: 03.02.2012, 19:24
Location: Tullnerbach, Austria

Re: Forum SQL error: Too many connections

Post by cds » 15.11.2018, 07:50

Hello Rob!

Just had the "sql-error" again. 500 guests are online ...

rjversluis
Site Admin
Posts: 37093
Joined: 10.04.2006, 08:48
Location: Speyer, Germany
Contact:

Re: Forum SQL error: Too many connections

Post by rjversluis » 15.11.2018, 07:52

Hi Claus,

me too, but I have only one solution: Close it for Guests...
I did hope PHP 7 would keep them out.

rjversluis
Site Admin
Posts: 37093
Joined: 10.04.2006, 08:48
Location: Speyer, Germany
Contact:

Re: Forum SQL error: Too many connections

Post by rjversluis » 15.11.2018, 07:54

Hi Claus,

I just did disable the Bing and Google bots. Maybe it helps.

rjversluis
Site Admin
Posts: 37093
Joined: 10.04.2006, 08:48
Location: Speyer, Germany
Contact:

Re: Forum SQL error: Too many connections

Post by rjversluis » 15.11.2018, 08:19

Hi,

that does not help.

- I did upgrade the Forum to the latest version.
- I did set the PHP on the provider server to the latest stable PHP 7 version.
- I did test with Cloudflare

It seems, I do not have a solution to reduce the number of guest connections.
Any suggestion is welcome.

Post Reply

Return to “General”