Users complaining missing data after move to MYSQL ver8 and upgraded to v8.22.3

Bill Hoffman_e5vu13

Users are complaining that data is missing After we migrated off of H2 database to MySQL8

Before we could migrated to MySQL8 I was forced to upgrade Jirsa to v8.22.3

All went as planed and restore worked without issues the only issue that still remains is listed below

The table collation: 'utf8_bin' is unsupported by Jira. The Database collation: 'utf8mb4_bin' is supported by Jira.

See below the reports I am receiving from users

 

We are missing the test cases performed for the each test case execution, as well as all the comments and information we had entered as text. Attachments and issue links are still there.

We noticed early this week that the RTM configuration had changed and was causing the app to no longer function, after solving the immediate issue with the help of the developer support, we noticed the data loss

 

Benjamin_tmh9yg

@Bill Hoffman ,

 

you need to update your Database and Table collation on Mysql. If you go to the troubleshoot and support page, it will have a link to direct you on how to fix it. It should be straight forward but you need to stop the jira server in order to make this change. Also, it should be done on a test server first as you are making changes to the DB.

 

If you see the test cases in the DB, then the data is not missing. It just means it can't be read and it's probably because of the main issue which is your collation.

 

Thanks,

 

Ben