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] | 5 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 5 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

    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