Related to my previous post, where I mentioned gserver was one of the biggest table, I’ve done some research on that. Of the 7.5 million rows in that table right now 7.3 million of them are from the *.activitypub-troll.cf. Although there hasn’t been any worker events created for it as far as I can tell it is still building up in the gserver table tremendously. In fact since yesterday afternoon there are now almost 1 million more entries, almost all of them are of this variety.

Two questions, first how do we really stop this? I’m honestly thinking about putting a firewall rule in place but if this is coming from another server initiating it that won’t help. Second, is there a command line way of doing the “purge” operation the same way one would do that when first setting up the block? Unfortunately with this degenerate case the query to build the form fails since there are over 7 million rows. I’m thinking something like “purge blocked servers” which would iterate over that. If not I may gin up something that reproduces that with a script on the side.