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

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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Highest Highest
    • 2.13.3
    • 2.13.2
    • Plan
    • None

      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

            jgeorgeson JamieGeorgeson
            tbarthelemy Thomas
            Archiver:
            atibrewal@atlassian.com Aakrity Tibrewal

              Created:
              Updated:
              Resolved:
              Archived: