Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,186
Community Members
 
Community Events
165
Community Groups

Migrate from Mysql 8.0.25 to 8.0.29 - Collation error

Edited

Hello,

my old Jira installation was on Debian 9 with Mysql 8.0.25 and all worked fine.

 

I exported the DB with dump to SQL file, installed a fresh Debian 11 with Mysql 8.0.29 (8.0.25 not available on Debian 11) and imported it in the new database created using this help https://confluence.atlassian.com/jiracore/connecting-jira-to-mysql-8-0-1018272102.html

Jira start but i have the error "

The table collation: 'utf8_bin' is unsupported by Jira. The Database collation: 'utf8mb4_bin' is supported by Jira." but the database on the new user is correctly configured.

2022-05-07 11_55_56-Troubleshooting and support tools - Jira.png

I checked with this command : 

mysql> use jiradb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_bin |
+--------------------------+----------------------+
1 row in set (0.00 sec)

 

What's wrong for you ?

I checked the same on the old server : 

Database changed
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb3 | utf8_bin |
+--------------------------+----------------------+
1 row in set (0.00 sec)

 

It's different but no error was showed.. 

Jira Service Management 4.20.2

Jira Software 8.20.2

Thank you for help.. 

Julian

1 answer

1 vote

I keep getting this one wrong myself.

There are three collation settings you need to check, not just the two you've given us here.

I think you'll get something like the below, where you'll find the bold one is wrong!

mysql> select @@character_set_database, @@collation_database, @@character_set_server ;
+--------------------------+----------------------+------------------------+
| @@character_set_database | @@collation_database | @@character_set_server |
+--------------------------+----------------------+------------------------+
| utf8mb4 | utf8mb4_bin | utf8 |
+--------------------------+----------------------+------------------------+

If that's the case, you've missed one of the settings mentioned in the database setup doc you've linked to.

Hello Nic! 

Here the result :

mysql> use jiradb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select @@character_set_database, @@collation_database, @@character_set_server ;
+--------------------------+----------------------+------------------------+
| @@character_set_database | @@collation_database | @@character_set_server |
+--------------------------+----------------------+------------------------+
| utf8mb4 | utf8mb4_bin | utf8mb4 |
+--------------------------+----------------------+------------------------+
1 row in set (0.00 sec)

Is it correct? 

 

Thank you 

Hello,

 

any news?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

492 views 3 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you