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.
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events