Unknown system variable 'default_storage_engine' when attempting to connect to MySQL 5.1.73 and JIRA 7.3


Attempting a fresh install of MySQL 5.1.73 and JIRA 7.3. Both are running on their own instance of Redhat Linux 6.7

I have installed and setup MySQL and JIRA as per the JIRA guide, placing the mysql-connector-java-5.1.41-bin.jar in atlassian/jira/lib

My my.cnf looks like below:






# Disabling symbolic-links is recommended to prevent assorted security risks










 And the JIRA error I get when going through setup is (JIRA forums failed to let me upload an image):

Error connecting to database

Unknown system variable 'default_storage_engine'


I've tried replacing the - with _ but it made no difference. I don't have a dbconfig.xml yet as I haven't managed to get through the JIRA setup.

My mysql.properties file contains the following line:


which I've tried removing the storage_engine variable from the URL and also renaming to default_storage_engine but this both changes made no difference.


The catalina.out log file has this as the last error:


2017-03-31 05:32:26,408 http-nio-8080-exec-8 ERROR anonymous 332x6x1 6ho9xv xx.xx.xx.xxx/secure/SetupDatabase!connectionCheck.jspa [c.a.config.bootstrap.DefaultAtlassianBootst$

java.sql.SQLException: Unknown system variable 'default_storage_engine'

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)

        at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540)

        at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2595)

        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1468)

        at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:4999)

        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3212)

        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2249)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

        ... 3 filtered

        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)

        at java.sql.DriverManager.getConnection(DriverManager.java:664)

        at java.sql.DriverManager.getConnection(DriverManager.java:247)

        at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:347)

        at com.atlassian.jira.config.database.JdbcDatasource.getConnection(JdbcDatasource.java:211)

        at com.atlassian.jira.config.database.DatabaseConfig.testConnection(DatabaseConfig.java:87)

        at com.atlassian.jira.web.action.setup.SetupDatabase.testConnection(SetupDatabase.java:225)

        at com.atlassian.jira.web.action.setup.SetupDatabase.doValidation(SetupDatabase.java:189)

        at com.atlassian.jira.web.action.setup.SetupDatabase.doConnectionCheck(SetupDatabase.java:121)

        ... 3 filtered

        at java.lang.reflect.Method.invoke(Method.java:498)

        at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)

        at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)

        ... 2 filtered

        at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)

        ... 7 filtered

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

        ... 49 filtered

        at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:80)

        ... 1 filtered

        at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:78)

        ... 28 filtered

        at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)

        ... 27 filtered

        at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)

        ... 28 filtered

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:745)


Now I know there is an issue with MySQL 5.7 and JIRA 7 relating to this, but this is MySQL 5.1.73. There was another post on here a few weeks relating to the exact same issue but the trail went cold so thought I'd post a new post as this is blocking everything for me right now.


 Any help greatly appreciated.




2 answers

1 accepted

0 votes
Accepted answer

I gave up on this, must be some incompatibility between these versions.

For anyone else who stumbles across this issue, the way I got round it was to uninstall MySQL 5.1 and install MySQL 5.6 and everything worked as it was meant to.

I believe the problem stemmed from the default yum repository that ships with Redhat 6 Enterprise. I followed the steps at this link https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/ to update the yum repository and then revert to defaulting to MySQL 5.6 (rather than the default which is MySQL 5.7). I installed everything as the rest of the link above instructs, and then continued to setup as per JIRA instructions and everything worked first time.  


The name of the variable containing the "Default Storage Engine" changed between MySQL 5.5.3 and 5.7.5 . 

Before 5.5.3, there was only "storage_engine". Starting with 5.5.3, one could use both "storage_engine" and "default_storage_engine". Beginning with 5.7.5, only "default_storage_engine" remained.

BTW: The release date of MySQL 5.5.3 was 2010-03-24, that of MySQL 5.7.5 was 2014-09-25.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Statuspage

Introducing Statuspage Getting Started guides! First up: What is Statuspage?

Over the next several weeks we'll be sharing some of our Getting Started guides here in the community. Throughout this series of posts, we'd love to hear from customers and non-customers ab...

21 views 2 1
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