I just had to delete over 44.000 Users, Bans and Activity messages from my database and defederate from lemmy.juggler.jp. Somehow, all their bans get propagated to the rest of the lemmyverse.
I did a quick check, and it seems like not all instances liked are affected, but some definitely are. aussie.zone, for starters (PING! @[email protected] )
The good news is that, due to the relational database, you only need to delete the users, and the database cascade does the rest. BEFORE YOU DO ANYTHING, MAKE A BACKUP OF YOUR DATABASE I am not responsible for messing up your database. Don't ever execute commands given by a stranger on the internet if you don't understand them.
Also, unless you defederate from them, the logspam will just continue. So maybe do that first.
To fix it, get database access somehow, and check your instance table. There, search for the id for lemmy.juggler.jp with the following query:
SELECT id FROM instance WHERE domain = 'lemmy.juggler.jp';
Write down that id, and execute the following query:
DELETE FROM person WHERE instance_id=<the id you just wrote down>;
This will probably take a while (over 2 minutes on my database),
I just had to delete over 44.000 Users, Bans and Activity messages from my database and defederate from lemmy.juggler.jp.
Why did you have to delete and defederate? Were these bans causing some acute issue on your instance? 50k rows in a database table doesn't necessarily sound like a problem.
It also seems slightly odd on principle to defederate with someone who is cleaning up a bot/spam problem. I totally get having concerns while 50k bots are signing up unchecked, and if there's a way to do this cleanup that reduces performance problems for other admins I'd get publishing that procedure. But I don't entirely follow a public call to defederate an instance that's actively addressing it's bot problem.
Somehow, all their bans get propagated to the rest of the lemmyverse.
This is normal and expected. That db table should have bans from other instances as well, just not that many instances have reason to do 10s of thousands of them at once.