Project

General

Profile

Actions

Defect #29605

open

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

Added by Serghei Zagorinyak over 5 years ago.

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

Also available in: Atom PDF