Purging Automation for Jira audit logs

kchristmann May 18, 2021

We have a lot of old audit items in our database that were generated by Automation for Jira. We were going to try to follow the instructions from this guide to delete old audit items but we encountered a problem.

https://confluence.atlassian.com/automation/expire-audit-log-items-993924681.html

Our DBA was going to try to delete old audit items directly from the database, but he found that there was a foreign key relationship on a related queue table [AO_589059_AUTOMATION_QUEUE]  that references one of the audit log tables. In order to delete the audit records, he said he would have to remove the foreign key, delete the records, then add it back. Is this safe to do or is this article out of date? We would like to perform this operation in the most performant way possible.

 

 

0 answers

Suggest an answer

Log in or Sign up to answer