Server Error in '/' Application.

Transaction (Process ID 85) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Transaction (Process ID 85) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:


Line 338:		Dim db As New SqlConnection(ConfigurationManager.AppSettings("connString"))
Line 339:		Dim cmd As New SqlCommand(strSql, db)
Line 340:		db.Open() : cmd.ExecuteNonQuery() : db.Close()
Line 341:	End Sub
Line 342:

Source File: C:\inetpub\wwwroot\merritts.com\App_Code\AddisonTech.vb    Line: 340

Stack Trace:


[SqlException (0x80131904): Transaction (Process ID 85) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2585906
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039670
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +997
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +314
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +297
   AddisonTech.UpdateData(String strSql, Boolean ShowDebugText) in C:\inetpub\wwwroot\merritts.com\App_Code\AddisonTech.vb:340
   AddisonTech.CreateRecordGetKey(String DatabaseTableName, String PrimaryKeyName, String SessionIDPlaceholderField, String SessionID) in C:\inetpub\wwwroot\merritts.com\App_Code\AddisonTech.vb:360
   AddisonTech.GetVisitorID() in C:\inetpub\wwwroot\merritts.com\App_Code\AddisonTech.vb:33
   AddisonTech.GetOpenOrderID() in C:\inetpub\wwwroot\merritts.com\App_Code\AddisonTech.vb:18
   ASP.merritts_includes_public_master.Page_preRender(Object Sender, EventArgs e) in C:\inetpub\wwwroot\merritts.com\merritts\includes\Public.master:9
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnPreRender(EventArgs e) +9883650
   System.Web.UI.Control.PreRenderRecursiveInternal() +90
   System.Web.UI.Control.PreRenderRecursiveInternal() +163
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +906


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4676.0