Summary

Jira is timing out (during transitioning) when an issue having a huge number of History

Steps to Reproduce

1. Create an issue with a change log with huge history changes.
2. View the issue history tab for that issue and attempt to transition the issue

Expected Results

• A full history should be displayed.
• Able to transition the issues

Actual Results

• Communication Breakdown appears when going into the History Tab

  Communications Breakdown
  The Jira server could not be contacted. This may be a temporary glitch or the server may be down.
  Close this dialog and press refresh in your browser
  

• The spinning wheel will be displayed for a few minutes when transitioning issues from the and the following error are displayed

  Caught PSQLException for update "public"."changeitem" "CHANGE_ITEM" set "nextchanged" = (select min("SUBSEQUENT_CHANGE_GROUP"."created") from "public"."changegroup" "SUBSEQUENT_CHANGE_GROUP" where "SUBSEQUENT_CHANGE_GROUP"."created" is not null and exists (select 1 from ((select 1 from "public"."changeitem" "SUBSEQUENT_CHANGE_ITEM" where "SUBSEQUENT_CHANGE_ITEM"."oldvalue" is null and "CHANGE_ITEM"."newvalue" is null and "SUBSEQUENT_CHANGE_ITEM"."groupid" = "SUBSEQUENT_CHANGE_GROUP"."id" and "CHANGE_ITEM"."fieldid" = "SUBSEQUENT_CHANGE_ITEM"."fieldid") union all (select 1 from "public"."changeitem" "SUBSEQUENT_CHANGE_ITEM" where "SUBSEQUENT_CHANGE_ITEM"."oldvalue" = "CHANGE_ITEM"."newvalue" and "SUBSEQUENT_CHANGE_ITEM"."groupid" = "SUBSEQUENT_CHANGE_GROUP"."id" and "CHANGE_ITEM"."fieldid" = "SUBSEQUENT_CHANGE_ITEM"."fieldid")) as "subsequent_change_item_conditions" limit ?) and exists (select 1 from "public"."changegroup" "ASSOCIATED_CHANGE_GROUP" where "ASSOCIATED_CHANGE_GROUP"."issueid" = "SUBSEQUENT_CHANGE_GROUP"."issueid" and "SUBSEQUENT_CHANGE_GROUP"."created" > "ASSOCIATED_CHANGE_GROUP"."created" and "ASSOCIATED_CHANGE_GROUP"."id" = "CHANGE_ITEM"."groupid")) where "CHANGE_ITEM"."fieldid" in (?, ?, ?, ?, ?, ?) and "CHANGE_ITEM"."nextchanged" is null and ("CHANGE_ITEM"."fieldid" != ? or "CHANGE_ITEM"."newvalue" is not null) and (select min("SUBSEQUENT_CHANGE_GROUP"."created") from "public"."changegroup" "SUBSEQUENT_CHANGE_GROUP" where "SUBSEQUENT_CHANGE_GROUP"."created" is not null and exists (select 1 from ((select 1 from "public"."changeitem" "SUBSEQUENT_CHANGE_ITEM" where "SUBSEQUENT_CHANGE_ITEM"."oldvalue" is null and "CHANGE_ITEM"."newvalue" is null and "SUBSEQUENT_CHANGE_ITEM"."groupid" = "SUBSEQUENT_CHANGE_GROUP"."id" and "CHANGE_ITEM"."fieldid" = "SUBSEQUENT_CHANGE_ITEM"."fieldid") union all (select 1 from "public"."changeitem" "SUBSEQUENT_CHANGE_ITEM" where "SUBSEQUENT_CHANGE_ITEM"."oldvalue" = "CHANGE_ITEM"."newvalue" and "SUBSEQUENT_CHANGE_ITEM"."groupid" = "SUBSEQUENT_CHANGE_GROUP"."id" and "CHANGE_ITEM"."fieldid" = "SUBSEQUENT_CHANGE_ITEM"."fieldid")) as "subsequent_change_item_conditions" limit ?) and exists (select 1 from "public"."changegroup" "ASSOCIATED_CHANGE_GROUP" where "ASSOCIATED_CHANGE_GROUP"."issueid" = "SUBSEQUENT_CHANGE_GROUP"."issueid" and "SUBSEQUENT_CHANGE_GROUP"."created" > "ASSOCIATED_CHANGE_GROUP"."created" and "ASSOCIATED_CHANGE_GROUP"."id" = "CHANGE_ITEM"."groupid")) is not null and "CHANGE_ITEM"."groupid" in (select "CHANGE_GROUP"."id" from "public"."changegroup" "CHANGE_GROUP" where "CHANGE_GROUP"."issueid" = ?)

  It seems that you have tried to perform an illegal workflow operation.

  If you think this message is wrong, please contact your Jira administrators.

Workaround

• Clone the issue, link it with the original issue and use the cloned issue. Or
• Use CSV import with just 3 required columns and map it accordingly. - https://URL.atlassian.net/secure/admin/ExternalImport1.jspa

  Issue key, status, summary
  ABC-1 In Progress, Test ticket