SQL deadlocks and slow alarm processing when soitoolbox --purgeClearedAlerts is running

book

Article ID: 129692

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

During

soitoolbox --purgeClearedAlerts nn  when SOI Services are up and running we are facing lot´s of sql deadlock messages in the soimgr-debug.log and as a cause of this we are facing very slow alarm processing due to a high amount of jobs in the SOI Manager job queues that are processing slow.

Cause

When SOI is up and running and soitoolbox --purgeClearedAlerts runs, it will lock tables to avoid and data inconsistency while removing old Alerts data from the database.

Environment

SOI 4.2

Resolution

new soitoolbox utility resolved the case. Until it will become general available within an official patch it can be requested through a support case.