ES /docs

Capture move failed: migration id(1482) - ActiveRecord::RecordInvalid: Validation failed: Semantic t

Service
cupixvista-api-migration-worker
Occurrences
32
Status
Dismissed
Confidence
80%
Actionability
16%
Cluster ID
6c65a925-b226-4f78-9ae7-c5acc198ae3b
First Seen
2026-06-08 04:14 UTC
Last Seen
2026-06-08 04:27 UTC
Datadog↗ Slack↗
Actions
현재 상태 dismissed 에서는 실행할 액션이 없습니다.

Capture move failed: migration id(1482) - ActiveRecord::RecordInvalid: Validation failed: Semantic t

What Happened#

2026-06-08 13:14 KST 부터 약 13분 동안 cupixvista-api-migration-worker (stage 환경) 에서 MoveWorker 가 7개의 migration (id 1482, 1483, 1484, 1485, 1487, 1490, 1493) 에 대해 ActiveRecord::RecordInvalid: Validation failed: Semantic taxonomy state is invalid 로 실패하며 총 32회 (각 migration × Sidekiq 최대 5회 재시도) 에러가 기록되었다. MOVE_TABLES 순서 중 Pointcloud 단계에서 record.update! 가 state_machine validation 에 의해 거부되었고, 트랜잭션이 롤백되어 해당 migration 들은 모두 'error' 상태로 종료되었다.

Quick Facts#

Field Value
exception.class ActiveRecord::RecordInvalid
exception.message Validation failed: Semantic taxonomy state is invalid
top_frame app/operations/migration_move_operation.rb:48
caller app/workers/move_worker.rb:106 (each MOVE_TABLES)
runtime Ruby 3.3.0, Rails 7.2.2, state_machines-activerecord 0.8.0
env stage (us-west-2), tenant=cupix (CupixVista)

Affected Teams#

Team / Domain Error Count Impact
CupixVista migration (stage) 32 (7 migrations × ≤5 retries) 7건의 record/capture facility 이동 작업이 실패하고 'error' 상태로 종료됨. 해당 migration 들은 자동 재시도 후에도 복구 불가

Timeline#

  1. 2026-03-16 — pointclouds.semantic_taxonomy_state 컬럼 추가 (default 없음, NULL 허용) — db/migrate/20260316071708_add_semantic_taxonomy_state_to_pointclouds.rb
  2. 2026-04-20 — semantic_taxonomy_state default 가 "none" 으로 변경됨 — db/migrate/20260420031447_change_default_semantic_taxonomy_state_on_pointclouds.rb. 그러나 이미 존재하던 row 들의 NULL/legacy 값은 backfill 되지 않음
  3. 2026-06-08 13:14:07 KST — migration id(1482) Record move begin (source_record_id=7241, target_facility_id=6647)
  4. 2026-06-08 13:14:07 KST — Record/Spacetime/Capture/Video/Cluster 단계는 정상 완료, Pointcloud 단계에서 update! 실패 → 트랜잭션 롤백
  5. 2026-06-08 13:14:07 ~ 13:27:31 KST — Sidekiq 재시도 5회 모두 동일하게 실패, 7개 migration (1482, 1483, 1484, 1485, 1487, 1490, 1493) retries exhausted → MigrationOperation.check_move(result: 'error')

Scoring#

Confidence 80% · Actionability 16%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 18 code refs, 6 log queries
Code path explicitness 3/3 18 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 20 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 0/3 migration needed