|
Glorgnole posted:lol that it's possible to erase an entire user and all their posts, and that doing this extremely breaks threads they posted in i mean, `delete from comments where user_id=69` and it also makes sense that decade-old forum software on mysql with a bunch of denormalization into memcache tacked on would have issues
|
# ? Oct 5, 2017 14:01 |
|
|
# ? May 9, 2024 22:43 |
|
Glorgnole posted:lol that it's possible to erase an entire user and all their posts, and that doing this extremely breaks threads they posted in oh you can't say that without posting an example e: oh i see zdr is a little less r and a little more d than usual these days flakeloaf fucked around with this message at 15:01 on Oct 5, 2017 |
# ? Oct 5, 2017 14:11 |
|
Glorgnole posted:lol that it's possible to erase an entire user and all their posts, and that doing this extremely breaks threads they posted in 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
|
# ? Oct 5, 2017 14:41 |
|
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) 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
|
# ? Oct 5, 2017 15:19 |
|
|
# ? Oct 5, 2017 23:52 |
|
NICE!
|
# ? Oct 6, 2017 01:35 |
|
forum dramas? during fontgate?
|
# ? Oct 6, 2017 06:36 |
|
so are there any plans to fix these dead failed sad old irrelevant forums or whats GOING ON
|
# ? Oct 6, 2017 12:44 |
|
now's not the time to talk about fixing these dead forums
|
# ? Oct 6, 2017 13:07 |
|
zdr def quit bc of lowtax. idk why he was doing all that work on the servers for free. or maybe... maybe it was bc of the 1px font change ! 😠! 😱!
|
# ? Oct 6, 2017 13:10 |
|
what happened to zdr, and did he take the forums down with him or what
|
# ? Oct 6, 2017 13:51 |
|
death comes soon
|
# ? Oct 6, 2017 15:08 |
|
Now I'm getting this Schadenboner fucked around with this message at 15:42 on Oct 6, 2017 |
# ? Oct 6, 2017 15:35 |
|
Schadenboner posted:url=https://ibb.co/cjrFi thanks imagetrumpet
|
# ? Oct 6, 2017 15:38 |
|
Schadenboner posted:Now I'm getting this whenever I try to page forward (to an unread page maybe? doesn't happen on already read pages) on a thread. getting that but only on the microsoft thread probably for the best
|
# ? Oct 6, 2017 15:42 |
|
Just-In-Timeberlake posted:getting that but only on the microsoft thread But what if I really really wanted to see what cinci zoo sniper said?
|
# ? Oct 6, 2017 15:51 |
|
https://forums.somethingawful.com/showthread.php?goto=post&postid=477053874#post477053874 I'm clicking the twitter button and nothing useful is happening!
|
# ? Oct 6, 2017 21:24 |
|
it looks really bad
|
# ? Oct 7, 2017 01:45 |
|
did the emoji kill zdr?
|
# ? Oct 7, 2017 01:51 |
|
either that or
|
# ? Oct 7, 2017 02:39 |
|
site rapidly collapsing like a lovely jalopy shaking apart at 40mph
|
# ? Oct 7, 2017 03:00 |
|
i actually went through every bit of that stupid thread in gbs. there are a few funny photoshops but holy poo poo the first third to half of it is nigh unreadable. there was a lot of whining at lowtax and he started banning a bunch of people including bbg which caused more people to jump in and carepost resulting in bans. after most of the concern trolls from imp zone were banned lowtax made a joke about cleaning house and zdr made a joke back that he should take him out too. i personally read it as sarcasm as a bunch of his posting pals had been banned for being dinks. around this time someone at steadfast hit the emergency off which killed everything in one of their dcs. something happened at the time that corrupted zdr's post history, but he wasn't banned and didn't quit. he even came to the thread, said he wanted no part in any drama and is still working on fixing poo poo in the database that got hosed up by the power being pulled from every server. there are a few really funny photoshops/gifs in there, though like: and this guy made a few good ones: https://forums.somethingawful.com/showthread.php?threadid=3836478&userid=25825
|
# ? Oct 7, 2017 03:07 |
|
Schadenboner posted:Now I'm getting this Getting this too, and interestingly if I go to that thread and then hit reply, the unread posts don't appear below the post form either. It's like they don't exist at all. But I can see the unread posts number going up. ghost posts
|
# ? Oct 7, 2017 15:55 |
|
another forum i used to visit a similar thing would happen. the number of posts in a thread was stored somewhere, i guess for optimisation. weird stuff happens and the pre calculated value gets out of sync, now the thread pagination is messed up.
|
# ? Oct 7, 2017 17:03 |
|
stinch posted:another forum i used to visit a similar thing would happen. the number of posts in a thread was stored somewhere, i guess for optimisation. weird stuff happens and the pre calculated value gets out of sync, now the thread pagination is messed up. yeah it usually gets denormalized on to the thread model so you can show the post count and page links in the forum index without a bunch of extra disk seeks
|
# ? Oct 7, 2017 17:15 |
|
stinch posted:the number of posts in a thread was stored somewhere, i guess for optimisation. genuinely curious how this optimizes anything
|
# ? Oct 7, 2017 17:23 |
|
Roosevelt posted:genuinely curious how this optimizes anything you have to seek to (an index on) the posts table (which is the biggest and busiest table) to count the posts in a thread you seek to 40 rows in the threads table to load the thread index in a forum if you want to load counts for those that's another 40 hits on a posts index forumdisplay.php gets hit more than newreply.php (under non-fucky operation) the count only changes when newreply.php is hit therefore you can save a lot of index hits by storing the post count on the threads table and only updating it when necessary
|
# ? Oct 7, 2017 17:40 |
|
if it was on a good database and not mysql you'd have a matview for the thread index that calculates and updates post counts without a lock whenever the posts table is inserted, updated, or deleted
|
# ? Oct 7, 2017 17:41 |
|
This forum has load bearing users that can't be deleted or the whole thing comes down.
|
# ? Oct 7, 2017 17:46 |
|
when the forums rebuild is finished all these problems will vanish
|
# ? Oct 7, 2017 17:51 |
|
i guess that's why sometimes you get a stuck post huh. the post count gets desynched from the post db?
|
# ? Oct 7, 2017 17:52 |
|
Roosevelt posted:when the forums rebuild is finished all these problems will vanish or all the users will go away, which I guess solves that problem too.
|
# ? Oct 7, 2017 18:05 |
|
Sagebrush posted:i guess that's why sometimes you get a stuck post huh. the post count gets desynched from the post db? probably, the forums are php and mysql, which are like the opposite of data integrity, and that's without the extra caching layers that represent more places to have inconsistencies
|
# ? Oct 7, 2017 18:21 |
|
what in tarnation
|
# ? Oct 7, 2017 20:03 |
|
Progressive JPEG posted:
pre:div.pages select { min-width: 50px!important; /* height: 26px; */ /* vertical-align: bottom; */ }
|
# ? Oct 7, 2017 20:10 |
|
I'm a very !important person.
|
# ? Oct 8, 2017 01:39 |
|
Roosevelt posted:when the forums rebuild is finished all these problems will vanish Source you're quotes.
|
# ? Oct 9, 2017 16:14 |
|
there's not going to be a forums rebuild
|
# ? Oct 9, 2017 16:41 |
|
lol. xenforo 2 is still beta. really it was the ideal choice, lowtax ensured he'd never actually have to migrate the forums
|
# ? Oct 9, 2017 18:00 |
|
|
# ? May 9, 2024 22:43 |
|
this poo poo needs fixin'
|
# ? Oct 9, 2017 18:29 |