After upgrading to 8.17.1 the load on the ubuntu server spikes at +12 (normal around 2-5)
Automation took forever (50) min - https://confluence.atlassian.com/automation/upgrading-to-automation-for-jira-7-3-1055951956.html
We did not delete data first.
Also running Big Picture - opgrade tog +20 minutes for a "DB" upgrade.
Before and after:
Stop Jira
Take backup
Execute on the Database:
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.
Load stabilised on 1.X
And we have set Audit logm expiry to 4 weeks
Disabling Jira Automation took load from +12 to 0-2 in 4-5 minutes
This is problkably why:
jira=# select count(*) from "AO_589059_AUTOMATION_QUEUE";
count
-------
129
(1 row)
jira=# select count(*) from "AO_589059_AUDIT_ITEM_PROJECT";
----------
18307910
jira=# select count(*) from "AO_589059_AUDIT_ITEM_ASC_ITEM";
---------
5571251
jira=# select count(*) from "AO_589059_AUDIT_ITEM_CGE_ITEM";
54987603
jira=# select count(*) from "AO_589059_AUDIT_ITEM_COMP_CGE";
57835510
jira=# select count(*) from "AO_589059_AUDIT_ITEM";
29693626
jira=#
jira=# select count(*) from "AO_589059_RULE_STAT";
32077
jira=# select count(*) from "AO_589059_RULE_STAT_ROLLUP_DAY";
--------
897587
jira=# select count(*) from "AO_589059_RULE_STAT_ROLLUP_HR";
216760
jira=# select count(*) from "AO_589059_RULE_STAT_ROLLUP_MIN";
32015
----
29 millions rows. Thats a lot. Unclear regarding these are index correctly
Well, actually 54 millions in one table
It looks like you're new here. Sign in or register to get started.
