Jira upgrade 6.3.7 issue


We have upgraded JIRA from 6.0.7 to 6.3.7. After upgrade JIRA didn't startup.

This error was showing :-

Error occurred while starting component 'com.atlassian.jira.service.DefaultServiceManager'. caused by: Error creating underlying Quartz scheduler

Please help us in resolving this issue.

2 answers

0 votes
Boris Berenberg Community Champion Oct 06, 2014

We would need to see more of the error to understand what went wrong. Please collect the logs manually by going to <JIRA_INSTALL>/logs and <JIRA_HOME>/log combining all the logs into one zip file. Then send us the same thing as what you wrote above, and those logs to support@atlassian.com

I received the same error when upgrading to this version.

When I looked in <jiraHome>/log/atlassian-jira.log I saw several entries like:

2014-10-22 09:30:43,965 localhost-startStop-1 ERROR      
[core.entity.jdbc.DatabaseUtil] Could not create table 
2014-10-22 09:30:43,965 localhost-startStop-1
 ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while 
executing the following:
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
Our db was set to use utf8 with myisam tables.
myisam has a 1000 bytes total limit for a key
utf8 uses up to 3 bytes per character
when calculating requirements for keys mysql assumes the worst (ie 3 bytes per character)
the key lengths in that table total 400 characters, ie 1200 bytes

Resolution (for us):
Stop Jira
Modify the database schema to use innodb tables as per the recommendations on the Atlassian website.
(we did this by dumping the whole db to a file, using find/replace, dropping the db, then re-importing it)
Modify <jiraHome>/dbconfig.xml to include



as per the instructions at https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL

Start Jira


if your log doesn't show those same entries then this probably isn't the course of action for you, but I hope it is and that you can get running again.


:- Dave

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

628 views 0 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you