[JIRA DC] - Table 'jiradb.AO_C77861_AUDIT_ACTION_CACHE' doesn't exist.

[Yong Xin Choon]

Hello Community,

We encountered an issue when the scheduled audit task running, it showed on the [atlassian-jira.log] that:

2024-11-21 14:40:35,215+0800 audit-broker-consumer-thread-821821712 ERROR      [c.a.audit.broker.LoggingAuditConsumerExceptionHandler] Error occurred in com.atlassian.audit.ao.consumer.DatabaseAuditConsumer@e4994f3 while processing 1 events

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.audit.atlassian-audit-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 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: java.lang.RuntimeException: Could not read fields for table AO_C77861_AUDIT_ACTION_CACHE

    at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:136)

    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 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:132)

    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.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:50)

    ... 3 filtered

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)

    at com.sun.proxy.$Proxy143.doInTransaction(Unknown Source)

    ... 3 filtered

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:130)

    at com.sun.proxy.$Proxy143.doInTransaction(Unknown Source)

    at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)

    ... 3 filtered

    at java.lang.reflect.Method.invoke(Method.java:498)

    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)

    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:137)

    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:137)

    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:215)

    at com.sun.proxy.$Proxy1333.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)

    ... 6 more

Caused by: java.sql.SQLSyntaxErrorException: Table 'jiradb.AO_C77861_AUDIT_ACTION_CACHE' doesn't exist

    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)

    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)

    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)

    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)

    at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getResultSetMetaData(DatabaseMetaDataReaderImpl.java:266)

    at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:86)

    ... 63 more

means in our jiradb there is no such [AO_C77861_AUDIT_ACTION_CACHE] table.

Could you give us this table's creating SQL ? 

Our JIRA Data Center Version is: 

Jira v8.22.1

Thanks !

[Florian Bonniec]

Hi @Yong Xin Choon 

This table is related to "Atlassian Audit Plugin" app. Do you have it on your JIRA ? It's a system apps so it should be there.

Regards

[Yong Xin Choon]

Hi Florian,

Thanks for your reply.

Yes, we have this plugin: (So, how should we re-create this table?)

[Florian Bonniec]

If you have a look into the database directly, are you able to find the table ?