Transaction (Process ID 611) was deadlocked on lock

admin
January 7, 2021
Latest Update: January 7, 2021 11:15 am
2
1 minute read
0

Spread the love

Transaction (Process ID 611) 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 611) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:




Line 221:        If OPENCN(JMD) Then
Line 222:            SQLCM = New SqlCommand("UPDATE OXARTICLE SET HITS=HITS+1 WHERE ARTICLECODE=" & NEWSCODE.ToString, JMD)
Line 223:            SQLCM.ExecuteNonQuery()
Line 224:            CLOSECN(JMD)
Line 225:        End If

Source File: G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb Line: 223

Stack Trace:




[SqlException (0x80131904): Transaction (Process ID 611) 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) +1968826
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907355
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   _default.COUNTHITS() in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:223
   _default.GETDATA() in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:198
   _default.Page_Load(Object sender, EventArgs e) in G:PleskVhostspunjabtribune.comhttpdocsnewsmainpage.aspx.vb:41
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.8813; ASP.NET Version:2.0.50727.8951

Share on Facebook