Actions
Defect #29605
openRedmine doesn't recover from DB timeouts with TinyTds and MS SQL
Status:
New
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Affected version:
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)
No data to display
Actions