WFE went down last night, looking through Critical sharepoint log errors from around that time. There weren't many, but this one popped up:

"failure trying to synch site 16a023a2-99b5-4abd-a3fd-a79d5d8615b7 for ContentDB 775ea717-2c84-4615-b87e-b1bc92184b38 WebApp b203cc3d-3778-4ef9-87fd-4c35cdec8f51.  Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 316, 153, 0x010500000000000515000000fe63d87a0922064b512bba14e83a0000).  The statement has been terminated.."

failure in SiteSynchronizer.Synch System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'. The duplicate key value is (0c37852b-34d0-418e-91c6-2ac25af4be5b, 316, 153, 0x010500000000000515000000fe63d87a0922064b512bba14e83a0000).  The statement has been terminated.     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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd, Boolean throwOnFail)     at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.WriteChangeLogConsumed()     at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.Synch()     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) Source: .Net SqlClient Data Provider Server: spsql.evercore.local Procedure: profilesynch_SuccessfulSiteChangeLogConsumption LineNumber: 161

• Edited by scogordo 20 hours 9 minutes ago

Hi Scogordo,

The error message should be descripted the same as Event ID 5553, it occurs when the SharePoint Timer Job "User Profile to SharePoint Full Synchronization" fails most due to inconsistance user profile data between User Profile Service and Content Database, see more from below article.

Please run the blow Stsadm commands, then see if this error still occurs.

stsadm -o sync -listolddatabases 0

stsadm -o sync -deleteolddatabases 0

Failure trying to synch site - Event ID 5553

https://support.microsoft.com/en-us/kb/2771190?wa=wsignin1.0

Thanks

Daniel