How to setup transaction-isolation under aurora db on aws

Karan Zaveri August 2, 2018

We are trying to setup confluence over to an AWS instance, and using aurora as db backend.

When we run the installation of confluence, it complains about the value of transaction-isolation. 

Incorrect isolation level

Your database must use 'READ-COMMITTED' as the default isolation level. Learn more

The link specifies changes in mysql config or in confluence config both of which cannot be implemented due to following reasons - we don't have access to modify aurora config file, and the confluence config file doesn't have the entries as mentioned in the link.

How can we setup the value in aurora ?

 

Thanks

 

1 answer

0 votes
Karan Zaveri August 2, 2018

I created an options group, and added single entry for the tx_isolation in it, and then modified the aurora instance and assigned the group to it.

However still the READ-COMMITED is not implemented.

 

MySQL [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;

+-----------------------+-----------------+

| @@GLOBAL.tx_isolation | @@tx_isolation  |

+-----------------------+-----------------+

| REPEATABLE-READ       | REPEATABLE-READ |

+-----------------------+-----------------+

1 row in set (0.00 sec)

Matt Vermeulen March 24, 2020

Did you ever find a solution to this?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events