Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
Glorgnole
Oct 23, 2012

lol that it's possible to erase an entire user and all their posts, and that doing this extremely breaks threads they posted in

Adbot
ADBOT LOVES YOU

Glorgnole
Oct 23, 2012

Cybernetic Vermin posted:

i'd guess zdr's user record got corrupted into non-existence in the outage, making his posts fall out of some (thread[page]) join comments join users query. the way the threads were broken seems like it'd either be a matter of pagination being cached (and that cache being rebuilt async?), or possibly simply an expectation that the join would never project comments away (which could be entirely legitimate if the corruption caused a foreign key constraint to be violated)

lowtax denies doing anything to zdr, and it seemed a pretty out there forum drama thing to have happen, so the outage loving up the db seems a better guess

i don't have a good grasp on the technical side of things but yeah it's too weird and funny to have been done intentionally

there was about an hour between when the posts first disappeared and when the database updated or whatever where the pagecount in threads that had many pages of zdr posts (trump thread, qcs tech thread) was all screwed up, which left the last however many pages in a weird limbo state where people could still post to them but they'd throw an error if you tried to browse to them

Glorgnole
Oct 23, 2012

  • Locked thread