Defect #29605
Redmine doesn't recover from DB timeouts with TinyTds and MS SQL
Status: | New | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | - | % Done: | 0% | |
Category: | Database | |||
Target version: | - | |||
Resolution: | Affected version: | 3.4.4 |
Description
From time to time Redmine fails with messages like:
ActiveRecord::StatementInvalid (TinyTds::Error: Adaptive Server connection timed out: EXEC sp_executesql N'SELECT [issues].* FROM [issues] WHERE [issues].[id] = @0 ORDER BY [issues].[id] ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY', N'@0 int', @0 = 489757)
This is most likely to happen in application_controller, issues_controller or projects_controller.
I'd expect Redmine to retry the request at least once after it has failed, but it doesn't seem to do so.
Current RM setting is:
Redmine version 3.4.4.stable Ruby version 2.3.5-p376 (2017-09-14) [x86_64-linux] Rails version 4.2.8 Environment production Database adapter SQLServer (TinyTds 1.0.5)