Details
-
Bug
-
Resolution: Support Request
-
High
-
None
-
3.5.4
Description
I want to upgrade my 3.1.1 to 3.5.4. After starting the new system I get the following error while updating the database schema:
2011-05-24 09:11:09,656 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 3.5.4 (build #2156) 2011-05-24 09:11:11,960 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Initialising the plugin system 2011-05-24 09:11:12,172 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Plugin system started in 0:00:00.210 2011-05-24 09:11:13,601 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2011-05-24 09:11:16,901 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2011-05-24 09:11:39,788 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 26177 ms 2011-05-24 09:12:05,140 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Schema upgrade task [ com.atlassian.confluence.upgrade.upgradetask.ContentPermissionConstraintsUpgradeTask@3e4523d6 ] failed due to : PreparedStatementCallback; SQL [DELETE FROM CONTENT_PERM_SET WHERE id = ?]; ORA-02292: integrity constraint (CONFLUENCE.FKBD74B31676E33274) violated - child record found ; nested exception is java.sql.SQLException: ORA-02292: integrity constraint (CONFLUENCE.FKBD74B31676E33274) violated - child record found com.atlassian.confluence.upgrade.UpgradeException: Schema upgrade task [ com.atlassian.confluence.upgrade.upgradetask.ContentPermissionConstraintsUpgradeTask@3e4523d6 ] failed due to : PreparedStatementCallback; SQL [DELETE FROM CONTENT_PERM_SET WHERE id = ?]; ORA-02292: integrity constraint (CONFLUENCE.FKBD74B31676E33274) violated - child record found ; nested exception is java.sql.SQLException: ORA-02292: integrity constraint (CONFLUENCE.FKBD74B31676E33274) violated - child record found at com.atlassian.confluence.upgrade.AbstractUpgradeManager.runSchemaUpgradeTasks(AbstractUpgradeManager.java:292) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:235) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:87) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)