On ubuntu after upgrade MySQL session isolation level 'REPEATABLE-READ' is no longer supported. Sess

[Ralf Thmas]

Hello,

after Upgrade Jira . It is not tarting now . I get this message

MySQL session isolation level 'REPEATABLE-READ' is no longer supported. Session isolation level must be 'READ-COMMITTED'. See http://confluence.atlassian.com/x/GAtmDg

when i connect by Browser.

Here is how to solve. But for Windows https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html

How can i fix this in Ubuntu ?

Greets

Ralf

[Nic Brough -Adaptavist-]

It's the same as the windows doc says, but on Linux, your my.cnf file could be in one of several places, depending on how you installed your mysql service.

Consult the docs for your install of mysql (although if you want to skip that, or you're not sure, start by searching /etc and /usr for a my.cnf file)

[Ralf Thmas]

ok i found this file . Make Entry. Now reboot.

Now this appear after restart:

HTTP Status 500 – Internal Server Error

---

Type Exception Report

Message An exception occurred processing [errors.jsp] at line [13]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [errors.jsp] at line [13]

10:     <link rel="shortcut icon" href="johnson/fav-confluence.ico">
11:     <%
12:         JohnsonPageI18NProvider johnsonPageI18NProvider = (JohnsonPageI18NProvider) BootstrapUtils.getBootstrapContext().getBean("johnsonPageI18NProvider");
13:         String translations = johnsonPageI18NProvider.getTranslations().serialize();
14:     %>
15:     <script>
16:         window.i18n = <%=translations%>;

[Nic Brough -Adaptavist-]

Check the logs for the rest of the error.

My guess is that it will end with a "can't talk to your database" type error, but there is no way to be sure about that without reading the logs.