Upgrade task fails on MySQL

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Highest
    • 2.13.3
    • Affects Version/s: 2.13.2
    • Component/s: Plan
    • None
    • 4
    • Severity 2 - Major
    • 10

      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

            Assignee:
            JamieGeorgeson
            Reporter:
            Thomas
            Archiver:
            Aakrity Tibrewal

              Created:
              Updated:
              Resolved:
              Archived: