SQL deadlocks occur during Accelerator search processing.

book

Article ID: 100056413

calendar_today

Updated On:

Description

Error Message

In the Enterprise Vault Event Log on the Accelerator server:

Event ID: 41619

A transient error is preventing the execution of a SQL command. Enterprise Vault will try to run the command again.
Command: 'EVSqlCommand: DB: server=;Initial Catalog=;Integrated Security=true;Connection TimeOut=500;Connection LifeTime=500;Max Pool Size=2000;Application Name= - Command: usp_upd_SearchVault_Error'
Attempt: X of 40.
Last Error: Transaction (Process ID X) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
V-437-41619

Event ID: 41609
A database error was resolved after X ms and X retries.

Error: Error Code: 1205 / 80131904 - Severity 13 - Transaction (Process ID X) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Reference: EVSqlCommand: DB: server=;Initial Catalog=;Integrated Security=true;Connection TimeOut=500;Connection LifeTime=500;Max Pool Size=2000;Application Name= - Command: usp_upd_SearchVault_Error
V-437-41609

 

Cause

The search information is updated at regular intervals during the search processing in various tables in the Customer database. The investigation determined excessive updates via a SQL trigger in a table caused the deadlocks.

 

Resolution

There are no plans to address this issue by way of a patch or hotfix in earlier versions of the software at the present time.  However, the issue has been addressed in the revision of the product specified at the end of this article. 
 
Please contact your Sales representative or the Sales group for upgrade information including upgrade eligibility to the release containing the resolution for this issue.

This issue is fixed in the following release(s), available in the Download Center at https://www.veritas.com/support:
- Enterprise Vault 14.4.1 

 

Issue/Introduction

Enterprise Vault (EV) Compliance Accelerator (CA) or Discovery Accelerator (DA) searches may cause SQL deadlocks to be encountered while processing the index volumes targeted in the search. These deadlocks can cause the CA/DA Client to become unresponsive when viewing the Monitor tab, the Searches sub-tab of a CA Department, DA Case or CA/DA Research Folder.

Additional Information

JIRA: CFT-5412