Defect #29605

Redmine doesn't recover from DB timeouts with TinyTds and MS SQL

Added by Serghei Zagorinyak over 3 years ago.

Status:NewStart date:
Priority:NormalDue 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)

Also available in: Atom PDF