SQL server deadlock is seen intermittently while updating the 'ElasticIndex' table from Enterprise Vault (EV) Directory database while items are being indexed.
Article ID: 100054022
Updated On:
Description
Error Message
Event ID: 13363
The SQL database server detected a deadlock while accessing the Vault Database 'EnterpriseVaultDirectory'| |
Description: | |Transaction (Process ID 210) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.|
Additional Microsoft supplied information:|
Source: Microsoft OLE DB Driver for SQL Server
Number: 0x80004005
SQL State: 40001
Native Error: 00001205
HRESULT 0xc0043433
SQL Command: SELECT DISTINCT ElasticIndexIdentity,ElasticIndexUUID,ElasticIndexName,IndexedItems,IndexSizeInMB,IndexStatus,IndexSourceType,ShardsDetailsXML FROM ElasticIndexView WHERE ElasticIndexUUID = ?
Cause
This issue is caused due to the missing non-clustered index on the "ElasticIndex" table present in EV Directory database.
Resolution
This issue has been addressed in Enterprise Vault 14.2.3 which is available from Downloads.
Issue/Introduction
SQL server deadlock is seen intermittently while updating the 'ElasticIndex' table from Enterprise Vault (EV) Directory database while items are being indexed.
Additional Information
JIRA: CFT-4912
