Actions
Patch #39592
closed
Set transaction isolation level of MySQL to READ-COMMITTED in database.yml.example
Start date:
Due date:
% Done:
0%
Estimated time:
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
Related issues
Updated by Marius BĂLTEANU about 1 year ago
- Category set to Database
I'm not sure if we should add it as you proposed or comment it out. Any other opinions?
Updated by Marius BĂLTEANU about 1 year ago
On way or another, I will include this change before releasing the new versions.
Updated by Go MAEDA about 1 year ago
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
Updated by Marius BĂLTEANU about 1 year ago
- Is duplicate of Patch #39737: Support MySQL 8 added
Updated by Marius BĂLTEANU about 1 year ago
- Status changed from New to Closed
Changes committed as part of #39737.
Actions