Transitioning an Issue Results in a Workflow Error

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

  1. 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"))    

考えられる原因

  1. There is a value in both the os_historystep and os_historystep_prev tables which are the same.

Possible Resolutions

データベースの変更を行う場合は必ず事前にバックアップを取得してください。

  1. In your os_historystep_prev table, delete the entire row with the max(id), restart JIRA, and attempt the transition again.
  2. 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>;

    (info) Please remember to restart JIRA if making changes to the database.

 

 

 

 

 

   

 

 

最終更新日 2016 年 3 月 30 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.