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

On upgrade from 2.0 to 2.1.3 failed to create two indexes since names longer than 18 chars.

    XMLWordPrintable

Details

    Description

      Some times it feel like I am your DB2 tester
      Got this error for: SP_PERMGROUPNAME_IDX and SP_PERMUSERNAME_IDX

      2006-01-29 14:20:51,196 ERROR [atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask] createIndex Failed to create index:create index sp_permusername_idx on SPACEPERMISSIONS (PERMUSERNAME)
      COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622

      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
      at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source)
      at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896)
      at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.createIndex(AdditionalIndexes1UpgradeTask.java:64)
      at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.doUpgrade(AdditionalIndexes1UpgradeTask.java:34)
      at bucket.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:103)
      at bucket.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:63)
      at bucket.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:27)
      at com.atlassian.confluence.upgrade.ConfluenceUpgradeServletContextListener.contextInitialized(ConfluenceUpgradeServletContextListener.java:14)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
      at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
      at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
      at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
      at org.apache.catalina.core.StandardService.start(StandardService.java:497)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
      at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
      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:324)
      at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              a715b9cd8108 RefuX Zanzeebarr
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: