Hi there,
We attempt to upgrade Confluence on a production replication date set and encountered an can not upgrade schema error.
2018-05-07 20:17:55,739 ERROR [localhost-startStop-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 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:157)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.launchUpgrades(PluginFrameworkContextListener.java:125)
at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:85)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4884)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5347)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1410)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1400)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.atlassian.config.ConfigurationException: Cannot update schema
at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:190)
at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:164)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:141)
... 11 more
Caused by: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateSchemaManagementTool.createGeneratorTable(ConfluenceHibernateSchemaManagementTool.java:190)
at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateSchemaManagementTool.access$100(ConfluenceHibernateSchemaManagementTool.java:48)
at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateSchemaManagementTool$3.performTablesMigration(ConfluenceHibernateSchemaManagementTool.java:127)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:203)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:87)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:58)
at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:188)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
... 21 more
Caused by: Error : 955, Position : 13, Sql = create table hibernate_unique_key ( next_hi number(10,0) ), OriginalSql = create table hibernate_unique_key ( next_hi number(10,0) ), Error Msg = ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 35 more
2018-05-07 20:17:55,745 ERROR [localhost-startStop-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1 errors were encountered during upgrade:
2018-05-07 20:17:55,745 ERROR [localhost-startStop-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1: Cannot update schema
2018-05-07 20:17:55,749 INFO [localhost-startStop-1] [atlassian.plugin.manager.DefaultPluginManager] lateStartup Plugin system lateStartup begun
2018-05-07 20:17:57,220 WARN [ThreadPoolAsyncTaskExecutor::Thread 24] [client.eventfilter.whitelist.AnalyticsWhitelistModuleDescriptor] readPluginWhitelist No whitelist resource file found at [mediaviewer/lib/analytics-whitelist.json] in plugin [com.atlassian.confluence.plugins.confluence-previews] (bundle entry not found)
Then attempted to remove this table and the upgrade passed.
Also noticed there are errors on trying to create the AO table after the upgrade.
eg:
2018-05-07 20:18:05,832 ERROR [active-objects-init-system tenant-0] [net.java.ao.sql] handleUpdateError Exception executing SQL update <CREATE TABLE "AO_950DC3_TC_SUBCALS" (
"COLOUR" VARCHAR(255),
"CREATED" NUMBER(20) DEFAULT 0,
"CREATOR" VARCHAR(255),
"DESCRIPTION" CLOB,
"ID" VARCHAR(255) NOT NULL,
"LAST_MODIFIED" NUMBER(20) DEFAULT 0,
"NAME" CLOB NOT NULL,
"PARENT_ID" VARCHAR(255),
"SPACE_KEY" VARCHAR(255),
"STORE_KEY" VARCHAR(255) NOT NULL,
"SUBSCRIPTION_ID" VARCHAR(255),
"TIME_ZONE_ID" VARCHAR(255),
"USING_CUSTOM_EVENT_TYPE_ID" VARCHAR(255),
CONSTRAINT "fk_ao_950dc3_tc_sub686168731" FOREIGN KEY ("SUBSCRIPTION_ID") REFERENCES "AO_950DC3_TC_SUBCALS"("ID"),
CONSTRAINT "fk_ao_950dc3_tc_sub193155694" FOREIGN KEY ("PARENT_ID") REFERENCES "AO_950DC3_TC_SUBCALS"("ID"),
PRIMARY KEY("ID")
)>
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
Please advise.
Thanks,
Leo
