Details
-
Bug
-
Status: Closed (View Workflow)
-
Highest
-
Resolution: Fixed
-
2.13.2
-
None
-
4
-
Severity 2 - Major
-
10
-
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
- uninstall the 3 Portfolio for Jira plugin
- Portfolio for Jira
- Portfolio Live Plans
- Portfolio Team Management
- Install Portfolio for Jira 2.13.1
Attachments
Issue Links
- is duplicated by
-
JPOSERVER-2340 Unknown column 'PLANTEAM_ID' in 'field list'
-
- Closed
-