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 rowdelete from os_historystep_prev where id = <id pertaining to the error>;
Please remember to restart JIRA if making changes to the database.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.