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

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

Leinad July 12, 2019

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 answer

0 votes
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 15, 2021

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

image.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events