Lemmy Support

cross-posted from: https://lemmy.ml/post/1637526

@[email protected] PING!

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),

Example log message:

{
    "cc": ["https://lemmygrad.ml/", "https://lemmy.ml/", "https://midwest.social/", "https://lm.korako.me/", "https://tabinezumi.net/", "https://lemmy.shrieker.net/", "https://bar.southfox.me/", "https://sopuli.xyz/", "https://slrpnk.net/", "https://feddit.de/", "https://lemmy.perthchat.org/", "https://baraza.africa/", "https://mander.xyz/", "https://lemmy.eus/", "https://lemmy.ca/", "https://lemmy.fediverse.jp/", "https://fapsi.be/", "https://exploding-heads.com/", "https://baomi.tv/", "https://fediverse.ro/", "https://lemmy.pt/", "https://szmer.info/", "https://feddit.it/", "https://jeremmy.ml/", "https://group.lt/", "https://beehaw.org/", "https://lemmy.rimkus.it/", "https://lemmy.tedomum.net/", "https://lemmy.coupou.fr/", "https://lemmy.blahaj.zone/", "https://community.xmpp.net/", "https://lemmy.simple-gear.com/", "https://lem.simple-gear.com/", "https://lm.gsk.moe/", "https://latte.isnot.coffee/", "https://lemmy.sdf.org/", "https://lemm.ee/", "https://sh.itjust.works/", "https://lemmy.fmhy.ml/", "https://yiffit.net/", "https://lemmy.world/", "https://lemmyfly.org/", "https://vlemmy.net/", "https://lemmynsfw.com/", "https://programming.dev/", "https://terefere.eu/", "https://discuss.tchncs.de/", "https://infosec.pub/", "https://lem.elbullazul.com/", "https://feddit.jp/", "https://lemmit.online/", "https://aussie.zone/", "https://social.fossware.space/", "https://social.sour.is/", "https://lemmy.management/", "https://lemmy.one/"],
    "id": "https://lemmy.juggler.jp/activities/block/51bd6d83-3780-45c6-b29a-1b3a9a0bb401",
    "to": ["https://www.w3.org/ns/activitystreams#Public"],
    "type": "Block",
    "actor": "https://lemmy.juggler.jp/u/tateisu",
    "object": "https://lemmy.juggler.jp/u/samydes225879",
    "target": "https://lemmy.juggler.jp/",
    "summary": "spam accounts created?",
    "@context": ["https://www.w3.org/ns/activitystreams", "https://w3id.org/security/v1", {
        "pt": "https://joinpeertube.org/ns#",
        "sc": "http://schema.org/",
        "lemmy": "https://join-lemmy.org/ns#",
        "expires": "as:endTime",
        "litepub": "http://litepub.social/ns#",
        "language": "sc:inLanguage",
        "stickied": "lemmy:stickied",
        "sensitive": "as:sensitive",
        "identifier": "sc:identifier",
        "moderators": {
            "@id": "lemmy:moderators",
            "@type": "@id"
        },
        "removeData": "lemmy:removeData",
        "ChatMessage": "litepub:ChatMessage",
        "matrixUserId": "lemmy:matrixUserId",
        "distinguished": "lemmy:distinguished",
        "commentsEnabled": "pt:commentsEnabled",
        "postingRestrictedToMods": "lemmy:postingRestrictedToMods"
    }],
    "removeData": true
}