It's probably doing a check before it attempts the insert without holding a transaction open (and locking the table) for the insert itself. If there's a point in between when it has decided you are able to post, but before posting, then another thread/process is able to also do the same insert. 99% of the time this doesn't happen because the site is fast enough to do both the check and the insert before the next request can, but when the site hangs like that for whatever reason the race becomes almost guaranteed. I typically try to include that condition in the insert itself, which if the DBMS does automatic locking should be enough to prevent this I think (the data it is checking cannot have been updated by a different connection):

The (VALUES ()) AS X() thing is a way of defining a resultset to select from or join to with literal values inline so think of the whole thing as a temporary table sort of thing aliased as X within the query.

Append

I tried to post this an hour or more ago, but apparently it failed. I've never seen this before:

{"name":"611278","src":"\/\/djungxnpq2nug.cloudfront.net\/image\/cache\/7\/4\/74f60ea3e7289453418db1360bd9e4d8.png","w":805,"h":662,"tn":"\/\/djungxnpq2nug.cloudfront.net\/image\/cache\/7\/4\/74f60ea3e7289453418db1360bd9e4d8"}

It might give another hint about what's going on in the background. It seems there is supposed to be some kind of locking mechanism to serialize posts. Unless this was literally just added/activated it begs the question of how it goes wrong.

One often follows the other. For some the anxiety comes from feeling like there won't be a place to be alone. I'm the other way around. I didn't use to be introverted, I was just as happy being alone as with others, but after a while all the anxiety made me avoid people so much that I became introverted, and couldn't be happy unless I was alone. I usually feel more lonely if I'm with other people than if I'm alone as well.

In any case, if there is anxiety, it will be exhausting if it continues too long.

Katko,

I know you weren't accusing me of racism, but Neil did. He basically said what I believe was a fabrication made up to endorse racism when all I did was show him proof that Satan has children. For the sake of keeping the topics separate, I made another thread. I will reply to what he said there when I have time.

Okay, just making sure.

Enjoy your religious thread in the other one.

Anyone here play around with neural nets?

Every time you say that I lose a little more respect for you. The proper word to use is 'did' - I did that I did this I did something else. OR I have done this I have done that. But to mix the two is incorrect.

I programmed the game at the time to keep track of all moves and then whomever won, it would store the moves which lead to a win. When it played later, it would compare your moves with moves it had stored and then try and predict your next move, and then place it's mark at that location to block you. It of course, would also use the same idea to choose it's next move to win if there were no ways to block you.

I forget the algorithm used at the time, but it was fascinating. I think I had a book on artificial intelligence I was reading at the time.

Fascinating subject, I should putter around with it again sometime.

Wow, I actually had a reason to uncomment some member post hiding code in my custom CSS here.

How long ago did someone pissed me off enough to do that? Clearly, I was forward-thinking and just commented out the code at some point when I assume I didn't have to worry about it.

---

Also, I just thought about it today, with how little snow we had gotten over the past few winters, the snow removal company that plows our complex didn't put down the orange sticks to know where the pavement was for this winter... and I think we got more snow TODAY alone then we got the past two winters combined. And the news reported that the record for most snowfall in a winter was only the 2013-14 season... and so far, we're only halfway there.

Very nice! Have you checked out this guy's page? ALL of his games and projects he has are 100% Windows console text mode and they are amazing! He sets the font size so small they are practically pixels. If you like text stuff, you may just love this. And he makes all of his source available.

https://www.youtube.com/channel/UC-yuWVUplUJZvieEligKBkA

Oh please please please share that with me! I use the block feature A LOT on Facebook, but don't have the luxury of that here.

Like say, when people want to argue about everything you type? I don't like to do it either, but if someone mocks me or just wants to endlessly argue, I use it. You should see my block list on Facebook, it is massive as I just won't argue with people. I love civilized conversation and have had many with people who are atheists etc and they have been productive and respectful. But others who get angry and mocking, I just have no desire to communicate with them ever again.

Would be nice to know the CSS code to add people. I wouldn't add many, only one I can think off at the moment on here.

I don't know, but if you look at what he does, it's REALLY impressive and he gives away all his source code as well as a nice console game engine he developed. I may mess around with it sometime. His latest is a Mario clone, thought it was actual game graphics this time, but nope, a console. I done my own console "3D text" game, but nothing like what he did. He even has a Wolfenstien clone, in console, with sprites and colour! Kewl stuff.

"Peace", huh? Is that a hippie ROM hack of Double Dash? It's easy to identify the characters and most of the detail if you blur your eyes. Looks like Baby Mario and Donkey Kong in first, followed by Peach and Wario in second, and then Waluigi and Diddy Kong in third. Is the track Yoshi Circuit? I loved Double Dash as a kid.

As far as account-blocking CSS goes, maybe a better alternative would be to set a given user's text to transparent, rather than outright hiding it. That way you'd still know they posted, but you'd have to highlight their text to see any of it.

EDIT

That changes the text in bam's posts (for example) and all child styles to transparent. So you still see that he's posted, but you have to highlight his posts to actually see anything.

{"name":"611282","src":"\/\/djungxnpq2nug.cloudfront.net\/image\/cache\/8\/5\/85afaa5c55f70a85bd73d39e671d4da6.png","w":1600,"h":900,"tn":"\/\/djungxnpq2nug.cloudfront.net\/image\/cache\/8\/5\/85afaa5c55f70a85bd73d39e671d4da6"}

That's just childish. Enjoy your ignorance while it lasts.

It's amazing how childish the "adults" are being on this forum right now. There's like FIVE ACTIVE POSTERS on this forum right now. Grow up and accept people say and think things you don't.

I don't agree with ANYONE here fully, at all. And? Nobody cares. Life goes on. I'm still able to converse objectively.