Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Location
    Karachi, Pakistan
    Posts
    1

    Unanswered: Transaction (Process ID 65) was deadlocked on lock resources with another process.

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you able to run the following and see what command process id 65 is running?
    Code:
    DBCC INPUTBUFFER (65)
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Oh and also run
    Code:
    EXEC sp_lock
    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.

    George
    Home | Blog

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •