JIRA throws Could not determine database type Unknown storage engine InnoDB when starting
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
When starting up JIRA the following error appears when attempting to access the application:
The following appears in the atlassian-jira.log:
org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Unknown storage engine 'InnoDB')Cause
In this case, after updating the innodb_log_file_size there was a missed step(ie. removing the existing transaction logs) in the procedure causing problems when starting MySQL.
Resolution
For further explanation on common problems when setting the innodb_log_file_size, please read MySQL: Failed Registration of InnoDB as a Storage Engine.
Please refer to MySQL documentation for more details on InnoDB options and parameters: InnoDB Startup Options and System Variables