Bamboo: Charset and collation health check fails with no helpful information

[Ali Jabir]

Hi,

I am using dockerized bamboo-server on EC2 instance with Mysql 5.7 RDS as a database.

On the UI I constantly get the following popups:

When I click on the "Find out more" link, it takes me to the following page:

Here I don't see any details or helpful information.

On the database I see the following variables configured:

+--------------------------+-------------------------------------------+
| Variable_name             | Value |
+--------------------------+-------------------------------------------+
| character_set_client      | utf8mb4 |
| character_set_connection  | utf8mb4 |
| character_set_database    | utf8 |
| character_set_filesystem  | binary |
| character_set_results     | utf8mb4 |
| character_set_server      | utf8 |
| character_set_system      | utf8 |
| character_sets_dir        | /rdsdbbin/mysql-5.7.26.R1/share/charsets/ |
+--------------------------+-------------------------------------------+
+----------------------+--------------------+
| Variable_name         | Value |
+----------------------+--------------------+
| collation_connection  | utf8mb4_general_ci |
| collation_database    | utf8_general_ci    |
| collation_server      | utf8_general_ci    |
+----------------------+--------------------+

Could someone please help me fix this issue?

Thanks
Ali

[Foong]

As mentioned in the Support Issue, use the following SQL query to check it:

SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,  information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA  WHERE CCSA.collation_name = T.table_collation  AND T.table_schema = '<databaseName>' AND character_set_name != 'utf8';
SELECT T.TABLE_NAME, C.COLLATION_NAME FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = '<databaseName>' AND C.COLLATION_NAME != 'utf8_bin';

For the fix, can refer to How to Fix the Collation and Character Set of a MySQL Database