error integrity check following update and server change

[Monizze IT]

Hello,

I recently migrate our jira to a new server (upgrade from version last 7.x to 8.0.2).

I got several issue

• no reindex possible (and no log error)
• when I try to check integrity, I see some technical error
• when I check to instance health I see one error related to attachment and the other are warning
• When I analyse log I found some error

Troubleshooting guide

Log analysis

ERROR Integrity checker preview breaks when issues have missing workflows Fixed in 6.0.7 12 hours ago 5 matches, last match on line 47916
ERROR 'Cannot get schemes for null project' Error During Integrity Check 12 hours ago 6 matches, last match on line 47656
ERROR Integrity Checker throws exception when running complete test
12 hours ago 2 matches, last match on line 47656

integrity checker

[Monizze IT]

checker log https://gist.github.com/Grummfy/6d7e441b036e2d5be06f6e692be13ce1

[Alexander Pappert]

can you manually delete all index files and then try to start indexing?

[Monizze IT]

already tried, it still in the same state ;(

[Alexander Pappert]

what is with chapter Changes to indexing

https://confluence.atlassian.com/jirasoftware/jira-software-8-0-x-upgrade-notes-957981660.html

[Monizze IT]

yes, the directory was created, but still got the same issue.

Thanks

[brbojorque]

Hi @Monizze IT , it looks like you have an old MySQL driver for the database. Please view the compatibility of MySQL for JIRA 8. 

If this doesn't help try to find an updated MySQL version for Jira 8 and perform the migration again.

[Monizze IT]

I got the last version from the website of mysql ;)

For now I drop this migration and will wait a bit