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

Will Disabling Autocommit in the MySQL Database Adversely Affect Crowd?

Lorenzo Raras August 14, 2023

We have a Crowd 5.0 instance and a Jira 9.1 instance connected to it.  Their databases are both hosted in the same MySQL instance.

We recently upgraded to MySQL 8.0 and everything seems to be functioning normally.  However, in the documentation here, it specifies that Jira requires the "autocommit" field in the my.cnf to be set to false.  In the documentation here, it does not specify to disable that setting explicitly when configuring the database for Crowd.

Will having autocommit turned off in the database adversely affect Crowd in any way?

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 14, 2023

Welcome to the Atlassian Community!

No, it needs to be set that way, otherwise you may find you get deadlocks in the database, which will stop people from logging in.  It won't happen often, and the symptom is a hung login, which the users can refresh the page and probably be able to log in again, but it can happen.

Lorenzo Raras August 14, 2023

Thank you very much!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events