Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-4241

Issues with no workflow actions after upgrade

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • 3.0 Professional Beta, 3.0 Enterprise Beta, 3.0, 3.0.1, 3.0.2, 3.0.3, 3.1, 3.1.1
    • Issue - View Issue

      Occasionally people report that JIRA issues have no workflow. A SQL query like:

      select jiraissue.pkey, jiraissue.workflow_id, OS_WFENTRY.* from jiraissue, OS_WFENTRY where jiraissue.workflow_id=OS_WFENTRY.id and ( OS_WFENTRY.STATE is null or OS_WFENTRY.STATE = 0);

      shows workflows whose STATE column contains null or 0 values, where they should be 1:

      +---------+-------------+-------+------+-------------+-------+
| pkey    | workflow_id | ID    | NAME | INITIALIZED | STATE |
+---------+-------------+-------+------+-------------+-------+
| FOO-45  |       13679 | 13679 | jira |        NULL |     0 |
| FOO-46  |       13680 | 13680 | jira |        NULL |     0 |

      It seems we have a bug somewhere, perhaps an upgrade task for 2.6 is not completing, but marking itself as completed.

      Anyway, we should write an integrity check to detect and fix this.

              Unassigned Unassigned
              7ee5c68a815f Jeff Turner
              Votes:
              1 Vote for this issue
              Watchers:
              98 Start watching this issue

                Created:
                Updated:
                Resolved: