Race Condition - Resolved Through ADO.Net SQL Transaction

In our site there is a Shared (aka static) class that clears and then modifies a commonly used Table in a SQL Server Database.  The issue was that we would occasionally throughout the day get errors saying that "such and such record" could not inserted because it already exists.  We put in logging in between the statements to try and debug the thing since we could not seem to duplicate the error locally.  We noticed that in one example a single user had somehow two processes that were in lock-step through the function.  Both would clear the table, then both would attempt to insert the same data to it.  When the second process would attempt to insert it would blow up.

Basically the resource is shared and needs to be locked so it is not modified by multiple users at the same time. http://stackoverflow.com/questions/34510/what-is-a-race-condition

This article was very useful in creating the transaction that resolved my issue.  Ideally I would have preferred to have used a transaction in sql, but we clear it then do a bulk insert.
http://www.codeproject.com/Articles/522039/A-Beginners-Tutorial-for-Understanding-Transaction

Comments

Post a Comment

Popular posts from this blog

Asp.net Publishing Broke Site - "App_WebReferences is not allowed because the application is precompiled"

When publishing site to live, trying to go to site gives a Server Error – Runtime Error.  Looking in the Application logs on the server  gave " The directory App_WebReferences/ is not allowed because the application is precompiled."   This was causing a bit of stress to a programmer in a our company since he tried to publish a change during business ours.   Solution http://stackoverflow.com/questions/9892646/how-publish-my-web-site When publishing the options that work are to have “Delete all existing files prior to publish”, and “Precompile during publishing” checked.  And “Exclude files from the App_Data” unchecked.
Read more

Telerik - Custom Group Footers In RadGrid

As anyone that has dealt with this knows Telerik only supports a single Group or Header Template.  So what happens when you want to change them?  You really only have two options from what I have seen.  The first option is to have something in the data that is brought back that you can use in the designer code in the form of a conditional.  Too bad I do not see a way to check the data based on level like some sort of ParentID like some people have done.  If the ParentID is null  It would look something like below where you check it in the designer: < asp : Label runat = "server" ID = "Label2" Text = '<%# "Number of items in group: "+ (((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) %>' Visible = '<%# ((((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) != null)%>' > Or you can use the code behind to really get at the groupIDs like this per
Read more