Forum SQL error: Too many connections Topic is solved

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

Forum SQL error: Too many connections

Post by smitt48 » 05.11.2018, 23:57

Hi Rob,

I received an error screen clicking on an item in the forum.
forum error.PNG
This is fyi only, by clicking back and then again on the post it worked again.
Tom
You do not have the required permissions to view the files attached to this post.

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

Re: (solved)Forum SQL error

Post by peter&basti » 06.11.2018, 00:11

Hi Tom,

today i got the same sometimes.
I confirm, after re-select the issue it works again.

In a good case too many people are interested in RR - in a bad case a DDOS attack?

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

Re: (solved)Forum SQL error

Post by rjversluis » 06.11.2018, 07:44

Hi,

I informed my provider of this issue because today a its still appears.

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

Re: (solved)Forum SQL error

Post by rjversluis » 06.11.2018, 08:18

Hi,
Wir haben Ihr Anliegen soeben erneut geprüft. Hierbei können wir Ihnen mitteilen, dass es sich nicht um einen DDoS-Angriff handelt.
The number of connected users can be seen bottom left...

I will check the MySQL.

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

Re: (solved)Forum SQL error

Post by rjversluis » 06.11.2018, 08:27

Hi,

the session tabled did have 50MB overhead.
After a repair command its gone; Maybe it helps to get rid of this message.

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

Re: (solved)Forum SQL error

Post by rjversluis » 06.11.2018, 14:24

Hi,

just saw the error again.

Code: Select all

Insgesamt sind 330 Besucher online: 4 registrierte, 2 unsichtbare und 324 Gäste (basierend auf den aktiven Besuchern der letzten 5 Minuten)
Der Besucherrekord liegt bei 547 Besuchern, die am 04.11.2018, 10:53 gleichzeitig online waren.
330 + 324 = 654
The max. is 1024...

ups60
Posts: 1071
Joined: 30.07.2013, 17:36
Location: 50321 Brühl

Re: (solved)Forum SQL error

Post by ups60 » 06.11.2018, 14:37

rjversluis wrote:Hi,

just saw the error again.

Code: Select all

Insgesamt sind 330 Besucher online: 4 registrierte, 2 unsichtbare und 324 Gäste (basierend auf den aktiven Besuchern der letzten 5 Minuten)
Der Besucherrekord liegt bei 547 Besuchern, die am 04.11.2018, 10:53 gleichzeitig online waren.
330 + 324 = 654
The max. is 1024...
Hi Rob,
i think it's not 654, it's "only" 330, splitted in 324 + 4 + 2.

reg. Uwe

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

Re: (solved)Forum SQL error

Post by peter&basti » 06.11.2018, 21:25

Hi Rob,

i feel something is going weird ...

As of now:
Insgesamt sind 443 Besucher online: 7 registrierte, 1 unsichtbarer und 435 Gäste (basierend auf den aktiven Besuchern der letzten 5 Minuten)
Der Besucherrekord liegt bei 547 Besuchern, die am 04.11.2018, 09:53 gleichzeitig online waren.
We never hat such amount of guest visitors.
It would be very fine if Rocrail generates thus huge amount of interest, but usually i saw 5-20 guests.

Maybe

- a robot
- connections not closed (for instance: i access the Forum by at least 3 different devices, all with "automatic" login)
- something else

This behaviour feels not normal for me.

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

Re: (solved)Forum SQL error

Post by rjversluis » 06.11.2018, 21:54

Hi Peter,

yes, this bothers me too, and I reported again to my provider because I cannot do anything about it.

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

Re: (solved)Forum SQL error

Post by smitt48 » 06.11.2018, 21:56

Hi Rob,

Clicking on your post I received the error again. :shock:

Tom

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

Re: (solved)Forum SQL error

Post by peter&basti » 07.11.2018, 16:40

Hi Rob,

new all-time high score today:
Der Besucherrekord liegt bei 585 Besuchern, die am 07.11.2018, 15:42 gleichzeitig online waren.
About 1 hour ago the forum server was completely out (Network error 443 if i remember correct)

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

Re: (solved)Forum SQL error

Post by rjversluis » 07.11.2018, 17:02

Hi,

I did report it again, and I hope my provider can do something about it.
Seems to be an attack.
Dieses Problem kann auftreten, wenn Datenbankabfragen zu lange laufen, und dadurch Verbindungen belegt sind. Bei uns sind pro Datenbankbenutzer 35 gleichzeitige Verbindungen möglich. Bitte prüfen Sie daher einmal das SlowQuery-Log im CGI-Debugger um solche ggf. zu langsamen Querys zu identifizieren.

https://www.df.eu/blog/cgi-debugger-zur-fehleranalyse/

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

Re: Forum SQL error: Too many connections

Post by rjversluis » 07.11.2018, 22:09

Sorry, aber mit diese DF Hilfe kann ich nix anfangen:
Eine DDOS-Attacke können wir nicht feststellen, bitte prüfen Sie daher einmal die SlowQuerys.

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

Re: Forum SQL error: Too many connections

Post by rjversluis » 08.11.2018, 07:40

Hi,

I just reduced the session length from 10 to 1 minute. Maybe it helps to solve this.

StefanF.
Moderator
Posts: 2995
Joined: 27.10.2008, 21:40
Location: Hamburg/Germany

Re: Forum SQL error: Too many connections

Post by StefanF. » 08.11.2018, 09:13

Hi Rob,
in 1 minute I can not write any text.
Regards
Stefan

Post Reply

Return to “General”