Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22579

"ORA-02292: integrity constraint" while upgrading database schema

    XMLWordPrintable

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)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            aa5541210afa Daniel Heise
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: