Workflows over 64k truncated in MySQL

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: High
    • 3.1
    • Affects Version/s: 3.0 Standard Beta, 3.0 Professional Beta, 3.0 Enterprise Beta, 3.0, 3.0.1, 3.0.2, 3.0.3
    • Environment:

      MySQL

    • 3

      When editing particularly large workflows (eg. 15 steps, over 40 transitions), JIRA may hit MySQL's 64k limit on the size of TEXT fields. When this happens, MySQL silently truncates the data from the last edit. Trying to edit the workflow will result in an error, and the workflow will not properly display in the 'View Workflows' page. An error like the following will appear in the logs:

      2005-01-12 13:07:14,979 ERROR [atlassian.jira.workflow.OSWorkflowManager] Could not get workflow called: New Development Life Cycle workflow: com.opensymphony.workflow.FactoryException: Error in workflow descriptor: New Development Life Cycle workflow: root cause: XML document structures must start and end within the same entity. (line:1280 col:24)
      com.opensymphony.workflow.FactoryException: Error in workflow descriptor: New Development Life Cycle workflow: root cause: XML document structures must start and end within the same entity. (line:1280 col:24)
      at com.atlassian.jira.workflow.JiraWorkflowFactory.loadJiraWorkflow(JiraWorkflowFactory.java:186)
      at com.atlassian.jira.workflow.JiraWorkflowFactory.getWorkflow(JiraWorkflowFactory.java:88)
      at com.opensymphony.workflow.config.DefaultConfiguration.getWorkflow(DefaultConfiguration.java:76)
      at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflow(OSWorkflowManager.java:152)

              Assignee:
              MarkC
              Reporter:
              Jeff Turner
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: