Confluence server no longer works from my Linux server.

[Steven John Kirner]

I currently have Confluence v.5.9.6/MySQL v.5.1.73 running on my old Linux 2.6 desktop. After manually stopping MySQL services and making database dump, I can no longer connect to my Confluence server online. I get the following error:

"MySQL isolation level could not be read. Isolation level must be 'READ-COMMITTED'. See http://confluence.atlassian.com/x/GAtmDg"

I have tried manually starting the services and rebooting my Linux desktop.

[AnnWorley]

Hi Steven,

You may set the isolation level two different ways as described in: Confluence fails to start and throws 'MySQL session isolation level 'REPEATABLE-READ' is no longer supported' error

Please set it to READ-COMMITTED and let us know if Confluence starts as expected.

Thanks,

Ann

[Steven John Kirner]

Hi Ann,

Thanks for the prompt reply. I checked the "my.cnf" file and it was already set to READ-COMMITTED.

Any other ideas that could be causing this? 

Thanks

[AnnWorley]

That is interesting. I noticed the error you are seeing is not "REPEATABLE-READ is no longer supported" but rather "MySQL isolation level could not be read". I am not sure why Confluence would suddenly be unable to determine the isolation level after MySQL and Confluence were both restarted. I found some support tickets where that error was reported and in most cases the MySQL server was overloaded, had been upgraded incompletely or was not allowing connections for some reason.

Please check the log <confluence_home>/atlassian-confluence.log for errors indicating a connection could not be acquired from the database. You may also diagnose the connection and access by using another database management tool (DbVisualizer is a good free option we use) using the URL, username and password from <confluence_home>/confluence.cfg.xml.

Please also check your MySQL logs to make sure all is well with the MySQL instance.

For the sake of others on the Community I would like to mention that you are using an unsupported version of MySQL for Confluence 5.9.x but am not belaboring that in this thread as I mentioned it already on: Need help transferring and setting up MySQL/Confluence on new Windows server