ES /docs

Database import retries exhausted: migration id(1843) - ActiveRecord::RecordNotFound: Couldn't find

Service
cupixworks-migration-worker
Occurrences
3
Status
Reported
Confidence
80%
Actionability
16%
Cluster ID
824fa57f-da39-4076-8304-1a67aece327b
First Seen
2026-07-08 22:06 UTC
Last Seen
2026-07-08 22:07 UTC
Actions

Database import retries exhausted: migration id(1843) - ActiveRecord::RecordNotFound: Couldn't find

What Happened#

2026-07-09 07:06 KST 부터 cupixworks-migration-workerImportWorker 가 migration id 1843 (walmart-tst team, us-west-2, facility 18180 copy) 을 실행하다가 세 번 연속 ActiveRecord::RecordNotFound 로 실패했다. Sidekiq retry 5회를 모두 소진한 뒤 sidekiq_retries_exhausted 훅이 최종 Database import retries exhausted 에러 로그를 남겼다. 실패 지점은 migrate_panos 후반의 migrate_tile_object 로, 방금 insert_model! 로 새로 만든 Pano(id 92228359)를 다시 Pano.find 로 조회할 때 Statable::Panodefault_scope { where.not(state: :abandoned) } 에 걸려 조회되지 않았다.

Quick Facts#

Field Value
exception.class ActiveRecord::RecordNotFound
exception.message Couldn't find Pano with 'id'=92228359 [WHERE `panos`.`state` != ?]
top_frame app/operations/migration_import_operation.rb:708
runtime Ruby 3.3.0, ActiveRecord 7.2.2, Sidekiq 7.3.9
env production, us-west-2
tenant cupix (team walmart-tst, team_id 1257, user_id 52196)

Affected Teams#

Team / Domain Error Count Impact
walmart-tst (team_id 1257) 3 Migration id 1843 (facility 18180 copy) 실패, 사용자에게 error 상태로 노출

Timeline#

  1. 2026-07-09 07:06:05 KST — 첫 시도: migrate_capture 까지 완료하고 migrate_pano 단계에서 Pano 92228359 조회 실패
  2. 2026-07-09 07:06:39 KST — Sidekiq retry: Migration import - migration id(1843): sidekiq is retried
  3. 2026-07-09 07:06:53 KSTmigrate_pano 재실행, 동일 Pano id 로 재실패
  4. 2026-07-09 07:07:13 KST — 재시도 재실패
  5. 2026-07-09 07:07:45 KST — retry 5 소진, sidekiq_retries_exhausted 훅이 Database import retries exhausted 로그 기록, MigrationOperation.check_import(result: 'error') 로 migration 상태 error 마킹

Scoring#

Confidence 80% · Actionability 16%

Confidence#

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