Uploaded image for project: 'Advanced Roadmaps'
  1. Advanced Roadmaps
  2. JPOSERVER-2341

Upgrade task fails on MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Highest
    • Resolution: Fixed
    • Affects Version/s: 2.13.2
    • Fix Version/s: 2.13.3
    • Component/s: Plan
    • Labels:
      None

      Description

      Details

      When upgrading to Portfolio 2.13.2, the active objects schema migration fails with MySQL with the following error

       

      Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
       - name:MySQL
       - version:5.7.22-0ubuntu0.16.04.1
       - minor version:7
       - major version:5
       - name:MySQL Connector Java
       - version:mysql-connector-java-5.1.38-SNAPSHOT ( Revision: f918a0f77a2ed4c1d8f98f64b84ba610e5153746 )
      java.sql.SQLException: Cannot drop index 'index_ao_d9132d_tea614189680': needed in a foreign key constraint

       

      This results in plan not being able to load.

       

      Workaround

      Upgrade to Portfolio 2.13.3 or

      1. uninstall the 3 Portfolio for Jira plugin
        1. Portfolio for Jira
        2. Portfolio Live Plans
        3. Portfolio Team Management
      2. Install Portfolio for Jira 2.13.1

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jgeorgeson JamieGeorgeson
              Reporter:
              tbarthelemy Thomas
              Votes:
              0 Vote for this issue
              Watchers:
              15 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: