Patch #39592
closed
Set transaction isolation level of MySQL to READ-COMMITTED in database.yml.example
Added by Go MAEDA about 1 year ago.
Updated about 1 year ago.
Description
Due to bug fix #39437, you have to set your MySQL server's transaction_isolation level to READ-COMMITTED. Detailed information about this requirement can be found in the MySQL configuration documentation.
To ensure this critical configuration is not overlooked, I propose updating config/database.yml.example with explanatory comments. The attached patch includes these suggested comments and makes the necessary configuration more visible.
Files
I'm not sure if we should add it as you proposed or comment it out. Any other opinions?
On way or another, I will include this change before releasing the new versions.
I think it is even better to update doc/INSTALL as well.
diff --git a/doc/INSTALL b/doc/INSTALL
index 1487b8317..2e34eb0c1 100644
--- a/doc/INSTALL
+++ b/doc/INSTALL
@@ -86,6 +86,26 @@ The current version of Firefox, Safari, Chrome, Chromium and Microsoft Edge.
Go to "Administration" to load the default configuration data (roles,
trackers, statuses, workflow) and to adjust the application settings
+== Database server configuration
+
+When using MySQL with Redmine 5.0.1 or later, it is necessary to change
+the transaction isolation level from the default REPEATABLE READ to
+READ_COMMITTED. To modify this setting, either change the database
+configuration file or alter the settings on your MySQL server.
+
+To set the transaction isolation level in the database configuration file,
+add transaction_isolation variable as below:
+
+ production:
+ adapter: mysql2
+ database: redmine
+ host: localhost
+ [...]
+ variables:
+ transaction_isolation: "READ-COMMITTED"
+
+More details can be found in https://www.redmine.org/projects/redmine/wiki/MySQL_configuration.
+
== SMTP server Configuration
Copy config/configuration.yml.example to config/configuration.yml and
- Status changed from New to Closed
Changes committed as part of #39737.
- Target version deleted (
5.1.1)
Also available in: Atom
PDF
Updated by 
Updated by