プロジェクト

全般

プロフィール

Vote #76911

未完了

ActiveRecord::StatementInvalid when trying to update user_setup

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

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

0%

予定工数:
category_id:
21
version_id:
0
issue_org_id:
21222
author_id:
120852
assigned_to_id:
0
comments:
0
status_id:
1
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
75
ステータス-->[New]

説明

From time to time Redmine begins to fail every request with this error:

@Started GET "/redmine/issues/78317" for 172.23.24.178 at 2015-11-12
13:03:15 +0300
Processing by IssuesController#show as HTML
Parameters: {"id"=>"38317"}
Completed 500 Internal Server Error in 2.0ms
ActiveRecord::StatementInvalid (TinyTds::Error: Attempt to initiate
a new Adaptive Server operation with results pending: EXEC sp_execut
esql N'SELECT MAX([settings].[updated_on]) AS max_id FROM [settings]
'):
app/models/setting.rb:226:in check_cache'
app/controllers/application_controller.rb:97:in
user_setup'@

So every action that requires update of user_setup failes with this error. This situation is barely reproducible and occurs as often as once in a few months making it absolutely impossible to use Redmine till it is restarted.

Environment setting are the following:

@ Redmine version 2.5.0.stable
Ruby version 2.1.5-p273 (2014-11-13) [x86_64-linux]
Rails version 3.2.17
Environment production
Database adapter SQLServer@

Admin Redmine さんが約2年前に更新

  • カテゴリDatabase_21 にセット

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

いいね!0
いいね!0