com.atlassian.confluence.upgrade.UpgradeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • The Confluence upgrade will fail if osuser + LDAP configuration is present in atlassian-user.xml file. I replicated this setup: h6. atlassian-user.xml file {code} <atlassian-user> <repositories> <hibernate name="Hibernate Repository" key="hibernateRepository" description="Hibernate Repository" cache="true"/> <osuser name="OSUser Repository" key="osuserRepository"/> </repositories> </atlassian-user> {code} h6. osuser.xml file {code} <opensymphony-user> <!-- Authenticators can take properties just like providers. This smart authenticator should work for 'most' cases - it dynamically looks up the most appropriate authenticator for the current server. --> <authenticator class="com.opensymphony.user.authenticator.SmartAuthenticator"/> <provider class="com.atlassian.confluence.user.ConfluenceLDAPCredentialsProvider"> <property name="java.naming.factory.initial">com.sun.jndi.ldap.LdapCtxFactory</property> <property name="java.naming.provider.url">ldap://crowd-ad1:389</property> <property name="searchBase">dc=sydney,dc=atlassian,dc=com</property> <property name="uidSearchName">cn</property> <property name="java.naming.security.principal">cn=Administrator,cn=Users,dc=sydney,dc=atlassian,dc=com</property> <property name="java.naming.security.credentials">atlassian</property> <property name="exclusive-access">true</property> </provider> <!-- <provider class="bucket.user.providers.CachingCredentialsProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcCredentialsProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> </provider> <provider class="bucket.user.providers.CachingAccessProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcAccessProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> </provider> <provider class="bucket.user.providers.CachingProfileProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcProfileProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> --> <provider class="bucket.user.providers.CachingCredentialsProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <provider class="bucket.user.providers.CachingAccessProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateAccessProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <provider class="bucket.user.providers.CachingProfileProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateProfileProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <!--<provider class="com.opensymphony.user.provider.memory.MemoryCredentialsProvider" /> <provider class="com.opensymphony.user.provider.memory.MemoryAccessProvider" /> <provider class="com.opensymphony.user.provider.memory.MemoryProfileProvider" />--> </opensymphony-user> {code} The upgrade will fail with following error: {code} 2011-03-22 12:38:23,262 INFO [main] [confluence.upgrade.upgradetask.EmbeddedCrowdInitUpgradeTask] doUpgrade Created new crowd application object. 2011-03-22 12:38:23,342 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: java.lang.UnsupportedOperationException: Unrecognised user management configuration can not be upgraded. com.atlassian.confluence.upgrade.UpgradeException: java.lang.UnsupportedOperationException: Unrecognised user management configuration can not be upgraded. at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) 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) {code}
    via by Ajay Sridhar [Atlassian],
  • The Confluence upgrade will fail if osuser + LDAP configuration is present in atlassian-user.xml file. I replicated this setup: h6. atlassian-user.xml file {code} <atlassian-user> <repositories> <hibernate name="Hibernate Repository" key="hibernateRepository" description="Hibernate Repository" cache="true"/> <osuser name="OSUser Repository" key="osuserRepository"/> </repositories> </atlassian-user> {code} h6. osuser.xml file {code} <opensymphony-user> <!-- Authenticators can take properties just like providers. This smart authenticator should work for 'most' cases - it dynamically looks up the most appropriate authenticator for the current server. --> <authenticator class="com.opensymphony.user.authenticator.SmartAuthenticator"/> <provider class="com.atlassian.confluence.user.ConfluenceLDAPCredentialsProvider"> <property name="java.naming.factory.initial">com.sun.jndi.ldap.LdapCtxFactory</property> <property name="java.naming.provider.url">ldap://crowd-ad1:389</property> <property name="searchBase">dc=sydney,dc=atlassian,dc=com</property> <property name="uidSearchName">cn</property> <property name="java.naming.security.principal">cn=Administrator,cn=Users,dc=sydney,dc=atlassian,dc=com</property> <property name="java.naming.security.credentials">atlassian</property> <property name="exclusive-access">true</property> </provider> <!-- <provider class="bucket.user.providers.CachingCredentialsProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcCredentialsProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> </provider> <provider class="bucket.user.providers.CachingAccessProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcAccessProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> </provider> <provider class="bucket.user.providers.CachingProfileProvider"> <property name="chain.classname">com.atlassian.confluence.user.providers.jira.JiraJdbcProfileProvider</property> <property name="chain.datasource">java:comp/env/jdbc/JiraDS</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> --> <provider class="bucket.user.providers.CachingCredentialsProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <provider class="bucket.user.providers.CachingAccessProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateAccessProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <provider class="bucket.user.providers.CachingProfileProvider"> <property name="chain.classname">com.opensymphony.user.provider.hibernate.HibernateProfileProvider</property> <property name="chain.configuration.provider.class">bucket.user.BucketHibernateConfigProvider</property> </provider> <!--<provider class="com.opensymphony.user.provider.memory.MemoryCredentialsProvider" /> <provider class="com.opensymphony.user.provider.memory.MemoryAccessProvider" /> <provider class="com.opensymphony.user.provider.memory.MemoryProfileProvider" />--> </opensymphony-user> {code} The upgrade will fail with following error: {code} 2011-03-22 12:38:23,262 INFO [main] [confluence.upgrade.upgradetask.EmbeddedCrowdInitUpgradeTask] doUpgrade Created new crowd application object. 2011-03-22 12:38:23,342 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: java.lang.UnsupportedOperationException: Unrecognised user management configuration can not be upgraded. com.atlassian.confluence.upgrade.UpgradeException: java.lang.UnsupportedOperationException: Unrecognised user management configuration can not be upgraded. at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) 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) {code}
    via by Ajay Sridhar [Atlassian],
  • Trying to upgrade Confluence 3.1 to 3.513 as pre-cursor to upgrading to 4.2 Getting this exception: 2012-04-26 16:37:19,512 ERROR [main] [confluence.user.migration.LdapRepositoryConfigurationMigrator] validateObjectClassDefined Property groupSearchFilter does not define an objectClass filter 2012-04-26 16:37:19,543 ERROR [main] [confluence.user.migration.LdapRepositoryConfigurationMigrator] validateObjectClassDefined Property userSearchFilter does not define an objectClass filter 2012-04-26 16:37:19,547 INFO [main] [confluence.user.migration.AtlassianUserMigrator] validate validated repository [ ldapRepository ] with [ com.atlassian.confluence.user.migration.LdapRepositoryConfigurationMigrator@2e98f864 ] 2012-04-26 16:37:19,550 INFO [main] [confluence.user.migration.AtlassianUserMigrator] validate validated repository [ hibernateRepository ] with [ com.atlassian.confluence.user.migration.HibernateRepositoryConfigurationMigrator@3cdb8522 ] 2012-04-26 16:37:19,694 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.AtlassianUserToEmbeddedCrowdConfigurationUpgradeTask@2f823290 failed during the VALIDATION phase com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.AtlassianUserToEmbeddedCrowdConfigurationUpgradeTask@2f823290 failed during the VALIDATION phase at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:205) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.validateUpgradeTasks(AbstractUpgradeManager.java:140) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:70) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:140) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) 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) 2012-04-26 16:37:19,742 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 2 errors were encountered during upgrade: 2012-04-26 16:37:19,745 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Property groupSearchFilter does not define an objectClass filter 2012-04-26 16:37:19,748 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 2: Property userSearchFilter does not define an objectClass filter here is our atlassian-user.xml. We've been using it with 3.1 for the past 2 years. <atlassian-user> <repositories> <ldap key="ldapRepository" name="LDAP Repository@hecate.atlassian.com" cache="true"> <host>*****.bcbsa.com</host> <port>****</port> <securityPrincipal>uid=*****,ou=Pseudo Accounts, ou=Global, dc=bcbsa,dc=com</securityPrincipal> <securityCredential>******</securityCredential> <securityProtocol>plain</securityProtocol> <securityAuthentication>simple</securityAuthentication> <baseContext>dc=bcbsa,dc=com</baseContext> <baseUserNamespace>ou=people,ou=bcbs,dc=bcbsa,dc=com</baseUserNamespace> <baseGroupNamespace>ou=orgs,ou=bcbs,dc=bcbsa,dc=com</baseGroupNamespace> <usernameAttribute>uid</usernameAttribute> <userSearchFilter>(objectClass=inetorgperson)</userSearchFilter> <firstnameAttribute>givenName</firstnameAttribute> <surnameAttribute>sn</surnameAttribute> <emailAttribute>mail</emailAttribute> <groupnameAttribute>o</groupnameAttribute> <groupSearchFilter>(objectclass=bcbsorganization1)</groupSearchFilter> <!--dummy value to not load orgs as groups--> <membershipAttribute>uniqueMember</membershipAttribute> <userSearchAllDepths>false</userSearchAllDepths> <groupSearchAllDepths>false</groupSearchAllDepths> </ldap> <hibernate name="Hibernate Repository" key="hibernateRepository" description="Hibernate Repository" cache="true" /> </repositories> </atlassian-user>
    via by Michael Roytman,
  • Hi, this happend a second time now and I think it' worth to open a ticket: http://forums.atlassian.com/thread.jspa?threadID=55065 The upgrade to Confluence 3.5 fails, when thumbnails have special characters like german umlauts. Or is this a configuration issue? {code} 2011-06-29 08:52:22,840 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] doCleanupAfterCompletion Closing Hibernate Session [net.sf.hibernate.impl.SessionImpl@62ecd2de] after transaction 2011-06-29 08:52:22,841 DEBUG [main] [springframework.orm.hibernate.SessionFactoryUtils] closeSession Closing Hibernate Session 2011-06-29 08:52:22,841 DEBUG [main] [mchange.v2.resourcepool.BasicResourcePool] trace trace com.mchange.v2.resourcepool.BasicResourcePool@76f4da6d [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@43794494) 2011-06-29 08:52:23,054 DEBUG [main] [atlassian.johnson.config.JohnsonConfig] configureEventChecks Adding eventcheck of class: com.atlassian.confluence.setup.johnson.WebAppContextPathCheck 2011-06-29 08:52:23,060 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task failed: class com.atlassian.confluence.upgrade.upgradetask.PurgeThumbnailsUpgradeTask com.atlassian.confluence.upgrade.UpgradeException: Upgrade task failed: class com.atlassian.confluence.upgrade.upgradetask.PurgeThumbnailsUpgradeTask at com.atlassian.confluence.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:213) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:92) 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) 2011-06-29 08:52:23,083 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2011-06-29 08:52:23,084 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Error removing thumbnails directory [/home/confluence-upgrade/intern/thumbnails] from confluence home 2011-06-29 08:52:23,084 DEBUG [main] [atlassian.confluence.setup.ConfluenceListableBeanFactory] getBean Returning cached instance of singleton bean 'lifecycleManager' 2011-06-29 08:52:23,085 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] getTransaction Using transaction object [org.springframework.orm.hibernate.HibernateTransactionManager$HibernateTransactionObject@279e5431] 2011-06-29 08:52:23,086 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] getTransaction Creating new transaction with name [com.atlassian.event.EventManager.publishEvent]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT 2011-06-29 08:52:23,086 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] doBegin Opened new Session [net.sf.hibernate.impl.SessionImpl@ba97149] for Hibernate transaction {code} Thanks, Peter
    via by Peter Meier,
  • (i) Only affecting users with Oracle DB When upgrading Confluence 4.1.x to 4.1.x (e.g. 4.1.0 to 4.1.5). AddUniqueAttachmentIdConstraintToAttachmentDataUpgradeTask ([CONF-7882]) tries to {{create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID)}}. The upgrade would immediately fail with: {code} 2012-02-15 00:13:09,789 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 4.1.5 (build #3143) 2012-02-15 00:13:13,105 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2012-02-15 00:13:16,840 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2012-02-15 00:13:35,159 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 22054 ms 2012-02-15 00:13:35,230 DEBUG [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized UpgradeLauncherServletContextListener contextInitialized called 2012-02-15 00:14:08,715 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID) 2012-02-15 00:14:08,721 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-01408: such column list already indexed 2012-02-15 00:14:08,723 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-01408: such column list already indexed at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:93) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:45) 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) 2012-02-15 00:14:08,772 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:113) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:45) 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.inATTACHMENTDATA (ATTACHMENTIDvoke(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) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:165) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:93) ... 16 more Caused by: java.sql.SQLException: ORA-01408: such column list already indexed at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161) ... 18 more 2012-02-15 00:14:08,779 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2012-02-15 00:14:08,780 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema 2012-02-15 00:14:08,780 DEBUG [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized UpgradeLauncherServletContextListener contextInitialized completed successfully 2012-02-15 00:14:08,781 WARN [main] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade or licensing errors 2012-02-15 00:14:09,757 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve {code} The error is straight forward. Confluence 4.1.x (Oracle) already has an index {{ATTCH_IDVER_IDX}} on {{ATTACHMENTDATA (ATTACHMENTID, ATTVERSION)}}. !ATTACHMENTDATA_Conf41.png! IMHO, Confluence should drop it first or just skip creating it. This is related to CONF-15228. But I think this is different because {{ATTCH_IDVER_IDX}} was created by Confluence. h5. Workaround # Append the following to your Confluence you're upgrading to [system properties|http://confluence.atlassian.com/display/DOC/Configuring+System+Properties]: {code} -Dhibernate.hbm2ddl.skip_creating_missing_indexes=true {code} This would skip automatic index creation during the upgrade. # Re-run Confluence to trigger the upgrade.
    via by Husein Alatas [Atlassian],
  • The upgrade log gave a warning like below, and it appears that Confluence was going to skip the duplicate and proceed with the upgrade. But the upgrade failed because of duplicate membership anyway: {code} 2011-04-13 14:48:38,854 WARN [main] [confluence.user.migration.AtlassianUserDataMigrator] processRowInternal Duplicate entries found for user name 'nbhawnani', which probably means there were two user names which only differed by case. The first entry found was used, so this user's password and details may not be correct. : : 2011-04-13 14:48:41,416 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated 2011-04-13 14:48:41,417 ERROR [main] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2011-04-13 14:48:41,678 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 com.atlassian.confluence.upgrade.UpgradeException: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:109) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548) : Caused by: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 at com.atlassian.confluence.upgrade.upgradetask.SessionClearingRowCallbackHandler.flushAndClear(SessionClearingRowCallbackHandler.java:54) at com.atlassian.confluence.upgrade.upgradetask.SessionClearingRowCallbackHandler.processRow(SessionClearingRowCallbackHandler.java:41) at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1248) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:395) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:343) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:405) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:409) at com.atlassian.confluence.user.migration.AtlassianUserDataMigrator.migrateGroupMemberships(AtlassianUserDataMigrator.java:176) at com.atlassian.confluence.upgrade.upgradetask.AtlassianUserToEmbeddedCrowdDataUpgradeTask.doUpgrade(AtlassianUserToEmbeddedCrowdDataUpgradeTask.java:74) : : {code} Either make the warning into an error or make Confluence proceed as planned like what the warning said - ignore the duplicate and make the upgrade successful. h5. Work around Execute this query: {code} select name, count(name) from users group by name having count(name) > 1; {code} You can identify which one to delete from their last login date: {code} select u.name, u.id, p.date_val as lastLogin from users u join OS_PROPERTYENTRY p on u.id = p.entity_ID where entity_key='confluence.user.last.login.date' AND u.name='yourDuplicateUserName' order by date_val desc; {code} Then delete them: {code} delete from local_members where userid = xxx; delete from users where id = xxx; {code}
    via by Roy Hartono [Atlassian],
  • (i) Only affecting users with Oracle DB When upgrading Confluence 4.1.x to 4.1.x (e.g. 4.1.0 to 4.1.5). AddUniqueAttachmentIdConstraintToAttachmentDataUpgradeTask ([CONF-7882]) tries to {{create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID)}}. The upgrade would immediately fail with: {code} 2012-02-15 00:13:09,789 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 4.1.5 (build #3143) 2012-02-15 00:13:13,105 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2012-02-15 00:13:16,840 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2012-02-15 00:13:35,159 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 22054 ms 2012-02-15 00:13:35,230 DEBUG [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized UpgradeLauncherServletContextListener contextInitialized called 2012-02-15 00:14:08,715 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID) 2012-02-15 00:14:08,721 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-01408: such column list already indexed 2012-02-15 00:14:08,723 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-01408: such column list already indexed at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:93) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:45) 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) 2012-02-15 00:14:08,772 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:113) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:45) 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.inATTACHMENTDATA (ATTACHMENTIDvoke(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) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:165) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:93) ... 16 more Caused by: java.sql.SQLException: ORA-01408: such column list already indexed at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161) ... 18 more 2012-02-15 00:14:08,779 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2012-02-15 00:14:08,780 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema 2012-02-15 00:14:08,780 DEBUG [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized UpgradeLauncherServletContextListener contextInitialized completed successfully 2012-02-15 00:14:08,781 WARN [main] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade or licensing errors 2012-02-15 00:14:09,757 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve {code} The error is straight forward. Confluence 4.1.x (Oracle) already has an index {{ATTCH_IDVER_IDX}} on {{ATTACHMENTDATA (ATTACHMENTID, ATTVERSION)}}. !ATTACHMENTDATA_Conf41.png! IMHO, Confluence should drop it first or just skip creating it. This is related to CONF-15228. But I think this is different because {{ATTCH_IDVER_IDX}} was created by Confluence. h5. Workaround # Append the following to your Confluence you're upgrading to [system properties|http://confluence.atlassian.com/display/DOC/Configuring+System+Properties]: {code} -Dhibernate.hbm2ddl.skip_creating_missing_indexes=true {code} This would skip automatic index creation during the upgrade. # Re-run Confluence to trigger the upgrade.
    via by Husein Alatas [Atlassian],
  • Hi, this happend a second time now and I think it' worth to open a ticket: http://forums.atlassian.com/thread.jspa?threadID=55065 The upgrade to Confluence 3.5 fails, when thumbnails have special characters like german umlauts. Or is this a configuration issue? {code} 2011-06-29 08:52:22,840 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] doCleanupAfterCompletion Closing Hibernate Session [net.sf.hibernate.impl.SessionImpl@62ecd2de] after transaction 2011-06-29 08:52:22,841 DEBUG [main] [springframework.orm.hibernate.SessionFactoryUtils] closeSession Closing Hibernate Session 2011-06-29 08:52:22,841 DEBUG [main] [mchange.v2.resourcepool.BasicResourcePool] trace trace com.mchange.v2.resourcepool.BasicResourcePool@76f4da6d [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@43794494) 2011-06-29 08:52:23,054 DEBUG [main] [atlassian.johnson.config.JohnsonConfig] configureEventChecks Adding eventcheck of class: com.atlassian.confluence.setup.johnson.WebAppContextPathCheck 2011-06-29 08:52:23,060 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task failed: class com.atlassian.confluence.upgrade.upgradetask.PurgeThumbnailsUpgradeTask com.atlassian.confluence.upgrade.UpgradeException: Upgrade task failed: class com.atlassian.confluence.upgrade.upgradetask.PurgeThumbnailsUpgradeTask at com.atlassian.confluence.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:213) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:92) 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) 2011-06-29 08:52:23,083 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2011-06-29 08:52:23,084 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Error removing thumbnails directory [/home/confluence-upgrade/intern/thumbnails] from confluence home 2011-06-29 08:52:23,084 DEBUG [main] [atlassian.confluence.setup.ConfluenceListableBeanFactory] getBean Returning cached instance of singleton bean 'lifecycleManager' 2011-06-29 08:52:23,085 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] getTransaction Using transaction object [org.springframework.orm.hibernate.HibernateTransactionManager$HibernateTransactionObject@279e5431] 2011-06-29 08:52:23,086 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] getTransaction Creating new transaction with name [com.atlassian.event.EventManager.publishEvent]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT 2011-06-29 08:52:23,086 DEBUG [main] [springframework.orm.hibernate.HibernateTransactionManager] doBegin Opened new Session [net.sf.hibernate.impl.SessionImpl@ba97149] for Hibernate transaction {code} Thanks, Peter
    via by Peter Meier,
  • The upgrade log gave a warning like below, and it appears that Confluence was going to skip the duplicate and proceed with the upgrade. But the upgrade failed because of duplicate membership anyway: {code} 2011-04-13 14:48:38,854 WARN [main] [confluence.user.migration.AtlassianUserDataMigrator] processRowInternal Duplicate entries found for user name 'nbhawnani', which probably means there were two user names which only differed by case. The first entry found was used, so this user's password and details may not be correct. : : 2011-04-13 14:48:41,416 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated 2011-04-13 14:48:41,417 ERROR [main] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2011-04-13 14:48:41,678 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 com.atlassian.confluence.upgrade.UpgradeException: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:109) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548) : Caused by: java.lang.RuntimeException: net.sf.hibernate.exception.ConstraintViolationException: could not insert: com.atlassian.crowd.embedded.hibernate2.HibernateMembership#23332935 at com.atlassian.confluence.upgrade.upgradetask.SessionClearingRowCallbackHandler.flushAndClear(SessionClearingRowCallbackHandler.java:54) at com.atlassian.confluence.upgrade.upgradetask.SessionClearingRowCallbackHandler.processRow(SessionClearingRowCallbackHandler.java:41) at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1248) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:395) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:343) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:405) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:409) at com.atlassian.confluence.user.migration.AtlassianUserDataMigrator.migrateGroupMemberships(AtlassianUserDataMigrator.java:176) at com.atlassian.confluence.upgrade.upgradetask.AtlassianUserToEmbeddedCrowdDataUpgradeTask.doUpgrade(AtlassianUserToEmbeddedCrowdDataUpgradeTask.java:74) : : {code} Either make the warning into an error or make Confluence proceed as planned like what the warning said - ignore the duplicate and make the upgrade successful. h5. Work around Execute this query: {code} select name, count(name) from users group by name having count(name) > 1; {code} You can identify which one to delete from their last login date: {code} select u.name, u.id, p.date_val as lastLogin from users u join OS_PROPERTYENTRY p on u.id = p.entity_ID where entity_key='confluence.user.last.login.date' AND u.name='yourDuplicateUserName' order by date_val desc; {code} Then delete them: {code} delete from local_members where userid = xxx; delete from users where id = xxx; {code}
    via by Roy Hartono [Atlassian],
    • com.atlassian.confluence.upgrade.UpgradeException: java.lang.UnsupportedOperationException: Unrecognised user management configuration can not be upgraded. at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) 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)
    No Bugmate found.