ES /docs

Api::V1::UsersController#update (avg 12861ms, max 12861ms)

Service

cupixworks-api

Occurrences

Status

Reported

Confidence

85%

Actionability

52%

Cluster ID

05422fd9-6228-4ceb-abbe-0b4ab0588e4d

First Seen

2026-08-06 07:21 UTC

Last Seen

2026-08-06 07:21 UTC

Datadog↗

Slack↗

Actions

Api::V1::UsersController#update (avg 12861ms, max 12861ms)

What Happened#

2026-08-06 16:21 KST, cupixworks-api 에서 Api::V1::UsersController#update 요청 한 건이 12861 ms 로 느리게 처리됐다(HTTP 200 성공). 지연의 원인은 user 비활성 전이 시 실행되는 DELETE FROM sessions WHERE sessions.user_id = ? 가 InnoDB row lock 을 12 초간 기다린 것이다. 배포 직후 DB primary 의 lock 경합 창에 국한된 단발 outlier 다.

Quick Facts#

Field	Value
cluster_type	latency
resource_name	`Api::V1::UsersController#update`
slow_span	`DELETE FROM sessions WHERE sessions . user_id = ?` (12098 ms)
top_frame	`app/models/concerns/statable/user.rb:39`
db.instance	`tesla_production` (mysql, `db-tesla.cupix.internal`)
http	`PUT /api/v1/users/36575` → 200, base_url `admin.cupix.works`
runtime	ruby, host `i-0624c7093702339fd` (us-west-2)
deploy	`production-us-west-2-20260806t0615z0-5d437c17-cupixworks`
env	production, us-west-2

Affected Teams#

Team / Domain	Error Count	Impact
cupix (admin console)	1	관리자 1인이 사용자 비활성 처리 시 12.8 초 대기(요청은 성공). 최종 사용자 서비스 영향 없음

Timeline#

2026-08-06 14:42 KST — 05:42:15Z, svc:cupixworks-api::unknown 인시던트 시작(배포 창 서비스 저하 burst).
2026-08-06 15:15 KST — 06:15Z 배포 production-us-west-2-20260806t0615z0 반영.
2026-08-06 15:46 KST — 같은 primary 에서 PanosController#update_meta_by_key 다수 [502] Lock wait timeout exceeded 관측.
2026-08-06 16:21 KST — 07:21:05Z, PUT /api/v1/users/36575 (UsersController#update) 12861 ms, 세션 DELETE 12098 ms. 이 클러스터의 유일 발생.
2026-08-06 16:29 KST — EditingsController#update [503] ActiveRecord::Deadlocked 관측(동일 경합 창).

Scoring#

Confidence 85% · Actionability 52%

Confidence#

Dimension	Score	Detail
Evidence completeness	5/5	14 code refs, 6 log queries
Code path explicitness	3/3	14 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	5/5	trivial
Affected files	1/5	9 file(s)
Single repo	1/3	3 service(s)
Immediate actions	0/3	absent
Testability	0/3	no test info
External dependency	3/3	no external deps
Data migration	3/3	no migration