@bclindner okay so, all the queries I killed were identical, a complex SELECT (I took a screenshot). So far there’s one that’s come back. I’m going to set a two-minute timeout on our Postgres install to prevent this from happening again. Two minutes is still very generous, and longer than our nginx timeout, so the API should be unaffected. Let me know if you (or, indeed, if any curious watchers) have questions!
@ashfurrow Got to love the Mastodon goes brrrrr moments.
@skelly @bclindner I have no idea! I mean, I saw the old username in the logs. When a post is deleted, we also send deletion requests to every server we federate with, and those sometimes fail and get retried with exponential back off.
To be abundantly clear: there’s nothing wrong with your script or with you running it. The database should be able to handle this, but it isn’t. I think I know why but I’m not looking forward to fixing it...
This Mastodon instance is for people interested in technology. Discussions aren't limited to technology, because tech folks shouldn't be limited to technology either!