We are facing deadlock issue in our web application. The below message is coming:
> Session ID: pwdagc55bdps0q45q0j4ux55
> Location: xxx.xxx.xxx.xxx
> Error in: http://xxx.xxx.xxx.xxx:xxxx/Manhatta...Bar=&Mode=Edit
> Notes:
> Parameters:
> __EVENTTARGET:
> __EVENTARGUMENT:
> __VIEWSTATEENCRYPTED:
> __EVENTVALIDATION: RhhMYHLPLFLEYEj/63IztRQVOjLFF5pOhUnnz9jaCHg/l3lO29NgTGs5YHwUBQ+rMikPxZJLWHT2Qia+4iWlHygrToG1gF 6lN/0Moqf1J9Mk5OZFy1fHeDhjczv//Wt2ZY3btJH5BCmgBqqFB+6MWmc/X+DsPjJ+yAYLeZTrm1WgMXxHdR/j7Omew/jNFn+WTPJvsSmd+p3+a7N4/gaGs3mdKLg=
> ctl00$searchBarHF: hidden
> ctl00$changedHF: true
> ctl00$IDHF: 2312602
> ctl00$StateHF: RI
> ctl00$titleHF: DDS/DMD
> ctl00$specialtyHF:
> ctl00$packHF: 010312-2312602-VPGEHA
> ctl00$sideBarHF:
> ctl00$ContentPlaceHolder1$correctBtn: This is Correct
> ctl00$completedByTB:
> Source: .Net SqlClient Data Provider
> Message: Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
> -----------------------------------StackTrace------------------------------------
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
> at System.Data.SqlClient.TdsParser****n(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.HasMoreRows()
> at System.Data.SqlClient.SqlDataReader.ReadInternal(B oolean setTimeout)
> at System.Data.SqlClient.SqlDataReader.Read()
> at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping)
> at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
> at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
> at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
> at DE_Prov_Specialties.GetData() in X:\XXXXXXXXX\XXXXXXXXX\MD_v2.0\DE\Prov\Specialties .aspx.cs:line 925
> at DE_Prov_Specialties.CompareData() in X:\XXXXXXXXX\XXXXXXXXX\MD_v2.0\DE\Prov\Specialties .aspx.cs:line 1020




Any help will be highly appreciated.

Are you able to run the following and see what command process id 65 is running?

Oh and also run
Essentially we are trying to find which object(s) are being affected and why.

There is a way to kill a specific process which I will include below but you must try find out the where and why first because what are the chances of this problem re-occuring! Hopefully if you identify the issue we can help you re-write the offending code to avoid similar issues again.