要約

After upgrading to Jira 8.8 or higher, there is data left on the old audit tables, that are never cleaned up.

環境

8.8.0 以上

診断

When upgrading to Jira 8.8+, there is a new advanced auditing feature that takes over. The old audit data is migrated from the old audit tables (audit_changed_value, audit_item and audit_log) to the new one (AO_C77861_AUDIT_ENTITY).

From this moment, the new table is used and the old ones are ignored. If any data was left behind, it won't be removed automatically.

To check if there were entries left in the old tables, simply run:

SELECT count(*) FROM audit_log;

原因 1

Something went wrong during the upgrade and the audit data either wasn't migrated or was only partially migrated.

The logs should contain errors that occurred during the upgrade.

One possible failure cause is a hard limit of 10.000.000 entries for the migration.

ソリューション 1

Since the old data will be ignored, it can be safely deleted. One way to do it is truncating the old tables:

TRUNCATE TABLE audit_changed_value;
TRUNCATE TABLE audit_item;
TRUNCATE TABLE audit_log;

原因 2

The com.atlassian.audit.atlassian-audit-plugin plugin is not enabled. In this case, the old Audit method is running instead of the new one.

ソリューション 2

Try to enable the plugin.

If it's failing, check the logs for errors, or open a ticket in the Atlassian Support and attach a Support Zip.