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.

Pega GenAI Athena

Let’s get started! 
Ask me a question or choose a helpful suggestion to start chatting. Keep in mind that I’m always learning, so feel free to give me feedback too!
Remember to avoid sharing personal or sensitive information in your questions, or rely solely on my answers for important decisions.
By chatting with me, you agree to our terms and privacy policy.

Did you find this content helpful?

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