Configuring MySQL 5.7 Database with JIRA 7.2.x or below throws 'Error connecting to database Unknown system variable 'storage_engine' error
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
While performing a new install of JIRA 7.2.x or below, configuring a database connection to MySQL 5.7 fails. The following is shown in the JIRA UI:
The following appears in the atlassian-jira.log
2016-12-16 11:50:36,491 http-nio-8080-exec-5 ERROR anonymous 710x5x1 1o5lhsl 127.0.0.1 /secure/SetupDatabase.jspa [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
java.sql.SQLException: Unknown system variable 'storage_engine'Diagnosis
Environment
- JIRA 7.2.x or below
- MySQL 5.7 or above
Cause
The storage_engine system variable was deprecated in MySQL 5.6 and removed in MySQL 5.7 (for more information see Removal and Deprecation in MySQL 5.7). JIRA 7.2.x and below is hard coded to append the storage_engine variable to the JDBC URL connection strings, one reason why JIRA 7.2.x and below does not support MySQL 5.7.
Resolution
- Upgrade to JIRA 7.3 or above as these versions support MySQL 5.7.
- If you need to be on JIRA 7.2 or below, downgrade your database to MySQL 5.6.x