Adding auditing can cause deadlocks in postgresql

Products

• Clarity PPM SaaS

Issue/Introduction

Adding auditing can cause deadlocks in Postgresql. Which in turn can cause application slowness. It can include users starting to see white pages in the Modern UX, or pages not loading.

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.

Environment

Clarity SaaS

Resolution

Workaround: Perform auditing changes after business hours.