com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@27091f57 failed during the SCHEMA_UPGRADE phase due to: null

Atlassian JIRA | Jing Hwa [Atlassian] | 3 months ago
  1. 0

    h3. Summary The Confluence upgrade from 5.6.x to 5.10.x failed if the FK9228242D16994414 constraint missing from space table. The upgrade failed because Confluence is attempting to delete the constraint which does not exist in the table. h3. Step to replicate # Drop the FK9228242D16994414 from the spaces table {code} ALTER TABLE spaces DROP FOREIGN KEY FK9228242D16994414 {code} # Upgrade the Confluence from 5.6.x to 5.10.x h3.Expected Result The upgrade is successful h3.Observed Result The upgrade failed with the following error.The error indicate that the Confluence hit into NullPointerException when it try to delete the FK9228242D16994414 constraint which does not exist. By right the Confluence should have detected that the constraint is misisng and skip the constraint deletion task since it doesn't affect the end result of the upgrade. {code} 2016-09-15 04:31:27,243 ERROR [localhost-startStop-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@27091f57 failed during the SCHEMA_UPGRADE phase due to: null com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@27091f57 failed during the SCHEMA_UPGRADE phase due to: null at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:229) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.runSchemaUpgradeTasks(AbstractUpgradeManager.java:185) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:140) at com.atlassian.confluence.plugin.PluginFrameworkContextListener.launchUpgrades(PluginFrameworkContextListener.java:118) at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:77) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4842) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5303) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask.doUpgrade(DropSpaceGroupTablesUpgradeTask.java:68) {code} h3.Workaround: Add the constraint back to the spaces table. {code} ALTER TABLE spaces ADD CONSTRAINT FK9228242D16994414 FOREIGN KEY (SPACEGROUPID) REFERENCES spacegroups(SPACEGROUPID); {code}

    Atlassian JIRA | 3 months ago | Jing Hwa [Atlassian]
    com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@27091f57 failed during the SCHEMA_UPGRADE phase due to: null
  2. 0

    Android: Saving Map State in Google map

    Stack Overflow | 11 months ago | Junie Negentien
    java.lang.RuntimeException: Unable to resume activity {com.ourThesis.junieNegentien2015/com.ourThesis.junieNegentien2015.MainActivity}: java.lang.NullPointerException
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask.doUpgrade()
    2. com.atlassian.confluence
      DropSpaceGroupTablesUpgradeTask.doUpgrade
      1. com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask.doUpgrade(DropSpaceGroupTablesUpgradeTask.java:68)
      1 frame