MySQL error during install: Your database must use 'READ-COMMITTED' as the default isolation level.

Question

I am using cloud database, which doesn't support to set 'READ-COMMITTED'. Can I have any workaround to fix this issue?

Shannon S · Answer

Inkul, thank you for providing the steps to resolve your issue!

I found the same is listed at the below article, in case anyone wants to see the full set of steps to correct it:

* Confluence fails to start and throws 'MySQL session isolation level 'REPEATABLE-READ' is no longer supported' error

The steps are available under Resolution.

Thank you again for pointing that out.

Regards,

Shannon

inkul lee · Answer

check file 'my.cnf' need to insert under codes...

[mysqld] ... transaction-isolation=READ-COMMITTED ...

Shannon S · Answer

Hi Jilong Sun,

If you intend to use MySQL as your database server, then you will absolutely need to make sure that you meet all the requirements at Database Setup for MySQL, including the READ-COMMITTED isolation level. If it doesn't meet these requirements then it won't work properly with Confluence.

I'm not sure what you mean by cloud database, but you will want to talk to your provider and see if you can meet those requirements, or else use a different database type.

Regards,

Shannon