If you are, or have ever been, a sysadmin, grab a bag of popcorn and cruise through this one. Thrills and chills! https://thomasp.vivaldi.net/2023/07/28/what-happened-to-vivaldi-social/
What happened to Vivaldi Social? | Thomas Pike’s other blog

A deep dive into the events of Saturday 8 July 2023, when user accounts started disappearing from the Vivaldi Social Mastodon instance.

Thomas Pike’s other blog

@timbray Neatly described.

My only beef is the passage “all local accounts in a Mastodon instance have a null value in their URI field, so they all matched”. But null ≠ null, AccountMergingWorker isn’t matching correctly.

@denspier It's Ruby, no? In Ruby nil == nil.
@timbray I understood it was in PostgreSQL? Regardless, if null is the default value, and all local accounts have null, null and null cannot be regarded as a match, regardless of language.