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-worker 의 ImportWorker 가 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::Pano 의 default_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#
- 2026-07-09 07:06:05 KST — 첫 시도:
migrate_capture까지 완료하고migrate_pano단계에서 Pano 92228359 조회 실패 - 2026-07-09 07:06:39 KST — Sidekiq retry:
Migration import - migration id(1843): sidekiq is retried - 2026-07-09 07:06:53 KST —
migrate_pano재실행, 동일 Pano id 로 재실패 - 2026-07-09 07:07:13 KST — 재시도 재실패
- 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 |