No threshold events in CA PM

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

We are not seeing any events in CAPM

On closer look, we find that the Event manager datasource synch is failing in the console.

Environment

Release : 21.2

Component : CA Performance Center

Cause

The mysql databse is hung on an unexpected delete

Resolution

mysql netqosportal -unetqos -pnetqos (your password will vary)

show full processlist\G > /tmp/list.txt

 

Search the results for this job:

…………………………

     Id: 3687

   User: netqos

   Host: capc:36888

     db: em

Command: Query

   Time: 204732

  State: Sending data

   Info: DELETE alarms, alarm_item_properties, alarm_item_gc_memberships, alarm_filter_attribute_values FROM alarms INNER JOIN alarm_item_properties ON alarms.SourceID = alarm_item_properties.SourceID LEFT JOIN alarm_item_gc_memberships ON alarms.SourceID = alarm_item_gc_memberships.SourceID LEFT JOIN alarm_filter_attribute_values ON alarms.SourceID = alarm_filter_attribute_values.SourceID WHERE alarms.SourceID = 4

………………………..

If found, note the id number and run

Kill <ID>;

This will end the job and allow the others queued jobs to finish running.

 

If the issue re-occurs, check the process list for the same job again.

Additional Information

This is fixed in 21.2.8