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








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




Line 229: Dim RN As New Random
Line 230: SQLCM = New SqlCommand(“UPDATE OXARTICLE SET HITS=HITS+” & RN.Next(1, 5).ToString() & ” WHERE ARTICLECODE=” & NEWSCODE, CN2)
Line 231: SQLCM.ExecuteNonQuery()
Line 232: SQLCM.Dispose()
Line 233: DR.Close()







Source File: G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb    Line: 231
Stack Trace:




[SqlException (0x80131904): Transaction (Process ID 1237) 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) +2586154
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039974
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
article_details.GETHITS() in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:231
article_details.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:25
System.Web.UI.Control.OnLoad(EventArgs e) +97
System.Web.UI.Control.LoadRecursive() +61
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693










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