Project

General

Profile

Actions

Defect #22268

closed

Lock wait timeout exceeded を再現させる条件

Added by mizuka sano about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

以下のログがproduction.logに多発して、メモリのリソースを大幅に消費する障害が頻発します。

ActiveRecord::StatementInvalid(Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: SELECT `issues`.*FROM `issues` OORDER BY `issues`.`rgt` desc LIMIT 1 FOR UPDATE):
lib/plugins/awesome_nested_set/lib/awesome_nested_set/model.rb:165:in `right_most_bound`
lib/plugins/awesome_nested_set/lib/awesome_nested_set/model.rb:182:in `set_default_and_right`
app/models/issue.rb:165:in `create_or_update`
app/controllers/issues_controller.rb:150:in `create`

Defect #6579 と同様の問題かと思い、ツリー構造が複雑なサブチケット上でテストで更新をしてみたのですが、再現できません。
再現できなければ、redmineのバージョンアップを提案することも難しいので困っています。
どうか、どなたか、この障害が再発する条件を教えて頂けませんでしょうか?

Actions #1

Updated by Go MAEDA about 8 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

Please use forums for questions and all posts on this site have to be written in English.
Maybe it would be better to post to redmine-users-ja mailing list if you want to ask questions in Japanese.

Actions #2

Updated by Toshi MARUYAMA about 8 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF