Adding auditing can cause deadlocks in postgresql

Products

• Clarity PPM SaaS

Issue/Introduction

Adding auditing can cause deadlocks in postgresql

Steps to Reproduce: 
1- Start a long running query that takes a long time to complete

2- Add an attribute to be audited

Expected Results: Attribute audit is added

Actual Results:  Deadlock occurs with long query.  Can we warn the user if a long query is running

Workaround: Perform auditing changes after business hours

 

Environment

Clarity 16.2.1, 16.2.2

Resolution

This is being pursued at Broadcom under DE80850