Summary

After upgrading Jira, observed Jira is extremely slow. 

Environment

8.17.*

Diagnosis

• Observed high CPU usage post upgrade
• Further analysis shows Automation for Jira is causing high CPU usage.
• Disabling plugin, CPU usage was back to normal. 

• Checked the content of the tables by executing below mentioned queries:

  select count(*) from AO_589059_AUTOMATION_QUEUE;
  select count(*) from AO_589059_AUDIT_ITEM_PROJECT;
  select count(*) from AO_589059_AUDIT_ITEM_ASC_ITEM;
  select count(*) from AO_589059_AUDIT_ITEM_CGE_ITEM;
  select count(*) from AO_589059_AUDIT_ITEM_COMP_CGE;
  select count(*) from AO_589059_AUDIT_ITEM;
  
  select count(*) from AO_589059_RULE_STAT;
  select count(*) from AO_589059_RULE_STAT_ROLLUP_DAY;
  select count(*) from AO_589059_RULE_STAT_ROLLUP_HR;
  select count(*) from AO_589059_RULE_STAT_ROLLUP_MIN;

Cause

• Observed large number of records in the tables mentioned above.
• As mentioned in Upgrading to Automation for Jira 7.3 page, need to delete the data from the Automation for Jira tables in the Jira database.

• They contain entries from audit log, automation queue, and rule statistics.

Solution

Below mentioned steps will resolve the issue. 

• Stop jira.
• Take the database backup. 

• Execute the below mentioned queries to delete the data from the Automation for Jira tables

  TRUNCATE AO_589059_AUTOMATION_QUEUE;
  TRUNCATE AO_589059_AUDIT_ITEM_PROJECT;
  TRUNCATE AO_589059_AUDIT_ITEM_ASC_ITEM;
  TRUNCATE AO_589059_AUDIT_ITEM_CGE_ITEM;
  TRUNCATE AO_589059_AUDIT_ITEM_COMP_CGE;
  TRUNCATE AO_589059_AUDIT_ITEM;
  TRUNCATE AO_589059_RULE_STAT;
  TRUNCATE AO_589059_RULE_STAT_ROLLUP_DAY;
  TRUNCATE AO_589059_RULE_STAT_ROLLUP_HR;
  TRUNCATE AO_589059_RULE_STAT_ROLLUP_MIN;

• Start jira