When starting confluence service, an error about MySQL session isolation level was raised

Yong Yang

This Exception is as follows:

 

MySQL session isolation level 'REPEATABLE-READ' is no longer supported. Session isolation level must be 'READ-COMMITTED'.

 

I know the resolution is as follows, but I don't know why the db config was changed. Could anyone to figure it out? Thanks.

-- 解决办法：
-- 查看InnoDB会话级别的事务隔离级别：
@tx_isolation;
-- 修改事务隔离级别：
set global transaction isolation level read committed;
set session transaction isolation level read committed;

 

Srinatha Tondihal

Hi @Yong Yang ,

Welcome to Atlassian community. 

Yes, as rightly pointed out by @Nic Brough -Adaptavist- you should change it to read-committed. Actually we have a detailed KB regarding the same. You can go through the below page.

• Confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error 

I hope above info helps. Have a good weekend.!

Thanks,

Srinath T