Can’t post images because they’re too big so here’s imgur: https://imgur.com/a/Fm52ZTB
Edit: lemmy.ml and lemmy.world seem to have come back, I’m just a bit worried that it’s another one of those hacks.
Edit 2: Most of those I’ve tried came back. reddthat.com and sh.itjust.works seems to still be down
The original issue is just a symptom of all database threads being tied up. People just don’t know how to follow an error message to the root cause.
The real source of the issue is db locking from triggers and cascading deletes on a major user change.
My report in https://github.com/LemmyNet/lemmy/issues/3649 has the offending query.