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.
データベースの変更を行う場合は必ず事前に可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
- 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.