locked
Constantly failing sweep synch because of deadlock on SharePoint 2007 farm RRS feed

  • Question

  • Hi guys,
     
    I have a farm of 5 servers: 2WFEs, 2 App servers and a database server running SQL 2005.
     
    On one of the WFEs I constsly see the following error in application log:
     
    1)
     
    Log Name:      Application
     Source:        Office SharePoint Server
     Date:          10-05-2013 03:20:02
     Event ID:      5554
     Task Category: (1340)
     Level:         Error
     Keywords:      Classic
     User:          N/A
     Computer:      <Servername>
     Description:
     Fejl under sweep-synkronisering. Undtagelsen var Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction..
     
    Event Xml:
     <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
       <System>
         <Provider Name="Office SharePoint Server" />
         <EventID Qualifiers="0">5554</EventID>
         <Level>2</Level>
         <Task>1340</Task>
         <Keywords>0x80000000000000</Keywords>
         <TimeCreated SystemTime="2013-05-10T01:20:02.000000000Z" />
         <EventRecordID>437395</EventRecordID>
         <Channel>Application</Channel>
         <Computer><Servername></Computer>
         <Security />
       </System>
       <EventData>
         <Data>Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.</Data>
       </EventData>
     </Event>
     
    2)
     
    Log Name:      Application
     Source:        Office SharePoint Server
     Date:          10-05-2013 03:20:02
     Event ID:      7888
     Task Category: (1516)
     Level:         Error
     Keywords:      Classic
     User:          N/A
     Computer:      <Servername>
     Description:
     Der blev registreret en korselsundtagelse. Detaljerne folger.
    Meddelelse: Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
     
    Tekniske detaljer:
     System.Data.SqlClient.SqlException: Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
        at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
        at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
        at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
        at System.Data.SqlClient.SqlDataReader.HasMoreRows()
        at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
        at Microsoft.SharePoint.SPChangeToken.GetCurrentChangeTime(SqlSession session)
        at Microsoft.SharePoint.SPChangeToken..ctor(SPContentDatabase db)
        at Microsoft.SharePoint.Administration.SPContentDatabase.get_CurrentChangeToken()
        at Microsoft.Office.Server.UserProfiles.WSSSweepSynch.DoSweepSynch()
        at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)
     Event Xml:
     <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
       <System>
         <Provider Name="Office SharePoint Server" />
         <EventID Qualifiers="0">7888</EventID>
         <Level>2</Level>
         <Task>1516</Task>
         <Keywords>0x80000000000000</Keywords>
         <TimeCreated SystemTime="2013-05-10T01:20:02.000000000Z" />
         <EventRecordID>437394</EventRecordID>
         <Channel>Application</Channel>
         <Computer><Servername></Computer>
         <Security />
       </System>
       <EventData>
         <Data>Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.</Data>
         <Data>System.Data.SqlClient.SqlException: Transaction (Process ID 104) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
        at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
        at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
        at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
        at System.Data.SqlClient.SqlDataReader.HasMoreRows()
        at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
        at Microsoft.SharePoint.SPChangeToken.GetCurrentChangeTime(SqlSession session)
        at Microsoft.SharePoint.SPChangeToken..ctor(SPContentDatabase db)
        at Microsoft.SharePoint.Administration.SPContentDatabase.get_CurrentChangeToken()
        at Microsoft.Office.Server.UserProfiles.WSSSweepSynch.DoSweepSynch()
        at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)</Data>
       </EventData>
     </Event>
     
    I could not find anything regarding this issue. Could you please help me understand how this can be fixed?

    • Edited by Bazlov Friday, May 10, 2013 7:44 AM
    Friday, May 10, 2013 7:42 AM