2020-10-06, 08:49 PM
The problem:
A crawler (Seekport) started scraping the website at one url a second (or faster) Every attempt it made on each and every page added an entry into the mybb_sessions table. This was fine for a while, but eventually it filled the sessions table, at which point no more sessions could be stored.
This caused Mybb to output an error page while also attempting to send multiple error emails for every page attempt after it could handle no more sessions.
This stopped the website from being accessible by the public (Although I could still access the backend admin)
The fix:
I initially accessed the database directly and purged the whole session table. Doing so removed the problem and the site was up and running again. (Later I realised I probably could of used the Task which is meant for clearing old sessions)
I just thought I would mention it as there might well be a way to either slowdown or block consecutive attempts after a given threshold. While it might be possible to increase the value type to hold more data, it won't stop such further incidents, just prolong the inevitable.
A crawler (Seekport) started scraping the website at one url a second (or faster) Every attempt it made on each and every page added an entry into the mybb_sessions table. This was fine for a while, but eventually it filled the sessions table, at which point no more sessions could be stored.
This caused Mybb to output an error page while also attempting to send multiple error emails for every page attempt after it could handle no more sessions.
This stopped the website from being accessible by the public (Although I could still access the backend admin)
The fix:
I initially accessed the database directly and purged the whole session table. Doing so removed the problem and the site was up and running again. (Later I realised I probably could of used the Task which is meant for clearing old sessions)
I just thought I would mention it as there might well be a way to either slowdown or block consecutive attempts after a given threshold. While it might be possible to increase the value type to hold more data, it won't stop such further incidents, just prolong the inevitable.