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

Details

    • Bug
    • Resolution: Fixed
    • Highest
    • 2.13.3
    • 2.13.2
    • Plan
    • 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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JPOSERVER-2340 Unknown column 'PLANTEAM_ID' in 'field list'

          • Low - Low priority issues
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:
                Archived: