MySQL lock wait timeout — database contention
Service
cupixworks-any-voxel-agent
Occurrences
569
Status
Reported
Confidence
85%
Actionability
28%
Cluster ID
1f6e367e-08d0-4a5c-a4ef-4c95f7d871b2
First Seen
2026-04-23 08:39 UTC
Last Seen
2026-08-05 01:29 UTC
Actions
MySQL lock wait timeout — database contention
What Happened#
2026-04-23 08:39:59 UTC에 cupixworks-any-voxel-agent 서비스에서 capture 685954의 voxel_state를 "error"로 업데이트하는 PUT 요청이 HTTP 504 Gateway Timeout으로 실패했다. 동일 시간대에 cupixworks-api에서 대규모 MySQL lock wait timeout이 발생하고 있었으며, 이로 인해 내부 API 요청이 게이트웨이 타임아웃으로 실패한 것이다.
Quick Facts#
| Field | Value |
|---|---|
| exception.class | Error (axios) |
| exception.message | Request failed with status code 504 |
| top_frame | /tmp/agent/dist/app.js:65374 (createError in bundled axios) |
| env | production, us-west-2 |
Timeline#
- 08:38:02 UTC — Voxel agent가 capture 685954 처리 시작 (setCaptureVoxelsParams)
- 08:38:56 UTC — Voxel 계산 완료 (768 voxels), S3 raw 업로드 시작
- 08:38:59 UTC —
updateVoxelState또는 upload credentials 요청 시 400 에러 발생 (State not changed) - 08:39:56 UTC — Upload credentials 요청에 504 에러 발생
- 08:39:59 UTC — Error handler에서
voxel_state: "error"PUT 요청도 504로 실패 →BaseService::handlingMessageErrors에러 로그 기록
Scoring#
Confidence 85% · Actionability 28%
Confidence#
| Dimension | Score | Detail |
|---|---|---|
| Evidence completeness | 5/5 | 16 code refs, 6 log queries |
| Code path explicitness | 3/3 | 16 file:line refs |
| Log evidence | 3/3 | section, query, pattern |
| 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 | 1/5 | critical |
| Affected files | 1/5 | 12 file(s) |
| Single repo | 1/3 | 7 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 |