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