APMDB Pruning task stops working if any of the sql queries as part of this process fail

book

Article ID: 197128

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE CA Application Performance Management Agent (APM / Wily / Introscope) DX Application Performance Management

Issue/Introduction

APM pruning task is not working as expected, for example, I set data retention to 2 day only

introscope.apm.data.preserving.time  = 2 DAYS

However, when querying the vertices and edges tables I see old data still there:

select min(end_time) from appmap_vertices where vertex_id > 1;
           min
-------------------------
2020-03-29 02:07:56.359
(1 row)

select min(end_time) from appmap_edges

           min
-------------------------
2020-03-29 02:07:56.359
(1 row)

 

1) Restarting MOM doesn't help

2) Dropping table appmap_prunning as suggested in below KB doesn't help either:

Failure of pruning process causes performance issues on MOM impacting Team Center and WebView
https://knowledge.broadcom.com/external/article/141780/failure-of-pruning-process-causes-perfor.html

 

In the EM logs, the below message is reported

org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block 

 

Cause

This issue is related to defect DE463445 - 31936193-Pruning task stops working if any of the sql queries as part of this process fails

In this case the issue was caused because of the high amount of vertices being generated by the CA_Precision_API_Monitoring (PAPIM) integration and ingested in APM causing the "org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block " message

 

Environment

APM 10.7.x and CA_Precision_API_Monitoring

Resolution

Apply 10.7 HOTFIX #65 - the fix will allow the EM to continue to create a new connection and execute on where it left

Contact support to obtain a copy of this HOTFIX

Additional Information

For more information about 10.7 HOTFIXES, see master page

https://knowledge.broadcom.com/external/article/105898/apm-107-hotfixes.html