Vote #79522
未完了Redmine doesn't recover from DB timeouts with TinyTds and MS SQL
ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Database_21
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:
0%
予定工数:
Redmineorg_URL:
category_id:
21
version_id:
0
issue_org_id:
29605
author_id:
120852
assigned_to_id:
0
comments:
0
status_id:
1
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
134
説明
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)
いいね!0