JIRA startup failed because 'Could not start Bamboo Release Management Plan' with SQL Syntax Error

[Taekyung Lee]

Hi,

My JIRA didn't start well after upgrading mysql dbms (5.7 to 8.0)

Any tips?

JIRA version: 8.6.1

DBMS : mysql 8.0

OS: ubuntu 19.10

LOG: atlassian-jira.log

2020-01-28 20:57:37,187+0900 Bamboo Release Management Startup ERROR [c.a.j.p.e.bamboo.service.BambooReleaseServiceImpl] Could not start Bamboo Release Management Plugin
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:116)
at com.atlassian.jira.project.CachingProjectManager.getProjectObjects(CachingProjectManager.java:136)

[Taekyung Lee · Accepted solution]

My Fault.

JIRA 8.6.1 do not support MySQL 8.0 yet.

I didn't catch that.