Issue Summary

Health Check for MySQL 8.0.29 fails after upgrading MySQL to 8.0.29.

Steps to Reproduce

1. Use Bamboo MySQL 8.0.23 or older versions
2. Upgrade MySQL to 8.0.29
3. Go to Troubleshooting and Support Tools >> Instance health page and see the fail health check for MySQL collation

Expected Results

The Health Check should pass in case MySQL version is 8.0.29 which has the utf8m3 as the new display name for uft8 collation:

The server now uses utf8mb3 in place of the alias utf8 for character set names when populating data dictionary tables from built-in character sets. This affects the display of character set and related information in the MySQL Information Schema tables listed here:

More information can be found on MySQL 8.0.29

Actual Results

The below error is thrown in the atlassian-bamboo.log file:

WARN [MySQLChecksImpl] query - SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA S WHERE schema_name = ? AND DEFAULT_CHARACTER_SET_NAME != 'utf8mb4' AND DEFAULT_CHARACTER_SET_NAME != 'utf8';
WARN [MySQLChecksImpl] found unexpected result: utf8mb3 | 
ERROR [SupportHealthCheckProcess] Health check 'Character Set' failed with severity 'critical': 'Some tables or columns in the database are not using utf8 for their character set, or the default character set for the database is incorrect.'

Workaround

Manually disable the Database Character Set Health Check on Troubleshooting and Support Tools >> Instance health page.