Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-06-19 : 05:52:57
|
| I have built an online fantasy football type game, and recently errors have been occurring that are causing teams to become corrupt. I have had no sucess yet in recreating the error and it is something which is intermittently hitting teams within the system. There are a number of db tables sitting on sqlserver7, most of the code uses dynamic sql, and yes I know that this is not the best way of dealing with things-I have seen the light of stored procedures. SYMPTOMS:When a competitor removes a player from their team individual rows in the player table are updated and then their record in the team table is updated. These are two execute commands one immediately after another, the first update is working, but the second isn't, teams are then corrupted with incorrect team values.The code has been bug free for a long time but it is almost as if as as our user base has increased - 8000+ users then the bug has been surfacing. It does not seem to be occurring at a any particular time either which makes it even harder to trace. It seems totally random and in one case it has affected the same user twice.Could this be ROWLOCKING and certain users are becoming the losers and getting locked out of updates, my error trapping on the system is virtually non-existent, bad I know, I am learning a lot at the moment.I really want some advice on this because it is a real problem. If you want to check the site have a look @ http://www.celebstatus.com, however unless you login create a new player and team you will not get to the area of the site that is giving the problems. Thanks in advance. |
|
|
|
|
|
Unknown Update Error in application - need advice