Server Error in '/' Application.

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

Source Error:


Line 321:        Dim myDataReader2 As SqlDataReader
Line 322:        myDataReader2 = myCommand1.ExecuteReader(CommandBehavior.CloseConnection)
Line 323:        myDataReader2.Read()
Line 324:        If Not myDataReader2.HasRows Then
Line 325:            msgpid2.Text = "No"

Source File: C:\Inetpub\vhosts\vanniyarmatrimonysites.com\httpdocs\profile\viewprofile1.aspx.vb    Line: 323

Stack Trace:


[SqlException (0x80131904): Transaction (Process ID 2433) was deadlocked on lock 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) +2567614
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5982520
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4349
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +240
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +268
   System.Data.SqlClient.SqlDataReader.Read() +34
   matrimony_google_viewprofile.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\vanniyarmatrimonysites.com\httpdocs\profile\viewprofile1.aspx.vb:323
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


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