SQL Deadlocks can occur between different processes executing the usp_SavesetFinishInsert5 stored procedure during Archiving or Journaling

book

Article ID: 100033627

calendar_today

Updated On:

Description

SQL Deadlocks can occur between different processes executing the usp_SavesetFinishInsert5 stored procedure during Archiving or Journaling

Resolution

This issue has been addressed in the following release:
 
Enterprise Vault 12.2


 
Note: For information on how to obtain latest Enterprise Vault see: Enterprise Vault Download portal

Issue/Introduction

During Mailbox Archiving or Journaling, SQL Deadlocks can occur between different processes (SPIDs) of the execution of the usp_SavesetFinishInsert5 stored procedure.
The deadlock can occur when 2 different processes start within microseconds of each other to process different messages containing the same attachments

The deadlock occurs at the following section:
 

UPDATE @tbSISParts
      SET [SISPartIdentity] = sis.[SISPartIdentity]
      FROM SISPart sis 
      INNER JOIN @tbSISParts tsis
      ON tsis.[FPHashPart1] = sis.[FPHashPart1] AND tsis.[FPDistinctionByte] =
sis.[FPDistinctionByte] 
      AND sis.[FileTransactionId] = tsis.[FileTransactionId] AND tsis.[UniqueId]
= sis.[UniqueId]
      AND sis.[IdPartition] = tsis.[IdPartition] AND sis.[VaultStoreIdentity] =
tsis.[VaultStoreIdentity  

Additional Information

ETrack: 3907137