Page 2 of 2

Re: Forum SQL error: Too many connections

Posted: 08.11.2018, 09:47
by peter&basti
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.

Re: Forum SQL error: Too many connections

Posted: 08.11.2018, 10:15
by rjversluis
I have no idea how to solve this...

Re: Forum SQL error: Too many connections

Posted: 08.11.2018, 11:21
by peter&basti
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?

Re: Forum SQL error: Too many connections

Posted: 08.11.2018, 11:38
by rjversluis
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...

Re: Forum SQL error: Too many connections

Posted: 08.11.2018, 11:50
by PaulXpress
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

Re: Forum SQL error: Too many connections

Posted: 11.11.2018, 11:35
by PaulXpress
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

Re: Forum SQL error: Too many connections

Posted: 11.11.2018, 13:00
by smitt48
Hi Jean-Paul,

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

Tom

Re: Forum SQL error: Too many connections

Posted: 11.11.2018, 13:33
by PaulXpress
Hi Tom,

Always as efficient and responsive.

Regards,
Jean-paul

Re: Forum SQL error: Too many connections

Posted: 15.11.2018, 07:50
by cds
Hello Rob!

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

Re: Forum SQL error: Too many connections

Posted: 15.11.2018, 07:52
by rjversluis
Hi Claus,

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

Re: Forum SQL error: Too many connections

Posted: 15.11.2018, 07:54
by rjversluis
Hi Claus,

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

Re: Forum SQL error: Too many connections

Posted: 15.11.2018, 08:19
by rjversluis
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.

Re: Forum SQL error: Too many connections

Posted: 15.11.2018, 19:58
by smitt48
Hi,

I just received an SQL error 14:58 Atlantic Timezone
WHO IS ONLINE
In total there are 563 users online :: 5 registered, 1 hidden and 557 guests (based on users active over the past 4 minutes)
Most users ever online was 585 on 15.11.2018, 14:50

Registered users: Bing [Bot], Dampfwilli, richbert, smitt48, ups60
Legend: Administrators, Global moderators
Tom

Re: Forum SQL error: Too many connections

Posted: 18.12.2018, 18:44
by smitt48
Hi Rob,

I was locked out for a while, after read a post.

Tom

Re: Forum SQL error: Too many connections

Posted: 18.12.2018, 19:05
by rjversluis
Hi Tom,

I also had this error, and I reported it to my provider.
This error ist not the same as the "too many connections".
But it seems to work again. :mrgreen: