My Docker instance of Confluence 7.11.1 has failed to start correctly with the following error:
MySQL session isolation level 'REPEATABLE-READ' is no longer supported. Session isolation level must be 'READ-COMMITTED'. See http://confluence.atlassian.com/x/GAtmDg
I have checked the appropriate kb at https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html
Both my.cnf and the
confluence.cfg.xml were already set for the isolation level to be READ-COMMITTED.
I updated the JDBC string to include the sessionVariables parameter and restarted the instance.
The error still occurs - the strange thing is that nothing has changed since yesterday, when it was working fine.
Has anyone else experienced this?
@Milan Chheda [INFOSYSTA]Thanks for your reply - I had added that setting in my.cfg.
I discovered the issue - I had changed the file permissions on the my.cfg such that it couldn't be read by MySQL when starting up.
Strangely even having the setting in confluence.cfg.xml or adding the change to the JDBC didn't overrule the my.cfg.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
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