Transitioning an Issue Results in a Workflow Error
- You attempt to transition an issue to a new status and then...
The following appears:
Could not move to history step for #175444: root cause: while inserting: [GenericEntity:OSHistoryStepPrev][id,373216][previousId,373215] (SQL Exception while executing the following:INSERT INTO public.OS_HISTORYSTEP_PREV (ID, PREVIOUS_ID) VALUES (?, ?) (ERROR: duplicate key value violates unique constraint "pk_os_historystep_prev"))
- There is a value in both the os_historystep and os_historystep_prev tables which are the same.
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- In your os_historystep_prev table, delete the entire row with the max(id), restart JIRA, and attempt the transition again.
If you have scripts running in any conditions, validators or post functions, make sure they haven't any errors. Delete them to see if this fixes the issue.If your case is #1, use this command to delete the row
delete from os_historystep_prev where id = <id pertaining to the error>;
Please remember to restart JIRA if making changes to the database.