User Pass
Home Sign Up Contact Log In
Page:
 
Bort
Admin
offline
Link
 
Originally posted by RandomBeast
do the database queries use transactions and row locking?

could it be like this:

boost page reads SP value: 5
spend page reads SP value: 5
boost page adds 5 to stored value and writes value: 10
spend page subtracts 5 from stored value and writes new value: 0

So if running simultaneously (probably with some lag involved) it could process a boost and still show up without the 5 points?


Yes, InnoDB.

That scenario could be what happened. The function for "level up" does a query that says "update ... set sp = sp + 5" but the spend page might set it explicitly instead...race condition (I don't remember haha). If so I just need to make it tell mysql to do the math instead of setting the number explicitly.

And...I just looked it up and that is the case and most probable scenario.

tahl, I'll reset your guy's boost number to 2 so you can re-boost him one more time (and do a FP refund). He wouldn't have gotten his level up fractional points either. I'll see what I can do to fix the problem, but in the future, don't do that!
 
Faux Bear
offline
Link
 
Originally posted by Bort
in the future, don't do that!


can the problem in this thread be synthesized so that something like this doesn't happen to anyone else? in other words, what should we make sure not to do?

 
Bort
Admin
offline
Link
 
Originally posted by Faux Bear
Originally posted by Bort

in the future, don't do that!


can the problem in this thread be synthesized so that something like this doesn't happen to anyone else? in other words, what should we make sure not to do?



Don't update your skill points and do a boost at the same time. I'll fix the problem shortly, though.
 
RTS
offline
Link
 
Make sure you don't process skill points on one screen and purchase them on another.

And you got it. I won't do it again. I boosted 3 other players after him and did it all from 1 screen.

Thanks very much for taking the time to look into this Bort I appreciate the validation from all the neigh sayers.

Now don't most of you feel bad for coming down on me so hard!!
 
RTS
offline
Link
 
Bort, looks like my player profile page shows level 14, and Flex Point page shows level 14, but my home page screen still shows level 15. Should I wait for it to reflect level 14 also? Or is it just a cosmetic thing?
 
Vilita
offline
Link
 
Originally posted by tahl
Bort, looks like my player profile page shows level 14, and Flex Point page shows level 14, but my home page screen still shows level 15. Should I wait for it to reflect level 14 also? Or is it just a cosmetic thing?


Memcache?
 
RTS
offline
Link
 
OK all set it just bumped. Thanks again.
 
randomguymike
offline
Link
 
Originally posted by oldskool
I still say you shouldn't openly question him, but if he was proven to be completely unhelpful in a situation where there was a legit bug....wow.


Still waiting for the 'I'm sorry I was an ass and you were right' post from Oldskool to OP.

Also, I have to agree with what was stated earlier in this thread. No programmer should ever answer 'it's not possible' that there's a bug and just dismiss a UAT tester like this. It is ALWAYS possible, and in fact likely there's a bug even in the best code.

That being said, as usual Bort steps in, Bort solves issue.
 
Unconquered
offline
Link
 
People like oldskool piss me off.
 
RandomBeast
offline
Link
 
I'm a programmer, so I know there are often ways things happen that aren't immediately obvious. And the timing/race bugs like that are some of the hardest to detect because each piece of code works by itself in isolation and almost always works well together.

Glad to see Bort has it figured out.

Regarding oldskool. lol. Always seems to be in these threads acting as the resident "expert". Not sure how helpful or accurate he has been. Probably stayed at a Holiday Inn Express last night.
 
oldskool
offline
Link
 
Originally posted by RandomBeast
Probably stayed at a Holiday Inn Express last night.

I'm not made of money!

Shame on Thorn for being lazy about it, shame on Bort for sloppy code that left open a loophole like that, and shame on me for playing 99.9% as 100%. I was wrong.
 
spartans72
offline
Link
 
Originally posted by tahl
OK all set it just bumped. Thanks again.


I also humbly apologize.

Someone should have taken me up on my bet...
 
They He
offline
Link
 
It happened to my player Darris Ford at the start of this season. I boosted him at about 2:05 am after the servers had finished updating. I put all 15 into stamina. The points were gone a few hours later. I emailwed support and was told everything was normal when I believe it was not. I posted my experience on several forums of the teams I play for. I will always be trying to make up for those lost 15 skill points.
 
tjsexkitten82
offline
Link
 
Originally posted by They He
It happened to my player Darris Ford at the start of this season. I boosted him at about 2:05 am after the servers had finished updating. I put all 15 into stamina. The points were gone a few hours later. I emailwed support and was told everything was normal when I believe it was not. I posted my experience on several forums of the teams I play for. I will always be trying to make up for those lost 15 skill points.


That would be a totally different issue than what this guy experienced.
 
Joe_B
offline
Link
 
Originally posted by randomguymike
Originally posted by oldskool

I still say you shouldn't openly question him, but if he was proven to be completely unhelpful in a situation where there was a legit bug....wow.


Still waiting for the 'I'm sorry I was an ass and you were right' post from Oldskool to OP.

Also, I have to agree with what was stated earlier in this thread. No programmer should ever answer 'it's not possible' that there's a bug and just dismiss a UAT tester like this. It is ALWAYS possible, and in fact likely there's a bug even in the best code.

That being said, as usual Bort steps in, Bort solves issue.



Reminds me of a joke i heard once about an Engineer who was told about a piece of malfunctioning equipment. The engeneer said "that's impossible it can't do that!". So he went out to look at the piece of malfunctioning equipment and said "what the hell is it doing? It CAN'T do that".
He start getting wiring diagrams and schematics out reading and pointing, all the while saying "see it can't do THAT!"
Then he gets an old technician to come out. The technician looks at the piece of malfunctioning equipment and says "damn, i've never seen one do that before"
 
Page:
 


You are not logged in. Please log in if you want to post a reply.