ES /docs

ReviewPermission with id 131231 not found after 6 retries

Service
cupixworks-worker
Occurrences
15
Status
Reported
Confidence
80%
Actionability
28%
Cluster ID
95abebd7-93a2-46f0-9618-032530af8976
First Seen
2026-07-16 18:54 UTC
Last Seen
2026-08-05 04:14 UTC
Actions

ReviewPermission with id 131231 not found after 6 retries

What Happened#

SavePartialJsonToFileWorker Sidekiq worker가 방금 생성된 ReviewPermission 레코드(id 131231~131236, 총 6건)를 find_by_id로 조회하지 못해 6회 재시도 후 최종 실패했다. 재시도 지연은 exponential backoff(0.1s → 3.2s, 총 약 6.3s)였고, 그 사이 레코드가 결국 조회 가능해지지 않아 error 로그를 남기며 종료됐다. 이로 인해 해당 ReviewPermission 6건은 CDC(partial JSON) 파이프라인에 전달되지 않아 데이터 웨어하우스 반영이 누락됐다.

Quick Facts#

Field Value
exception.class RuntimeError (message-only 로그, no stack)
exception.message ReviewPermission with id 131231 not found after 6 retries
top_frame app/workers/save_partial_json_to_file_worker.rb:57
runtime Ruby / Sidekiq (queue: data_changes, retry: false)
env production, us-west-2

Affected Teams#

Team / Domain Error Count Impact
cupixworks-worker (Data Warehouse CDC) 6 ReviewPermission 6건이 partial JSON 파일로 저장되지 않아 DWH 파이프라인에서 누락

Timeline#

  1. 2026-07-17 03:54:41 KST — Sidekiq worker가 ReviewPermission#131231 조회 시작, retry 1/6 실패 (not found, retrying in 0.1 seconds).
  2. 2026-07-17 03:54:41~45 KST — retry 2~6 순차 실패 (delay 0.2s → 3.2s).
  3. 2026-07-17 03:54:49 KST#131231 최종 실패, error 로그 (not found after 6 retries).
  4. 2026-07-17 03:54:49~51 KST — 동일 패턴으로 #131232~#131236도 실패, 총 6건.
  5. 2026-07-10 19:18:35~37 KST — 동일 워커에서 ReviewPermission#130447, #130448 실패한 이전 사례 확인 (재발 패턴).

Scoring#

Confidence 80% · Actionability 28%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 19 code refs, 6 log queries
Code path explicitness 3/3 19 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 1/5 critical
Affected files 1/5 27 file(s)
Single repo 1/3 2 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