Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Error on upgrade 6.13.1to 7.13.2 "Cannot update schema"

ardalan razzaghi
ardalan razzaghi December 26, 2021

Hello,

Upgrading from6.13.1 to7.13.2 after completing upgrade I received this error page:

Pre-upgrade validation failed. Check the Confluence application logs for more details. You'll need to fix these problems and restart Confluence before you can upgrade. Upgrade error message: Cannot update schema

Our database is oracle 12c v2

confluence log :

2021-12-27 09:06:14,419 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.13.2 [build 8703 based on commit hash 18610ca9bb728e0bf306db7f91bba5eaed12b190] - synchrony version 4.0.0-master-f680ea21
2021-12-27 09:06:23,070 WARN [Catalina-utility-1] [confluence.impl.setup.DefaultBootstrapDatabaseAccessor] readValue Unable to determine ZDU status from database. If you are upgrading from a Confluence version prior to 7.9, this is expected.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        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.executeForDescribe(T4CStatement.java:733)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
        at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
        at com.atlassian.confluence.impl.setup.DefaultBootstrapDatabaseAccessor.readValue(DefaultBootstrapDatabaseAccessor.java:79)
        at com.atlassian.confluence.impl.setup.DefaultBootstrapDatabaseAccessor.getBootstrapData(DefaultBootstrapDatabaseAccessor.java:48)
        at com.atlassian.confluence.setup.DefaultBootstrapManager.afterConfigurationLoaded(DefaultBootstrapManager.java:805)
        at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:69)
        at com.atlassian.confluence.setup.DefaultBootstrapManager.init(DefaultBootstrapManager.java:191)
        at com.atlassian.config.util.BootstrapUtils.init(BootstrapUtils.java:34)
        at com.atlassian.confluence.setup.ConfluenceConfigurationListener.initialiseBootstrapContext(ConfluenceConfigurationListener.java:144)
        at com.atlassian.confluence.setup.ConfluenceConfigurationListener.contextInitialized(ConfluenceConfigurationListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5172)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.base/java.lang.Thread.run(Unknown Source)
Caused by: Error : 942, Position : 28, Sql = select STATE, ORIG_VER from CONFZDU, OriginalSql = select STATE, ORIG_VER from CONFZDU, Error Msg = ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
        ... 31 more
2021-12-27 09:06:23,347 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2021-12-27 09:06:25,821 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager2021-12-27 09:06:36,061 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 12713 ms
2021-12-27 09:06:36,258 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2021-12-27 09:06:38,474 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2021-12-27 09:07:00,690 WARN [ThreadPoolAsyncTaskExecutor::Thread 16] [scanner.runtime.impl.ComponentImportBeanFactoryPostProcessor] loadServiceClass Unable to load class 'com.atlassian.jira.user.UserKeyService' for component importation purposes. Skipping...
2021-12-27 09:07:00,690 WARN [ThreadPoolAsyncTaskExecutor::Thread 16] [scanner.runtime.impl.ComponentImportBeanFactoryPostProcessor] loadServiceClass Unable to load class 'com.atlassian.jira.util.I18nHelper' for component importation purposes. Skipping...
2021-12-27 09:07:03,322 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [plugins.createcontent.extensions.BlueprintModuleDescriptor] init i18n-name-key is a required attribute of <blueprint> for module: com.adaptavist.confluence.contentFormattingMacros:cfm-blueprint
2021-12-27 09:07:10,969 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2021-12-27 09:07:47,371 ERROR [Catalina-utility-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:122)
        at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:82)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5172)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.atlassian.config.ConfigurationException: Cannot update schema
        at com.atlassian.confluence.impl.core.persistence.hibernate.schema.ConfluenceSchemaHelper.validateSchemaUpdateIfNeeded(ConfluenceSchemaHelper.java:85)
        at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.validateSchemaUpdateIfNeeded(DefaultUpgradeManager.java:75)
        at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:138)
        ... 13 more
