Jira doesn't start after the upgrade due to the "Only one result is allowed for fetchOne" calls error

Problem

Jira doesn't start after the upgrade and it throws an error regarding some plugins and multiple records in the database tables:

2024-04-21 10:26:42,739+0000 ThreadPoolAsyncTaskExecutor::Thread 1 ERROR      [o.e.g.b.e.internal.support.ExtenderConfiguration] Application context refresh failed (NonValidatingOsgiBundleXmlApplicationCon
text(bundle=com.atlassian.analytics.client, config=osgibundle:/META-INF/spring/*.xml))
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'productInformation' defined in OSGi resource[classpath:com/atlassian/analytics/client/logger/AnalyticsLoggerConfigura
tion.class|bnd.id=12|bnd.sym=com.atlassian.analytics.client]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [
com.atlassian.analytics.client.properties.ProductProperties]: Factory method 'productInformation' threw exception; nested exception is com.atlassian.cache.CacheException: com.querydsl.core.NonUniqueResultE
xception: Only one result is allowed for fetchOne calls
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:633)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:929)
        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: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.atlassian.analytics.client.properties.ProductProperties]: Factory method 'productInformation' threw exception; ne
sted exception is com.atlassian.cache.CacheException: com.querydsl.core.NonUniqueResultException: Only one result is allowed for fetchOne calls
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:648)
        ... 19 more
Caused by: com.atlassian.cache.CacheException: com.querydsl.core.NonUniqueResultException: Only one result is allowed for fetchOne calls
        at com.atlassian.cache.ehcache.DelegatingCache.get(DelegatingCache.java:114)
        at com.atlassian.cache.impl.metrics.InstrumentedCache.get(InstrumentedCache.java:72)
        at com.atlassian.jira.cache.stats.CacheWithStats.get(CacheWithStats.java:46)
        at com.atlassian.jira.config.properties.v2.DefaultCachingApplicationPropertiesManager.get(DefaultCachingApplicationPropertiesManager.java:93)
        at com.atlassian.jira.config.properties.v2.ApplicationPropertiesBackedPropertySet.get(ApplicationPropertiesBackedPropertySet.java:41)
        at com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305)
        at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:251)
        at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:59)
        at com.atlassian.jira.license.MultiLicenseStoreImpl.retrieveServerId(MultiLicenseStoreImpl.java:94)
        at com.atlassian.jira.license.JiraLicenseManagerImpl.getServerId(JiraLicenseManagerImpl.java:79)
        at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.getServerId(JiraLicenseServiceImpl.java:76)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

One of the scenarios is when there are multiple records of jira.sid.key values in the propertyentry table. The root cause is unknown.

10102,jira.properties,1,jira.sid.key,5
10103,jira.properties,1,jira.sid.key,5

Resolution  

Remove one of the records (it doesn't matter which one) and restart Jira:

delete propertyentry where id= 10103;
Last modified on May 14, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.