Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,882
Community Members
 
Community Events
165
Community Groups

Change mysql configuration or add a Session Variable in the connection string

For a new installation of confluence, what do you this that can be a good solution, 

If this server ( MySQL ) is shared with Jira, Jira can be affected? 

Add to my.cnf this: 

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

or make the connection string like this : 

jdbc:mysql://127.0.0.1:3306/confdb?sessionVariables=tx_isolation='READ-COMMITTED'

Ref : 

https://ja.confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html

1 comment

That one is ok. One minus is to have many commits

image.png

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

848 views 10 24
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