Page 1 of 2

Board is SLOW

Posted: Mon Dec 03, 2018 11:57 pm
by therube
Board is SLOW of late.

Re: Board is SLOW

Posted: Tue Dec 04, 2018 1:03 am
by GµårÐïåñ
It is but not too bad. Afterall years of data is hogging the database and it takes up space and parsing that will take longer over time.

Re: Board is SLOW

Posted: Wed Dec 05, 2018 9:04 pm
by barbaz
I too have noticed this slowness in the last few days. It's tolerable for normal browsing, but it really kills my scripts for this site.

Re: Board is SLOW

Posted: Thu Dec 06, 2018 3:59 pm
by therube
it really kills my scripts for this site
Is it this, slowness, or is it Sledge, or is it just my Sledge is outdated?

The other day, when I originally posted this SLOW, at some point it kind of worked, at least it (eventually) displayed the prompts, but then on clicking it, it did not do what it should have, del+ban.

Re: Board is SLOW

Posted: Thu Dec 06, 2018 4:05 pm
by therube
In addition to SLOW, thinking it is the board itself too.

Even 'Select All' in a

Code: Select all

 box is not working.

Sledge was last updated March 2018, so I must be current with that.

Re: Board is SLOW

Posted: Thu Dec 06, 2018 4:16 pm
by barbaz
therube wrote:Even 'Select All' in a

Code: Select all

 box is not working.[/quote]
[img]http://i.psyche.me/confused_2.gif[/img] It works fine for me.

Re: Board is SLOW

Posted: Thu Dec 06, 2018 5:30 pm
by therube
Ah, you're right, oh, & that's going to be the reason why Sledge wasn't working - I had, javascript.enabled;false.
Must have toggled it at some point, for some reason, & forgotten about it.

Anyhow, things here are still slow :-).

Re: Board is SLOW

Posted: Tue Dec 18, 2018 10:55 pm
by barbaz
Now the slowness is intermittent, and sometimes I just get this error during the periods of slowness -
General Error

SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Re: Board is SLOW

Posted: Wed Dec 19, 2018 1:54 pm
by therube
Now the fastness is even more intermittent ;-).

And as of yesterday, even more of these too:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
(I wanted to report this yesterday, but the board was too intermittent ;-).)
(Updated SQLite is out, perhaps with yet another .dot release due too, even if it may happen to be immaterial to this board's issue.)

Re: Board is SLOW

Posted: Wed Dec 19, 2018 1:54 pm
by therube
Now the fastness is even more intermittent ;-).

And as of yesterday, even more of these too:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
(I wanted to report this yesterday, but the board was too intermittent ;-).)
(Updated SQLite is out, perhaps with yet another .dot release due too, even if it may happen to be immaterial to this board's issue.)

Re: Board is SLOW

Posted: Wed Dec 19, 2018 4:51 pm
by GµårÐïåñ
I am getting the same thing. Unless the site is under attack, this should not be happening.

Re: Board is SLOW

Posted: Wed Dec 19, 2018 11:06 pm
by Giorgio Maone
I've been investigating a bit. It might be a DDOS, but we also had more than 200K registered users, of which just 4K had posts.
I've deleted them and restarted the SQL Server. Let's watch how it goes...

Re: Board is SLOW

Posted: Wed Dec 19, 2018 11:45 pm
by barbaz
Thanks Giorgio for looking into this, but...
Giorgio Maone wrote: we also had more than 200K registered users, of which just 4K had posts.
I've deleted them
... one of these users, "kol", had a lot of PM exchanges with me, more than enough for me to know they're a legitimate user. Deleting their account not only seems erroneous, it might be causing glitches for me. Now sometimes when accessing my PMs, the forum is logging me out. And I seem to be missing the PMs they sent me.

Would it be possible to restore kol's account, while keeping the other zero-post users deleted?

EDIT I think the old link to kol's account might be https://forums.informaction.com/memberl ... e&u=263513

Re: Board is SLOW

Posted: Thu Dec 20, 2018 12:32 am
by Giorgio Maone
barbaz wrote: Would it be possible to restore kol's account, while keeping the other zero-post users deleted?
I've actually restored his and all the other 200K, because I've found the culprit and it was (is) a DDOS attack indeed.
Attackers are mostly 39.105.x.x and 46.229.168.x.
They've got plenty spare IPs and are creating hundreds of distinct guest sessions per minute from each IP, clogging the sessions table and putting the SQL server down to its knees.
I've deployed some dynamic countermeasures (not based on their IPs) which seem to be working for now :)
Let's cross our fingers...

Re: Board is SLOW

Posted: Thu Dec 20, 2018 12:43 am
by barbaz
Board is back to normal speed atm, and restoring kol's account looks to have fixed the logout glitch for me. Thank you Giorgio for resolving this! 8-)