Caused by: org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace (, ) : cwd_synchronisation_status
        at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.processTableResults(InformationExtractorJdbcDatabaseMetaDataImpl.java:491)
        at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getTable(InformationExtractorJdbcDatabaseMetaDataImpl.java:264)
        at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTableInformation(DatabaseInformationImpl.java:111)
        at org.hibernate.tool.schema.internal.IndividuallySchemaMigratorImpl.performTablesMigration(IndividuallySchemaMigratorImpl.java:69)
        at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateSchemaManagementTool$3.performTablesMigration(ConfluenceHibernateSchemaManagementTool.java:110)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
 at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:94)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:62)
        at com.atlassian.confluence.impl.core.persistence.hibernate.schema.ConfluenceSchemaHelper.validateSchemaUpdateIfNeeded(ConfluenceSchemaHelper.java:82)
        ... 15 more
2021-12-27 09:07:47,372 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1 errors were encountered during upgrade:
2021-12-27 09:07:47,372 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1: Cannot update schema
2021-12-27 09:07:47,376 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$lateStartup$4 Plugin system lateStartup begun
2021-12-27 09:07:48,200 WARN [Catalina-utility-1] [extender.internal.support.NamespacePlugins] pass Bundle SAML SingleSignOn for Confluence (com.resolution.atlasplugins.samlsso-confluence) cannot see class [org.springframework.beans.factory.xml.NamespaceHandlerResolver]; ignoring it as a namespace resolver
2021-12-27 09:07:48,201 WARN [Catalina-utility-1] [extender.internal.support.NamespacePlugins] pass Bundle SAML SingleSignOn for Confluence (com.resolution.atlasplugins.samlsso-confluence) cannot see class [org.springframework.beans.factory.xml.NamespaceHandlerResolver]; ignoring it as a namespace resolver
2021-12-27 09:07:48,708 WARN [ThreadPoolAsyncTaskExecutor::Thread 12] [structure.confluence.helper.AppLinkEventsListeningSubscriptionManager] <init> starting
2021-12-27 09:07:48,718 WARN [ThreadPoolAsyncTaskExecutor::Thread 12] [structure.confluence.helper.ThrottledNotificationService] <init> starting
2021-12-27 09:07:48,718 WARN [ThreadPoolAsyncTaskExecutor::Thread 12] [structure.confluence.helper.ThrottledNotificationService] afterPropertiesSet Structure notification service starting send task
2021-12-27 09:07:49,007 WARN [ThreadPoolAsyncTaskExecutor::Thread 3] [extra.flyingpdf.upgrade.UpgradePdfLanguageSupport] afterPropertiesSet More than one file was found in the font directory - custom font will not be migrated for use with the PDF Export plugin.
2021-12-27 09:07:49,089 WARN [ThreadPoolAsyncTaskExecutor::Thread 14] [addons.analytics.scheduler.DataRetentionScheduleManagerImpl] afterPropertiesSet Initializing Data Retention Schedule with frequency: 60000 milliseconds, batch size: 10000
2021-12-27 09:07:49,094 ERROR [ThreadPoolAsyncTaskExecutor::Thread 28] [plugin.osgi.factory.OsgiPlugin] onPluginContainerFailed Unable to start the plugin container for plugin 'com.arsenale.plugins.lockpoint'
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'annotationBasedEventListener': Lookup method resolution failed; nested exception is java.lang.IllegalStateException: Failed to introspect Class [com.arsenale.plugins.lockpoint.AnnotationBasedEventListener] from ClassLoader [com.arsenale.plugins.lockpoint [248]]
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:267)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.determineConstructorsFromBeanPostProcessors(AbstractAutowireCapableBeanFactory.java:1267)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1182)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:554)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:514)
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:321)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:319)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:866)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
        at org.eclipse.gemini.blueprint.context.support.AbstractDelegatedExecutionApplicationContext.access$1600(AbstractDelegatedExecutionApplicationContext.java:57)
        at org.eclipse.gemini.blueprint.context.support.AbstractDelegatedExecutionApplicationContext$4.run(AbstractDelegatedExecutionApplicationContext.java:322)
        at org.eclipse.gemini.blueprint.util.internal.PrivilegedUtils.executeWithCustomTCCL(PrivilegedUtils.java:85)
        at org.eclipse.gemini.blueprint.context.support.AbstractDelegatedExecutionApplicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext.java:287)
        at org.eclipse.gemini.blueprint.extender.internal.dependencies.startup.DependencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaiterApplicationContextExecutor.java:137)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Failed to introspect Class [com.arsenale.plugins.lockpoint.AnnotationBasedEventListener] from ClassLoader [com.arsenale.plugins.lockpoint [248]]
        at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:507)
        at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:404)
        at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:389)
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:249)
        ... 18 more
