Author Topic: Server Error Reports  (Read 931034 times)

0 Members and 38 Guests are viewing this topic.

Online EEVblog

  • Administrator
  • *****
  • Posts: 42146
  • Country: au
    • EEVblog
Re: Server Error Reports
« Reply #775 on: December 08, 2025, 11:42:55 pm »
 
The following users thanked this post: tooki

Online EEVblog

  • Administrator
  • *****
  • Posts: 42146
  • Country: au
    • EEVblog
Re: Server Error Reports
« Reply #776 on: December 08, 2025, 11:43:39 pm »
Count was just reset.

EDIT: And a few minutes later it's back up to 21,000 guests.
 
The following users thanked this post: tooki

Offline TimFox

  • Super Contributor
  • ***
  • Posts: 11888
  • Country: us
  • Retired, now restoring antique test equipment
Re: Server Error Reports
« Reply #777 on: December 08, 2025, 11:46:36 pm »
And now it’s ok again, here.
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #778 on: December 08, 2025, 11:55:06 pm »
I am still investigating but at this point it seems the fault of google's user-triggered fetcher (aka, google-proxy).

We were seeing massive amounts of traffic originating from it which looked like general website browsing traffic. Either google have missconfigured their proxies as open proxies and/or someone has found a way to exploit them to hide their origin.

As the google-proxy service does not affect our search rankings or accessibility by general users, I have blocked the subnet that was involved in the traffic.
 
The following users thanked this post: EEVblog, MK14

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #779 on: December 09, 2025, 12:20:37 am »
SMF strikes again, while it's not the direct cause, it's certainly part of the problem.

SMF tracks who's online, which is fine, but it also lumps guest tracking into the same table. This is also fine except for two things.

1) It stores the current status of the user as a PHP serialised string, this includes fields like current forum and thread the user is in. It then uses `LIKE` (aka, substring) searches in this text field to determine these values. This is SLOW, and beyond ridiculous.

I have solved this by adding two columns to the table for these fields and altered SMF to populate them correctly and use them for the lookups.

2) When SMF generates the number of users online vs guest stats on the bottom of the page, it does it the worst way possible. It selects EVERY record from the table, guest or not, and if the record isn't associated with a guest, it increments a counter as it iterates over the data set. When we get totally spammed like today, the table fills up with 100k+ "guest/null" entries. This means that on every page load, 100k+ records are pulled from the database, just to count them.  |O

I have solved this by limiting the first query to non-guests only and then running a second `select count(*) from...` query to get the guest count.

While this doesn't solve the bot crawling issue, it should hopefully help to keep things responsive during these high load periods.

Here is the before & after implementing the change, CPU load graph:
« Last Edit: December 09, 2025, 12:23:24 am by gnif »
 
The following users thanked this post: EEVblog, PA0PBZ, tautech, Kean, tooki, MK14, 2N3055, TUMEMBER, pcprogrammer

Online EEVblog

  • Administrator
  • *****
  • Posts: 42146
  • Country: au
    • EEVblog
Re: Server Error Reports
« Reply #780 on: December 09, 2025, 12:37:43 am »
We were seeing massive amounts of traffic originating from it which looked like general website browsing traffic. Either google have missconfigured their proxies as open proxies and/or someone has found a way to exploit them to hide their origin.

My money is on the later. They are evolving.
 

Online tautech

  • Super Contributor
  • ***
  • Posts: 31918
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: Server Error Reports
« Reply #781 on: December 10, 2025, 03:06:15 am »
I noticed that the peak number of guests today set a new record.
Another new one today:
Most Online Ever: 191125 (Today at 08:03:35 am) NZ time

gnif is on the case...
And he did a wonderful job....forum seems back to normal.  :clap:
Avid Rabid Hobbyist
 
The following users thanked this post: gnif

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #782 on: December 10, 2025, 03:23:39 am »
thanks mate, appreciate it.

I am working on a more robust solution to this issue, but it wont be ready for deployment for a while yet.

Seems the SMF fix I put in place is holding up
« Last Edit: December 10, 2025, 03:26:51 am by gnif »
 
The following users thanked this post: EEVblog, PA0PBZ, tautech, HwAoRrDk, MK14, 2N3055, TUMEMBER, pcprogrammer

Offline TimFox

  • Super Contributor
  • ***
  • Posts: 11888
  • Country: us
  • Retired, now restoring antique test equipment
Re: Server Error Reports
« Reply #783 on: December 10, 2025, 03:26:18 pm »
Seems to be running slow again this morning in Chicago.
 

Online squadchannel

  • Super Contributor
  • ***
  • Posts: 1254
  • Country: jp
  • deepl translate user
Re: Server Error Reports
« Reply #784 on: December 10, 2025, 03:28:42 pm »
me too. from japan
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #785 on: December 10, 2025, 03:33:16 pm »
Yup, working on it :)
 
The following users thanked this post: 2N3055, tunk, SteveThackery

Offline TimFox

  • Super Contributor
  • ***
  • Posts: 11888
  • Country: us
  • Retired, now restoring antique test equipment
Re: Server Error Reports
« Reply #786 on: December 10, 2025, 04:57:54 pm »
Seems OK now in Chicago.
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #787 on: December 10, 2025, 05:06:16 pm »
Yeah, it's not region based. The site keeps coming under massive traffic loads from hundreds of thousands of addresses.

Thankfully I saw the writing on the wall a few months back and have been slowly getting all the data access agreements into place to develop this:
https://github.com/gnif/RackRadar

I have just deployed it, it will require some tuning over the next few weeks but so far it's performing extremely well.
The idea is to identify entire DC owned sub nets and filter them since the forum should really never see much, if any, traffic from these networks.

