ES /docs

ActiveRecord::LockWaitTimeout: Mysql2::Error::TimeoutError: Lock wait timeout exceeded; try restarting transaction

Service
cupixworks-mysql2
Occurrences
310
Status
Reported
Confidence
80%
Actionability
44%
Cluster ID
072e6a8f-4e99-4ca4-89c0-5133c6a4af33
First Seen
2025-11-15 03:38 UTC
Last Seen
2026-08-05 00:54 UTC
Actions

ActiveRecord::LockWaitTimeout: Mysql2::Error::TimeoutError: Lock wait timeout exceeded; try restarting transaction

What Happened#

2026-08-04 최근 발생분에서 SQA editing release 워커가 Editing 행 잠금을 얻지 못해 Mysql2::Error::TimeoutError: Lock wait timeout exceeded 로 실패했다. 워커는 이를 lock_contention 사유로 rescue 하고 backoff 재시도하며, 2회 시도 후 "Release abandoned" error 로그를 남기고 멈춘다. 멈춘 editing 은 5분 주기 release_stuck_split_editings cron 이 다시 release 큐에 넣어 회수하므로 데이터는 유실되지 않는다.

Quick Facts#

Field Value
exception.class ActiveRecord::LockWaitTimeout (Mysql2::Error::TimeoutError)
exception.message Lock wait timeout exceeded; try restarting transaction
top_frame app/services/cupix/editing_split_service.rb:318
runtime Ruby on Rails (Sidekiq worker), MySQL InnoDB
env production (cupixworks-worker)

Affected Teams#

Team / Domain Error Count Impact
SiteInsights (SQA) editing split 클러스터 누적 299 (여러 변형 합산) Editing 이 :ready 승격이 일시 지연됨. cron sweep 으로 자동 회수, 영구 유실 없음

Timeline#

  1. 2025-11-15 12:38 KST — Error Tracking 이슈 최초 감지 (Representative Error 는 bare Mysql2::Error::TimeoutError).
  2. 2026-08-04 14:48 KST — editing 82176 lock_contention 로 2회 시도 후 abandoned.
  3. 2026-08-04 15:08 KST — editing 82187 lock_contention 로 2회 시도 후 abandoned.
  4. 2026-08-04 15:57 KST — 클러스터 last_seen.
  5. 2026-08-04 이후Editing released to :ready after split info 로그로 회수 확인 (자동 복구).

Scoring#

Confidence 80% · Actionability 44%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 11 code refs, 3 log queries
Code path explicitness 3/3 11 file:line refs
Log evidence 2/3 section, query
RCA structure 3/3 3/3 sections
Revision history 0/3 0 revision(s)
Agent execution 3/3 success

Actionability#

Dimension Score Detail
Fix complexity 5/5 trivial
Affected files 1/5 8 file(s)
Single repo 1/3 4 service(s)
Immediate actions 0/3 absent
Testability 0/3 no test info
External dependency 1/3 external deps found
Data migration 3/3 no migration