Post New Web Links

deadlocked on lock | communication buffer resources

Posted By: Posted Date: September 23, 2010 Points: 0 Category :Sql Server

I've recently started getting two deadlock errors:

and

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 to.

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

------------------------------------------------------------ --------------------------------------- --------------------------------------- ---------------------------------------

SQLTRACE_BUFFER_FLUSH 1199

View Complete Post

More Related Resource Links

"was deadlocked on lock resources with another process and has been chosen as the deadlock victim"

Sharepoint 2007:

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 runBehavior,

Deadlock: System.Data.SqlClient.SqlException: Transaction (Process ID 51) was deadlocked on lock res

Hello,

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.

code:

using(TransactionScope scope = new TransactionScope())

{

SELECT ... FROM TABLE1

UPDATE TABLE1 SET [F1] = @F1, [F2] = @F2, [F3] = @F3, [F4] = @F4, [F5] = @F5 WHERE UId = @UId

scope.Complete();

}

error:

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

stack tr

Transaction (Process Id 106) was deadlocked on lock

Dear All,

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)
   at System.Data.SqlClient.SqlCommand.InternalEx

WCF Tutorial - Basic Interprocess Communication

What the heck is WCF? For a long time, I couldn't tell you exactly what it was. And honestly, I still don't think I can. WCF is such a broad concept that it's hard to boil down into a concise explanation. When I finally started reading about it, and getting beyond the concepts, things started to clear up. That's what today's tutorial is about - cutting through all the concepts and just use WCF to build a basic server and a basic client.

Getting Started with Windows Communication Foundation

Windows Communication Foundation (WCF) provides a unified framework for rapidly building service-oriented applications that makes it easy to build and consume secure, reliable, and transacted Web services. It unifies the capabilities in ASMX, WSE, Remoting, COM+, and MSMQ; therefore developers need to learn only one programming model.

How to detect and avoid memory and resources leaks in .NET application

Despite what a lot of people believe, it's easy to introduce memory and resources leaks in .NET applications. The Garbage Collector, or GC for close friends, is not a magician who would completely relieve you from taking care of your memory and resources consumption.

I'll explain in this article why memory leaks exist in .NET and how to avoid them. Don't worry, I won't focus here on the inner workings of the garbage collector and other advanced characteristics of memory and resources management in .NET.

SharePoint 2010 - Top 10 Resources to get you started

This post contains links to download evaluation software, guides, demo virtual machines and lots more, for both Developers and IT Professionals.SharePoint 2010 - Top 10 Resources to get you started

Serial Communication with the .NET Compact Framework

Learn how to make your applications communicate over a serial port and how to handle common issues when implementing serial solutions. After a general discussion about serial communication and a common serial communication standard, this article demonstrates a practical use of the technologies through sample source code written in C#.

Serial Port Communication Read and Write using C#.net

In this simple article you will learn that how you can Open and read COM port data using System.IO.Ports Namespace.
Simply just create New Project of windows application in C#.

Import ServiceProcess APIs
C#:
---
using System.IO.Ports

VB
Imports System.IO.Ports

Write Parsing functions which parse port data according to attached device

Resources for soup-to-nuts of website development lifecycle

Hello,
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!

Event ID 1011 - DefaultAppPool World Wid Web Pub. Serv. fatal communication error

We have a Windows 2003 server running IIS6 1.1 Framework. We have also installed a DNS and Active Directory in the same machine.

We're randomly getting the error you can see below. Sometimes it causes the recycling of process w3wp.exe (which on my understanding represents the application pool worker processd) and other times results on this process hanging and not responding to any request. To do iisrest temporarly solves the problem.

We were pointed to a possible permissions problem between the user we were runnig the DefaultAppPool with and registry entries used by the iis. We noticed the default predifined user we used, Network Service, wasn't found in the Active Directory, so we changed it by the default configurable user, IWAM_MACHINE_NAME, which is under the IIS_WPG Active Directory Grupo, which, in theory has the correct permissions to run the application pool.

Well, none of this worked and we are still getting this error.

This is driving us crazy and think the problem might have to do with having the Domain Controller/Active Directory and the IIS6 running on the same machine. We'll try now uninstalling this DC pointing to another one to see what happens.

Any help would be appreciated.

Thanks in advance,

Gabriel.

Event Type: Warning
Ev

GPRS Communication using GSM Mobile

Dear all,

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.

Thanks,

Shanmugam

Robotics: Writing and Testing VPL Services for Serial Communication

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.
Trevor Taylor
MSDN Magazine February 2010

Foundations: Workflow Services for Local Communication

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.
Matthew Milner
MSDN Magazine November 2009

Contract-First Web Services: Schema-based Development with Windows Communication Foundation

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

Concurrent Affairs: The ReaderWriterGate Lock

Jeffrey Richter
MSDN Magazine November 2006

Peer To Peer: Harness The Power Of P2P Communication In Windows Vista And WCF

P2P applications face a number of barriers preventing their wide adoption as a productivity solution. Fortunately Windows Vista improves the situation, as you'll learn here.
Justin Smith
MSDN Magazine October 2006


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All