I had hoped to wait a bit longer before deploying it, but well, things keep breaking
 
The following users thanked this post: EEVblog, voltsandjolts, 2N3055

Offline m k

  • Super Contributor
  • ***
  • Posts: 3459
  • Country: fi
Re: Server Error Reports
« Reply #788 on: December 10, 2025, 06:22:50 pm »
Very few users, but over 10k guests.

Are you sure one value is not reversed?

E,
now guests are >22k.
Seems that bots are finding alternative routes.
« Last Edit: December 10, 2025, 06:26:28 pm by m k »
Advance-Aneng-Appa-AVO-Beckman-Danbridge-Data Precision-Data Tech-Fluke-General Radio-H. W. Sullivan-Heathkit-HP-Kaise-Kyoritsu-Leeds & Northrup-Mastech-OR-X-REO-Schneider-Simpson-Sinclair-Tektronix-Tokyo Rikosha-Topward-Triplett-Tritron-YFE
(plus work shop of the world unknowns)
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #789 on: December 10, 2025, 06:41:13 pm »
Very few users, but over 10k guests.

Are you sure one value is not reversed?

E,
now guests are >22k.
Seems that bots are finding alternative routes.

Absolutely sure, there are a lot of genuine guests on this forum, always. Note the numbers though at the moment can't be trusted as I have been purging the table to keep things operational while I tune.
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #790 on: December 10, 2025, 09:42:41 pm »
Ok, I did a ton of tuning and altered SMF again to cache the counts for 2 minutes instead of running those heavy queries on every page load.

RackRadar is in place and has been configured so far on the ip orgs that are hitting us.

It's currently configured to find net blocks belonging to the following based on a manual rule set I have defined.
Code: [Select]
AlibabaCloud
DigitalOcean
HostPapa
Amazon
GoogleCloud
Contabo
Hetzner
OVH
LogicWeb
DataCamp
velia_net
CTGServer
IQ-PL
ACE-SG #tencent
TtyPointNet
MicrosoftCloud
SEMRUSH
ZScaler
Webair
HayHost
EBOX
HSTQ
Ril

This is covering a total of 7,141 net blocks, covering a total of 293,805,946 IPv4 addresses.
Over the next few weeks I will continue to monitor, identify and add problem networks to the system.
« Last Edit: December 12, 2025, 01:40:28 am by gnif »
 
The following users thanked this post: EEVblog, MK14, 2N3055

Online EEVblog

  • Administrator
  • *****
  • Posts: 42146
  • Country: au
    • EEVblog
Re: Server Error Reports
« Reply #791 on: December 10, 2025, 10:40:20 pm »
Will it still allow the traditional search engine bots?
 
The following users thanked this post: MK14

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #792 on: December 11, 2025, 02:59:30 am »
Yes, I have been very careful to not impact the bots we like.
 
The following users thanked this post: EEVblog

Offline paulca

  • Super Contributor
  • ***
  • Posts: 6354
  • Country: gb
Re: Server Error Reports
« Reply #793 on: December 11, 2025, 12:35:45 pm »
Amazon as in AWS?

That'll block a lot more than bots won't it?  Like half the internet?  Anyone that uses it as a private VPN too.
"What could possibly go wrong?"
Current Open Projects:  68000 Self Build computer + OS.
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #794 on: December 11, 2025, 02:53:36 pm »
Amazon as in AWS?

That'll block a lot more than bots won't it?  Like half the internet?  Anyone that uses it as a private VPN too.

Yes, yes and no, AWS is only a fraction of the IP space. Unfortunately they are one of the worst offenders, we hate to be blocking these networks but we are left with little choice.
That said, if we have blocked someone's private VPN, feel free to DM me and I will whitelist it.
Note though that I will not whitelist IPs that belong to VPN providers, if they were blocked, it's because we were seeing too much malicious traffic from them.

For those that are interested, you can see here at around 6AM the new system was activated

Across the day, RackRadar has rejected 2,488,102 connections

« Last Edit: December 11, 2025, 03:07:34 pm by gnif »
 
The following users thanked this post: 2N3055

Offline kloetpatra

  • Regular Contributor
  • *
  • Posts: 91
  • Country: de
Re: Server Error Reports
« Reply #795 on: December 11, 2025, 04:39:53 pm »
unfortunately my ip (Hetzner) got blocked as well (connection refused)
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #796 on: December 11, 2025, 05:11:37 pm »
As I said, DM me the IP and I will whitelist you. No need to pollute this thread with "me too" posts.
 

Offline SteveThackery

  • Super Contributor
  • ***
  • Posts: 3291
  • Country: gb
  • 50 year novice
Re: Server Error Reports
« Reply #797 on: December 13, 2025, 03:49:34 pm »
Uh oh, here we go again.

Saturday 13th December, 15:49 GMT. It's starting to slow down again.
 

Offline TimFox

  • Super Contributor
  • ***
  • Posts: 11888
  • Country: us
  • Retired, now restoring antique test equipment
Re: Server Error Reports
« Reply #798 on: December 13, 2025, 03:55:01 pm »
It’s ok here, shortly after that report.
 

Offline gnifTopic starter

  • Administrator
  • *****
  • Posts: 1934
  • Country: au
  • Views and opinions are my own
Re: Server Error Reports
« Reply #799 on: December 13, 2025, 03:57:45 pm »
Sorry, that was actually me this time adjusting a few things with the new firewall deployment.

EDIT 2025-12-16: Due to a firewall configuration error the site was slow for for a while, this has been corrected and there is no need to report this.
« Last Edit: December 16, 2025, 04:56:34 am by gnif »
 
The following users thanked this post: MK14


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf