Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Erroneous 'REPEATABLE-READ' is no longer supported' error after upgrade - what is real error?

I was running Confluence 6.6.0, and I just attempted an upgrade to version 7.6.2 and I am now seeing this error - https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html .

According to that document, this is a problem that was in versions before 3.5.6, but my initial install was on version 5.9.  Also, I have checked the confluence.cfg.xml file (it was already configured as shown in the document) and I have done 2 attempts at forcing the change on the mysql side

mysql> SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
Query OK, 0 rows affected (0.00 sec)

and I have restarted the mysql server after each attempt (I even did a flush privileges the second time to see if I could force the change to be committed).  The confluence log is still showing the same error:

2020-08-09 05:19:25,980 ERROR [Catalina-utility-1] [atlassian.confluence.setup.BootstrapApplicationStartupListener] checkConfigurationOnStartup MySQL session isolation level 'REPEATABLE-READ' is no longer supported. Session isolation level must be 'READ-COMMITTED'. See http://confluence.atlassian.com/x/GAtmDg

so I am suspecting that it is misreporting the real error.  Has any one else encountered this issue to know what the real issue is?

2 answers

Please be aware that after following the instructions, the startup would have 2 long pauses that could be perceived as problems, but Confluence will come up.  

 

sudo vim /your_path/var/atlassian/application-data/confluence/logs/atlassian-confluence.log

2021-03-26 16:42:00,891 INFO [Catalina-utility-3] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Preparing to shut down the plugin system...2021-03-26 16:44:13,359 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.11.1 [build 8701 based on commit hash ...2021-03-26 16:46:08,056 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
0 votes
Shannon Atlassian Team Aug 11, 2020

Hi John,

Thank you for raising this with us here. 

The issue is not specific to versions before 3.5.6, and it still affects recent versions. The article states that versions 3.5 and prior were enforcing a transaction level, but past versions 3.5.6, it was possible to set your own.

The way that you will need to fix this in the more recent versions of Confluence is via the confluence.cfg.xml file. You mentioned that yours already matches the article, but could you tell me which example it matches? Note that you’ll need to use the fix that’s mentioned for new installations, which also includes configuring the JDBC string. You can take a look at the differences in settings for for MySQL 5.x vs 8.x.

In addition, in order to apply the changes, you’ll need to completely stop Confluence first, make the changes, and then start up Confluence again. A restart is usually not enough. It may also be useful to backup your database and configuration file.

If you continue to have issues, could you let me know what MySQL version you’re running, and how the configuration entry looks now? Please make sure to censor out any private information, but I just need to see how you have set the transaction isolation level.

Thank you!

Shannon

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.6
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

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...

1,381 views 7 29
Read article

Community Events

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

Events near you