404 ERROR JIRA SERVER (DTA STORAGE ENGINE ERROR CATALINA.OUT)

[Oumaima Laasri]

Hello,

We have a problem on our jira , we have no access since 2 days and we investiguated everywhere but we didn't find anything help.

We have a 404 error.

and on the catalina.out we have one error repeated every minute :

I deleted the engine storage from the dbconfig.xml connection but I have the same error.

2022-10-13 09:28:02,960 http-nio-8080-exec-70 ERROR anonymous 568x2490242x1 - 172.20.156.182,127.0.0.1 /rest/api/2/serverInfo [c.a.o.serviceprovider.internal.AuthenticatorImpl] Failed to validate OAuth message
com.atlassian.cache.CacheException: com.atlassian.oauth.serviceprovider.StoreException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unknown system variable 'storage_engine')
at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:330)
at com.atlassian.jira.oauth.serviceprovider.CachingServiceProviderConsumerStore.get(CachingServiceProviderConsumerStore.java:80)
at sun.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
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:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
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:179)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy1206.get(Unknown Source)
at com.atlassian.oauth.serviceprovider.internal.AuthenticatorImpl.validateConsumer(AuthenticatorImpl.java:123)
at com.atlassian.oauth.serviceprovider.internal.AuthenticatorImpl.authenticate2LORequest(AuthenticatorImpl.java:277)
at com.atlassian.oauth.serviceprovider.internal.AuthenticatorImpl.authenticate(AuthenticatorImpl.java:107)
... 5 filtered
at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:40)
... 3 filtered
at com.valiantys.jira.plugins.canal.guard.filter.GuardLoginFilter.doFilter(GuardLoginFilter.java:110)
... 73 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.atlassian.oauth.serviceprovider.StoreException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unknown system variable 'storage_engine')
at com.atlassian.jira.oauth.serviceprovider.OfBizServiceProviderConsumerStore.get(OfBizServiceProviderConsumerStore.java:112)
at com.atlassian.jira.oauth.serviceprovider.CachingServiceProviderConsumerStore$ConsumerCacheLoader.load(CachingServiceProviderConsumerStore.java:101)
at com.atlassian.jira.oauth.serviceprovider.CachingServiceProviderConsumerStore$ConsumerCacheLoader.load(CachingServiceProviderConsumerStore.java:98)
at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132)
at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:324)
... 111 more

[Oumaima Laasri · Accepted solution]

Problem is resolved , thank you for your response.

[Florian Bonniec]

Hi @User 500 ,

Can we know how you solve the issue. It will help the community the next time someone face this issue.

Regards 

[Florian Bonniec]

Hi @User 500 

What is your current DB version and JIRA version ?

Did you upgrade recently ?

Regards