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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.