Caused by: java.lang.NoClassDefFoundError: com/atlassian/plugin/event/events/BeforePluginDisabledEvent
        at java.base/java.lang.Class.getDeclaredMethods0(Native Method)
        at java.base/java.lang.Class.privateGetDeclaredMethods(Unknown Source)
        at java.base/java.lang.Class.getDeclaredMethods(Unknown Source)
        at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:489)
        ... 21 more
Caused by: java.lang.ClassNotFoundException: com.atlassian.plugin.event.events.BeforePluginDisabledEvent
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1364)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1187)
        at org.apache.felix.framework.ExtensionManager$ExtensionManagerWiring.getClassByDelegation(ExtensionManager.java:940)
        at org.apache.felix.framework.BundleWiringImpl.searchImports(BundleWiringImpl.java:1660)
        at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1590)
        at org.apache.felix.framework.BundleWiringImpl.access$200(BundleWiringImpl.java:80)
        at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:2053)
        at java.base/java.lang.ClassLoader.loadClass(Unknown Source)

 

Answer
Watch
Like Be the first to like this
904 views

2 answers

1 vote
Scott Dudley _Cenote_
Scott Dudley _Cenote_ December 27, 2021

Hi @ardalan razzaghi ,

Also as suggested by Pavel, one of the specific errors you see here:

2021-12-27 09:07:49,094 ERROR [ThreadPoolAsyncTaskExecutor::Thread 28] 
[plugin.osgi.factory.OsgiPlugin] onPluginContainerFailed Unable to start 
the plugin container for plugin 'com.arsenale.plugins.lockpoint'

...is caused by using an older version of Cenote Lockpoint that is not compatible with the current version of Confluence. The details of the error message in your log suggest that you are using Lockpoint <= 2.0.x, but you are installing Confluence 7.13.2, for which you need to be using at least Lockpoint 2.4.9+.

I don't believe this error is blocking your upgrade (it would simply mean that Lockpoint itself did not start, which should not block Confluence). Although this would fix one problem, it means you would still need to look into the other database issue in order to get moving.

I hope this helps!

Scott @ Cenote

Reply
1 vote
Pavel Junek
Pavel Junek
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 27, 2021

Hi @ardalan razzaghi,

Welcome to Atlassian community!

According to your atlassian-confluence.log file, I see 3 possible problems: 

1. problem

2021-12-27 09:06:23,070 WARN [Catalina-utility-1] [confluence.impl.setup.DefaultBootstrapDatabaseAccessor] readValue Unable to determine ZDU status from database. If you are upgrading from a Confluence version prior to 7.9, this is expected.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

I found a similar problem that someone else was already solving - see https://community.atlassian.com/t5/Confluence-questions/Error-on-upgrade-to-7-9-ERROR-relation-quot-confzdu-quot-does/qaq-p/1536936.
Looks like it could help incrase JVM_MAXIMUM_MEMORY=2048m parameter in setenv.sh

 

2. problem

2021-12-27 09:07:49,094 ERROR [ThreadPoolAsyncTaskExecutor::Thread 28] [plugin.osgi.factory.OsgiPlugin] onPluginContainerFailed Unable to start the plugin container for plugin 'com.arsenale.plugins.lockpoint'

This is an addon error - Cenote Lockpoint - Attachment Checkout. Did you update all addons before upgrading? A similar problem was solved at https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Plugin-compatibility-Arsenale-Lockpoint-Attachment-Checkout/qaq-p/641483 .

Maybe you just need to clear the Confluence plugin cache - How to clear Confluence plugins cache.

 

3. problem

2021-12-27 09:07:47,371 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema
fCaused by: org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace (, ) : cwd_synchronisation_status

A similar problem was solved at https://community.atlassian.com/t5/Confluence-questions/Update-from-Confluence-Server-7-10-2-to-7-11-Fails/qaq-p/1604007. However, in this case, I recommend writing to Atlassian support directly - https://support.atlassian.com/

Pavel

Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events