Confluence Crashes after Upgrade

mislekfti

We have upgraded from 7.11 to 7.14 and was running without an issue. We are now getting the following error:

 

Cause

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.authentication.atlassian-authentication-plugin]
    at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)

caused by: java.lang.RuntimeException: Could not read fields for table AO_ED669C_IDP_CONFIG
    at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)

caused by: java.sql.SQLSyntaxErrorException: Table 'confluence.AO_ED669C_IDP_CONFIG' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

Stack Trace:[hide]

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.authentication.atlassian-authentication-plugin]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86)
	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38)
	at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:84)
	at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:68)
	at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$withRequestContext$1(VCacheRequestContextOperations.java:59)
	at java.base/java.util.concurrent.FutureTask.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 java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: Could not read fields for table AO_ED669C_IDP_CONFIG
	at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)
	at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
	at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
	at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62)
	at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99)
	at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97)
	at com.google.common.collect.Iterators$6.transform(Iterators.java:785)
	at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47)
	at com.google.common.collect.Iterators.addAll(Iterators.java:358)
	at com.google.common.collect.Lists.newArrayList(Lists.java:147)
	at com.google.common.collect.Lists.newArrayList(Lists.java:133)
	at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
	at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
	at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
	at net.java.ao.schema.SchemaGenerator.generateImpl(SchemaGenerator.java:107)
	at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:84)
	at net.java.ao.EntityManager.migrate(EntityManager.java:131)
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52)
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:73)
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)
	at com.atlassian.sal.spring.component.SpringHostContextAccessor.lambda$doInTransaction$0(SpringHostContextAccessor.java:70)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:68)
	at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.access$001(ConfluenceSpringHostContextAccessor.java:21)
	at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.lambda$doInTransaction$3(ConfluenceSpringHostContextAccessor.java:72)
	at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:84)
	at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:68)
	at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.doInTransaction(ConfluenceSpringHostContextAccessor.java:72)
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)
	at jdk.internal.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
	at com.sun.proxy.$Proxy272.execute(Unknown Source)
	at jdk.internal.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy1144.execute(Unknown Source)
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:70)
	at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91)
	... 9 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'confluence.AO_ED669C_IDP_CONFIG' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getResultSetMetaData(DatabaseMetaDataReaderImpl.java:271)
	at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:91)
	... 65 more

We did get similar issues when we upgraded to 7.20 as well. However 7.14 was the last upgrade we could perform without this issue coming up. Now it has returned even for 7.14. Not sure what we can do.

 

 

vikram_eupqsc

@mislekfti 

Here we can see 1 table is not present, please create and restar the confluence it should work, we can execute below script in (MYSQL)

-- phpMyAdmin SQL Dump

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @CHARACTER_SET_CLIENT */;
/*!40101 SET @CHARACTER_SET_RESULTS */;
/*!40101 SET @COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `confluencedb`
--

-- --------------------------------------------------------

--
-- Table structure for table `AO_ED669C_IDP_CONFIG`
--

CREATE TABLE `AO_ED669C_IDP_CONFIG` (
`ADDITIONAL_JIT_SCOPES` longtext COLLATE utf8mb4_bin,
`ADDITIONAL_SCOPES` longtext COLLATE utf8mb4_bin,
`AUTHORIZATION_ENDPOINT` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`BUTTON_TEXT` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`CLIENT_ID` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`CLIENT_SECRET` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`ENABLED` tinyint(1) NOT NULL,
`ENABLE_REMEMBER_ME` tinyint(1) DEFAULT NULL,
`ID` bigint(20) NOT NULL,
`INCLUDE_CUSTOMER_LOGINS` tinyint(1) DEFAULT NULL,
`ISSUER` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`LAST_UPDATED` datetime DEFAULT NULL,
`MAPPING_DISPLAYNAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`MAPPING_EMAIL` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`MAPPING_GROUPS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`NAME` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`SAML_IDP_TYPE` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`SIGNING_CERT` longtext COLLATE utf8mb4_bin,
`SSO_TYPE` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`SSO_URL` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`TOKEN_ENDPOINT` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`USERNAME_ATTRIBUTE` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`USERNAME_CLAIM` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`USER_INFO_ENDPOINT` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`USER_PROVISIONING_ENABLED` tinyint(1) DEFAULT NULL,
`USE_DISCOVERY` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `AO_ED669C_IDP_CONFIG`
--
ALTER TABLE `AO_ED669C_IDP_CONFIG`
ADD PRIMARY KEY (`ID`),
ADD UNIQUE KEY `U_AO_ED669C_IDP_CON1454004950` (`BUTTON_TEXT`),
ADD UNIQUE KEY `U_AO_ED669C_IDP_CONFIG_ISSUER` (`ISSUER`),
ADD UNIQUE KEY `U_AO_ED669C_IDP_CONFIG_NAME` (`NAME`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `AO_ED669C_IDP_CONFIG`
--
ALTER TABLE `AO_ED669C_IDP_CONFIG`
MODIFY `ID` bigint(20) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

---

-- phpMyAdmin SQL Dump

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @CHARACTER_SET_CLIENT */;
/*!40101 SET @CHARACTER_SET_RESULTS */;
/*!40101 SET @COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `confluencedb`
--------------------------------------