View Complete Post
I've recently started getting two deadlock errors:
deadlocked on lock | communication buffer resources
Transaction was deadlocked on lock resources with another process
There haven't been any recent changes to the system that offer a readily apparent explanation regarding why my users have started getting these errors in their browsers. I got a DBA to capture some data in Profiler and I'm posting the XML from one of the
deadlocks at the bottom of this.
The description of the scenario is that there is a ASP.NET 1.1 web app and a VC++7 Windows service both running against a SQL Server 2005 clustered database. The deadlocks are happening between a simple select statement that doesn't use any joins and a simple
update statement that is updating the same table. Neither process is using explicit SQL transactions (i.e. there is no explicit Begin Transaction) nor are they using any kind of hints (like NOLOCK or READUNCOMMITTED). But, I can't see why they should need
I have captured staticts on the DB per another thread on this subject and the results were:
wait_type wait_time_s pct running_pct
------------------------------------------------------------ --------------------------------------- --------------------------------------- ---------------------------------------
We migrated data from one environment to other using import and export option. After importing we are getting deadlocked on lock resources with another process
error. This error comes while adding entries in Calendar list. 2 or 3 entries get added successfully but for next entry we get this error. Can anybody please suggest about this? The error is specific to only
one calendar list. We again migrated same data to some other environment and there it is working fine.
Below is complete stacktrace
Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen
as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
I have a deadlock problem that occurs every 5 minutes on SQL update. I get the following error randomly - means qurey failed one time every 200 calls. I'm using transaction scope to manage transaction.
using(TransactionScope scope = new TransactionScope())
SELECT ... FROM TABLE1
UPDATE TABLE1 SET [F1] = @F1, [F2] = @F2, [F3] = @F3, [F4] = @F4, [F5] = @F5 WHERE UId = @UId
System.Data.SqlClient.SqlException: Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
I am getting this error continously please help me out
Transaction (Process ID 106) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
I'm looking for a website, or book, or some resource that can lead me down the path from website design to implementation/deployment. I know that covers a ton of material, but I am really looking for the bullet points, or high-lights, to make sure that I think of everything. I am mostly fuzzy on security measures and deployment since I haven't been involved in those aspects before.
Background: I have been a programmer for many years, and with a little over 3 years' experience coding websites in vb.net/asp.net with sql server. Due to recent restructuring/layoffs at our firm, I find myself in the position of lead IT person - I'm feeling a bit underqualified but I feel this is my chance to work hard and step up to it. I'm very good at vb.net, master pages, css, asp.net, sql server. I'm worried that the person who was the lead before was doing a bunch of stuff that I'm not aware of...so I need to start learning more than just the code. I don't need lessons on how to code anything...I need to learn how it all gets put together - the next step up.
thanks for any suggestions!
I am working on a project which involves send messages through GPRS modem to a specified server port(having static IP).
I need .net code to send data through GPRS modem to server's specified port. If anyone having experience in this area please guide me.
VPL, part of Robotics Developer Studio is intended for novice programmers, but is also useful for testing and prototyping. We write a simple serial port service that allows you to send and receive data.
MSDN Magazine February 2010
This month's column describes how to use WCF for communication between a workflow and a host application in Windows Workflow Foundation 3. This knowledge should help developers with their efforts using WF3 and prepare them for WF4, where WCF is the only abstraction over queues (referred to as "bookmarks" in WF4) that ships with the framework.
MSDN Magazine November 2009
Schema- first contract-first modeling of Web Services gives you the ability to model your contracts with an XML-centric mindset. This process keeps you focused on universally acceptable types and the hierarchical data structures that can be represented in XML.
Christian Weyer, Buddhike de Silva
MSDN Magazine October 2009
MSDN Magazine November 2006