[JIRA DataCenter-v8.22.1] - Appfire's plugin causes an SQL issue.

[Yong Xin Choon]

We installed a plugin from AppFire: [Reports and Timesheets for Jira]

And it causes an SQL error on our datacenter server: （JIRA version: v8.22.1）

2024-10-08T14:30:06,493 DEBUG service.offline.AioThreadPool:22 - Starting restApiQueuePool: 20 2024-10-08T14:30:06,498 DEBUG service.offline.AioThreadPool:24 - Started restApiQueuePool: restApiQueuePool: aio.jira.app.service.offline.NamedThreadPoolExecutor@6d2ded98[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] 2024-10-08T14:30:06,498 DEBUG service.offline.AioThreadPool:31 - Starting restApiExecutorPool: 20 2024-10-08T14:30:06,498 DEBUG service.offline.AioThreadPool:33 - Started restApiExecutorPool: restApiExecutorPool: aio.jira.app.service.offline.NamedThreadPoolExecutor@5e3d71ab[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] 2024-10-08T14:30:06,501 DEBUG app.service.CachingServiceHostedMapDB:214 - CachingServiceMapDB createPersistentCacheDirectory 2024-10-08T14:30:06,502 DEBUG app.service.CachingServiceHostedMapDB:218 - Data directory path: /var/atlassian/application-data/jira 2024-10-08T14:30:06,502 DEBUG app.service.CachingServiceHostedMapDB:220 - Appfire Cache directory path: /var/atlassian/application-data/jira/aio-connector-cache-rp 2024-10-08T14:30:06,502 DEBUG app.service.CachingServiceHostedMapDB:230 - Creating directory /var/atlassian/application-data/jira/aio-connector-cache-rp 2024-10-08T14:30:06,502 DEBUG app.service.CachingServiceHostedMapDB:235 - Directory created successfully: /var/atlassian/application-data/jira/aio-connector-cache-rp 2024-10-08T14:30:06,522 DEBUG service.offline.AioThreadPool:40 - Starting searchQueuePool: 20 2024-10-08T14:30:06,522 DEBUG service.offline.AioThreadPool:42 - Started searchQueuePool: searchQueuePool: aio.jira.app.service.offline.NamedThreadPoolExecutor@251f39fa[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] 2024-10-08T14:30:06,522 DEBUG service.offline.AioThreadPool:50 - Starting searchExecutorPool: 20 2024-10-08T14:30:06,522 DEBUG service.offline.AioThreadPool:52 - Started searchExecutorPool: searchExecutorPool: aio.jira.app.service.offline.NamedThreadPoolExecutor@6ab8db[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] 2024-10-08T14:30:09,815 DEBUG app.service.CachingServiceHostedMapDB:183 - initNode 2024-10-08T14:30:09,817 ERROR app.service.CachingServiceHostedMapDB:188 - bundle [com.kaanha.reports] com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.kaanha.reports] 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) ~[?:1.8.0_211] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_211] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_211] Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:8.0.35 - minor version:0 - major version:8

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

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROW LONGTEXT, ROW_TOTAL_FILTER VARCHAR(255), RUN_COUNT INTEGER, SALT' at line 34 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54) ~[?:?] 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) ~[classes/:?] at sun.reflect.GeneratedMethodAccessor223.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_211] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_211] at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) ~[atlassian-plugins-core-5.7.3.jar:?] at com.sun.proxy.$Proxy487.doInTransaction(Unknown Source) ~[?:?] at sun.reflect.GeneratedMethodAccessor223.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_211] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_211] at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:130) ~[atlassian-plugins-osgi-bridge-5.7.3.jar:?] at com.sun.proxy.$Proxy487.doInTransaction(Unknown Source) ~[?:?] at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18) ~[?:?] at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_211] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_211] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.10.jar:5.3.10] 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) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.10.jar:5.3.10] 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) ~[spring-aop-5.3.10.jar:5.3.10] at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) ~[?:?] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.10.jar:5.3.10] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.10.jar:5.3.10] at com.sun.proxy.$Proxy1353.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

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

Is there any body know which table this plugin try to insert/update ?

[Tuncay Senturk]

Hi @Yong Xin Choon 

I'd suggest raising a ticket here for the fastest support.