Can't use the MYSQL 8.0.19 as the Database

[l jj]

At the first, I install the jira8.5.6 with the default configuration, then I change database to MySql, failed, the Log always say:

com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FROM project ORDER BY pname (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 ', DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY, PROJECTTYPE FR' at line 1)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:92)
at com.atlassian.jira.project.CachingProjectManager.getProjects(CachingProjectManager.java:108)
at com.atlassian.jira.project.CachingProjectManager.getProjectObjects(CachingProjectManager.java:128)
at com.atlassian.jira.issue.fields.DefaultFieldManager.getAllFieldLayouts(DefaultFieldManager.java:482)
at com.atlassian.jira.issue.fields.DefaultFieldManager.getAllAvailableNavigableFields(DefaultFieldManager.java:167)
at com.atlassian.jira.issue.fields.layout.column.DefaultColumnLayoutManager.removeUnavailableColumnLayoutItems(DefaultColumnLayoutManager.java:385)
at com.atlassian.jira.issue.fields.layout.column.DefaultColumnLayoutManager.getEditableDefaultColumnLayout(DefaultColumnLayoutManager.java:143)
... 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.$Proxy471.getEditableDefaultColumnLayout(Unknown Source)
... 3 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
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:185)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
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:185)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy3382.getEditableDefaultColumnLayout(Unknown Source)
at com.atlassian.jira.plugin.devstatus.upgrade.UpgradeTask_Build01.runUpgrade(UpgradeTask_Build01.java:62)
at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.runOneUpgradeTask(DefaultUpgradeTaskFactoryProcessor.java:109)
at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.lambda$performUpgradesUnsafe$13(DefaultUpgradeTaskFactoryProcessor.java:80)
at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:174)
at java.util.stream.SortedOps$RefSortingSink.end(SortedOps.java:395)
at java.util.stream.Sink$ChainedReference.end(Sink.java:258)

 Second, I try to reinstall with the Mysql As the initial config. By the way, there is some wrong with your setup check: if I select mysql 5.7+, I can't continue; I have to select mysql 5.6(though really mysql8.0.19) to next step.      Then, the database init failed, the log looks similar as above.

To check the database,  the table "project" and "component", etc, don't exist. So, error always occurred.

[Daniel Ebers]

Hi,

MySQL 8.0.19 is not yet supported as of writing these lines. Jira version 8.5.6, which you are referring to, supports MySQL 5.7 though.

Cheers,
Daniel