-
Bug
-
Resolution: Fixed
-
High (View bug fix roadmap)
-
8.0.0, 8.0.1
-
8
-
45
-
Severity 3 - Minor
-
12
-
Summary
With https://jira.atlassian.com/browse/JRASERVER-36135 we began officially supporting the MySQL 5.7 with the utf8mb4 collation.
The documentation can be found here: Connecting Jira applications to MySQL 5.7
However, using this supported platform in Jira 8 still prompts the following Health Check warning:
Your mysql database is currently using an unsupported collation: utf8mb4_bin. You should change this to a supported collation: utf8_bin
Environment
- Jira 8.0
- MySQL 5.7 using utf8mb4_bin as outlined in Connecting Jira applications to MySQL 5.7
Steps to Reproduce
- Install Jira 8
- Set database-type to mysql in dbconfig.xml (
this is not correct ) - Setup MySQL 5.7 as outlined in Connecting Jira applications to MySQL 5.7
Expected Results
Jira 8 runs using the supported database collation without errors.
Actual Results
The following error is thrown on startup:
Your MySQL database is currently using an unsupported collation: utf8mb4_bin. You should change this to a supported collation: utf8_bin
Screenshot:
Fix
To resolve the issue, you can run config.sh/bat to update your dbconfig.xml, or manually change database-type from mysql to mysql57 in your dbconfig.xml file.
This is discussed in Connecting Jira applications to MySQL 5.7
Only works in JIRA 8.
- is related to
-
-
- Closed
-
- relates to
-
HL-1915 You do not have permission to view this issue
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JRASERVER-68926] MySQL 5.7 running utf8mb4_bin throws Health Check error
Atlassian,
I see this error on 8.13.0 after updating from 7.13.
Workaround:
edit dbocnfig.xml as below;
<database-type>mysql57</database-type>
This bug is resolved. It was actually a documentation bug. To resolve the issue, you can run config.sh/bat to update your dbconfig.xml, or manually change database-type from mysql to mysql57.
This is discussed in Connecting Jira applications to MySQL 5.7
tbartyzel can you please close this ticket when you update DOC 
Cheers,
Marcin
https://getsupport.atlassian.com/browse/GHS-143862
https://getsupport.atlassian.com/browse/GHS-143632
https://getsupport.atlassian.com/browse/GHS-142465
https://getsupport.atlassian.com/browse/GHS-140101
I see the same error when upgrading from 7.13 to 8.13.10, although collation-server is in fact set to utf8mb4_bin and <database-type>mysql57</database-type> is set in dbconfig.xml
Addendum:
It turned out that, while the database server's default collation was correct, the database collation was still wrong. Fixed that, then the warning was gone.