upgrade path

[Sam Issa]

Greetings,

Can I upgrade from 8.5.1 to 8.22.4 in one step ?

[Mayur Jadhav · Accepted solution]

Hi @Sam Issa ,

Yes, you can upgrade, but you need to check all the add-on compatibility with your target version.

Atlassian has created a very detailed pre-upgrade checklist, which I would recommend follow.

• Preparing for the upgrade
• Upgrading Jira applications

Note: Please first perform the upgrade in your non-production environment and perform the testing before going for a production upgrade.

Cheers,
Mayur

[Sam Issa]

Thanks Mayur, upgrade went ok, except I has an issue with Zephyr, waiting on their support to respond.

[Mayur Jadhav]

@Sam Issa   glad to know, hope you have checked the add-on compatibility??

[Sam Issa]

yes I did, Zephyr installed ok, showing all modules ok, but when trying to use search test plans it errors out.

not sure is this stack dump means much to anyone :

Error

{"message":"bundle [com.thed.zephyr.je]","status-code":500,"stack-trace":"com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.thed.zephyr.je]\r\n\tat com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)\r\n\tat com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86)\r\n\tat com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38)\r\n\tat java.base/java.util.concurrent.FutureTask.run(Unknown Source)\r\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\r\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\r\n\tat java.base/java.lang.Thread.run(Unknown Source)\r\nCaused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:\nDatabase:\n\t- name:MySQL\n\t- version:5.7.36\n\t- minor version:7\n\t- major version:5\nDriver:\n\t- name:MySQL Connector/J\n\t- version:mysql-connector-java-8.0.28 (Revision: 7ff2161da3899f379fb3171b6538b191b1c5c7e2)\n\njava.sql.SQLSyntaxErrorException: REFERENCES command denied to user 'jirauser'@'localhost' for table 'ao_7deabf_defect_configuration'\r\n\tat com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54)\r\n\tat com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:73)\r\n\tat com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)\r\n\tat com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:50)\r\n\tat jdk.internal.reflect.GeneratedMethodAccessor316.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)\r\n\tat com.sun.proxy.$Proxy621.doInTransaction(Unknown Source)\r\n\tat jdk.internal.reflect.GeneratedMethodAccessor316.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:130)\r\n\tat com.sun.proxy.$Proxy621.doInTransaction(Unknown Source)\r\n\tat com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)\r\n\tat jdk.internal.reflect.GeneratedMethodAccessor327.invoke(Unknown Source)\r\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.base/java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\r\n\tat org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)\r\n\tat org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n\tat org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)\r\n\tat org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n\tat org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n\tat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)\r\n\tat com.sun.proxy.$Proxy1229.execute(Unknown Source)\r\n\tat com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:70)\r\n\tat com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)\r\n\tat com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91)\r\n\t... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: REFERENCES command denied to user 'jirauser'@'localhost' for table 'ao_7deabf_defect_configuration'\r\n\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n\tat com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n\tat com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335)\r\n\tat com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2084)\r\n\tat com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1246)\r\n\tat org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)\r\n\tat org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)\r\n\tat net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2319)\r\n\tat net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2375)\r\n\tat net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2347)\r\n\tat net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:91)\r\n\tat net.java.ao.EntityManager.migrate(EntityManager.java:132)\r\n\tat com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52)\r\n\t... 43 more\r\n"}