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?
