Hello everyone! Recently I have removed a couple of bot users from my Lemmy instance via DB query (I removed them from person table). Those bots were subscribing to hundreds of communities on other instances which I don’t really want to spend resources on fetching new posts and updates.

I have purged those communities from my instance but they keep reappearing. As far as I can tell, this happens because other instances still “think” that users from my instance (bots, which don’t exist already) are still subscribed, and therefore send updates to my instance.

How can I completely get rid of those communities?

  • RoundSparrow@lemmy.ml
    3·
    1 year ago

    I am actively working on testing code to try and reproduce what happens in these situations when a remote server does not unsubscribe from communities. Doing a direct SQL delete of rows from the persons table is perhaps out of scope, but there is a lot of cleanup. There was an explosion of instances (new servers) out there and many have since gone offline. So I am sure the the topic of how to clean up old orphan data will keep coming up.

      • RoundSparrow@lemmy.ml
        2·
        1 year ago

        A lot going on right now regarding federation consistency between servers, so not sure, it’s scattered on a variety of topics. You are welcome to comment reply to me every few days if you are curious.