Database error after Confluence upgrade

[IT Person1]

Upgraded Confluence server from 6.1.14 (MySQL 5.6) to 7.5.1 (MySQL 5.7).

Error when starting Confluence: "MySQL sesson isolation level "REPEATABLE-READ" is no longer supported. Session isolation level must be "READ-COMMITTED." [Words capitalized in the error]

MySQL Session isolation level is set to "read-committed"

Any suggestions would be appreciated. Thank you.

[Brant Schroeder]

This should help you make the changes to resolve the issue. https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html?_ga=2.170801448.945984502.1597437645-1624429102.1594443344

You will be running this SQL command for your mysql account that is used to connect to database

SET [SESSION | GLOBAL] TRANSACTION ISOLATION LEVEL READ COMMITTED

[IT Person1]

Thank you for the suggestion. We had seen that link. The MySQL Session isolation level is set to "read-committed" through the my.ini file.

Is there something else that needs to be done?

[Brant Schroeder]

No that should be it.  If that is setup properly and you bounced the service are you still seeing the same issue in the logs?   Is there anything else coming up?

[IT Person1]

The same thing happens even after restarting the server.