-
Bug
-
Resolution: Fixed
-
Medium (View bug fix roadmap)
-
None
-
7.3.0, 7.3.1
-
7.03
-
9
-
Severity 3 - Minor
-
4
-
Summary
JIRA 7.3.x startup logs have this warning:
2017-02-15 20:09:18,384 JIRA-Bootstrap WARN [c.a.j.appconsistency.db.MySqlConnectionUrlCheck] You have an error in your dbconfig.xml file. Missing "default_storage_engine" in connection url. The "storage_engine" parameter is deprecated and should be replaced with "default_storage_engine".Please refer to the https://docs.atlassian.com/jira/jadm-docs-073/Connecting+JIRA+applications+to+MySQL. 2017-02-15 20:09:20,136 JIRA-Bootstrap INFO [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.
The dbconfig.xml has the entry of:
<url>jdbc:mysql://127.0.0.1:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB</url>
The problem is that the warning log is pointing users to Connecting JIRA applications to MySQL - Atlassian Documentation But that documentation does not explicitly tell users how/where to use the new "default_storage_engine" variable. it is still using the previous 'storage_engine' in all examples and explanations there. I suspect that this replaces the previous/deprecated 'storage_engine', but this document should be updated to reflect the correct settings for JIRA 7.3.x, and update the sample dbconfig.xml on that document.
Environment
- JIRA 7.3.x and above
- MySQL database
Steps to Reproduce
- Set up JIRA 7.3.x to run with MySQL database as per Connecting JIRA applications to MySQL - Atlassian Documentation.
- Check the log file during JIRA startup.
Expected Results
JIRA is started with no warning or error for the database connection.
Actual Results
The below exception is thrown in the atlassian-jira.log file:
2017-02-15 20:09:18,384 JIRA-Bootstrap WARN [c.a.j.appconsistency.db.MySqlConnectionUrlCheck] You have an error in your dbconfig.xml file. Missing "default_storage_engine" in connection url. The "storage_engine" parameter is deprecated and should be replaced with "default_storage_engine".Please refer to the https://docs.atlassian.com/jira/jadm-docs-073/Connecting+JIRA+applications+to+MySQL. 2017-02-15 20:09:20,136 JIRA-Bootstrap INFO [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.
Workaround
Edit the database URL to:
<url>jdbc:mysql://127.0.0.1:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB</url>
Replace storage_engine to default_storage_engine.
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JRASERVER-64178] update JIRA 7.3 connecting to MySQL database documenation around 'default_storage_engine'
| Minimum Version | New: 7.03 |
| Workflow | Original: JAC Bug Workflow v2 [ 2847054 ] | New: JAC Bug Workflow v3 [ 2918841 ] |
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Symptom Severity | Original: Minor [ 14432 ] | New: Severity 3 - Minor [ 15832 ] |
| Workflow | Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2587833 ] | New: JAC Bug Workflow v2 [ 2847054 ] |
| Workflow | Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1652594 ] | New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2587833 ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Verified [ 10005 ] | New: Resolved [ 5 ] |
| UIS | Original: 5 | New: 4 |
| Support reference count | Original: 7 | New: 9 |
| UIS | Original: 3 | New: 5 |
| Rank | New: Ranked higher |
| Sprint | New: Sprint 40 [ 4762 ] |