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 vote
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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

11,799 views 13 13
Join discussion

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