Adding auditing can cause deadlocks in postgresql

Products

• Clarity PPM SaaS

Issue/Introduction

Adding auditing can cause deadlocks in postgresql.

Steps to Reproduce:

• Start a long running query that takes a long time to complete
• Add an attribute to be audited

Expected Results: Attribute audit is added

Actual Results:  Deadlock occurs with long query

Workaround: Perform auditing changes after business hours

Environment

Clarity 16.2.1, 16.2.2

Resolution

This is being pursued at Broadcom under DE80850.