Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Deadlock on table pr4_log_rule_usage_details

SA-30503

Summary



When the System Cleaner agent is enabled on all the nodes, it is causing database contention on the pr4_log_rule_usage_details table. Because of this records are NOT getting deleted properly. The following query fails with deadlock errors frequently:

DELETE
FROM schema-name.pr4_log_rule_usage_details 
WHERE pxObjClass = 'Log-RuleUsage-Details' 
AND pxSystemNode = ?  
AND pyLabel = ?


Error Messages

DSNT408I SQLCODE = -913, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT.


Steps to Reproduce



Not applicable. 


Root Cause



A defect in Pegasystems’ code or rules.  The System Cleaner agent should only run on one node.

Resolution



Apply HFix-30508 which ensures only one node is running SystemCleaner at any given time.
 

Published November 20, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us