Mysql – Migrate Jira to MySql – Unknown system variable ‘storage_engine’

jiraMySQL

I'm trying to setup Jira on a vm.
I want to move from the embedded H2 database to my own mysql database.

I'm currently running mysql 5.7.x on ubuntu 16.04. However when I try to connect Jira with this server I get the following error message:

Unknown system variable 'storage_engine'

I already tried a number of things to fix this. First off in my mysql.cnf file I added default-storage-engine = InnoDB This didn't do anything for the error.

On my Jira vm I went into /opt/atlassian/jira/atlassian-jira/WEB-INF/classes/database-defaults

and changed it to

databaseUrl=jdbc:mysql://localhost/jira?autoReconnect=true&characterEncoding=utf8&useUnicode=true&sessionVariables=default-storage-engine=InnoDB

as well as

databaseUrl=jdbc:mysql://localhost/jira?autoReconnect=true&characterEncoding=utf8&useUnicode=true

Again nothing changed for the error.
I also went into the dbconfig.xml file and removed the sessionVariables=storage-engine=InnoDB part from the url. Again this didn't change anything.

I've also tried changing it to sessionVariables=default-storage-engine=InnoDB

Again no luck.

Does anyone have an idea how to get it to work? I don't want to create another sql setup just to run sql 5.6.x to be honest. I hope someone knows the solution to this.

Best Answer

This question is answered in the atlassian community website.

The workaround is to uninstall MySQL 5.1 and install MySQL 5.6