Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Will Disabling Autocommit in the MySQL Database Adversely Affect Crowd?

Lorenzo Raras
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?

Answer
Watch
Like Be the first to like this
350 views

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
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.
Become a leader
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.

View More Comments
Lorenzo Raras
Lorenzo Raras August 14, 2023

Thank you very much!

Like
Reply

Suggest an answer

Log in or Sign up to answer
Crowd
Crowd
TAGS
AUG Leaders

Atlassian Community Events

    See all events