プロジェクト

全般

プロフィール

Vote #74331

未完了

Internal error with "TinyTds::Error: Adaptive Server connection timed out"

Admin Redmine さんが約4年前に追加. 約4年前に更新.

ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Search engine_16
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
16
version_id:
0
issue_org_id:
14811
author_id:
80618
assigned_to_id:
0
comments:
0
status_id:
1
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
71
ステータス-->[New]

説明

If a search is too long, we get a timeout and this results in an Internal page error displayed to the user.
It would be more appropriate to show an error page like "Your search timed out. you can retry at a less busy time or contact your administrator."

In order to reproduce, you can try:
With MS SQL server, a large database (18000 issues),
*set the database timeout to be 1s by modifying redmine/config/database.yml and adding
:timeout 1
in your production: section settings
Then restart and search for a very common word.
We get the following error in log/production.log:
ActiveRecord::StatementInvalid (TinyTds::Error: Adaptive Server connection timed out: EXEC sp_executesql...

We fixed the issue by increasing the timeout in the config, but still, getting Internal errors is not nice.

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0