movilba
MOVILBA-606
· child of MOVILBA-505 PROD: 148 de 2413 vehiculos vivos con carroceria_id NULL (backfill de datos, distinto de 492) Done
PROD: 18 non-NULL carroceria IDs disagree with current RUTAP source
Done high
dmdb04-mba-l-ca
Measured PROD movilba on 2026-09-28, current RUTAP snapshot 7 (2026-09-28-1042-parque-rutap.xlsx): 18 live public.vehiculos rows have non-NULL carroceria_id different from the resolved carroceria_id in the installed rutap.reconciliar_snapshot(7,false) source. Predicate: v.carroceria_id IS DISTINCT FROM s.carroceria_id AND v.carroceria_id IS NOT NULL; 18/18 source IDs are non-NULL. This is separate from MOVILBA-505's 151 NULL-row backfill and was not changed by that artifact. A later full reconciliation may fix them, but that path has not been run after MOVILBA-605. Measure exact target/controls before any write.
Activity
-
parent=#3946
-
db04-mba-l-ca 2026-09-28 ART: PROD SELECT-only after rutap.reconciliar_snapshot(7,false), join rutap_reconcile_source s to public.vehiculos v by vehiculo_id; filter v.carroceria_id IS DISTINCT FROM s.carroceria_id AND v.carroceria_id IS NOT NULL. Exactly 18 rows, all source IDs non-NULL: AA814GR 10->2, AE335EU 2->10, AF206GP 1->14, MIJ539 14->1, NPQ712 10->2, OBV304 10->2, OCX211 14->1, OCX212 14->1, OEA351 10->2, OTM570 14->1, OTM571 14->1, OWO447 10->2, PCF385 10->2, PEJ023 14->1, PNN487 10->2, PQB789 14->1, AI016CO 17->68, AH940VK 18->68. Arrows are installed vehiculos.carroceria_id -> current normalized RUTAP source carroceria_id. No write; separate from 505 NULL cohort.
-
db04-mba-l-ca 2026-10-01 12:53 ART, PROD movilba SELECT-only, snapshot8 current: 0 live vehicles with non-NULL vehiculos.carroceria_id differing from non-NULL carroceria_id in rutap.v_vehiculo_historial_actual. Rechecked all 18 domain names listed in this item: each still has a live vehicle and each base carroceria_id now equals the current history source (AA814GR 2/2, AE335EU 10/10, AF206GP 14/14, MIJ539 1/1, NPQ712 2/2, OBV304 2/2, OCX211 1/1, OCX212 1/1, OEA351 2/2, OTM570 1/1, OTM571 1/1, OWO447 2/2, PCF385 2/2, PEJ023 1/1, PNN487 2/2, PQB789 1/1, AI016CO 68/68, AH940VK 68/68). Installed rutap.reconciliar_snapshot body md5 316757ebb51531c3bddff4e2fbec02b7 contains carroceria_id in both UPDATE SET and IS DISTINCT FROM tuples. Snapshot8 reconciliation has superseded the 18-row snapshot7 mismatch; no data change made in this sweep. Not exercised: a future import regression test.
-
completed
bug
2w ago by db04-mba-l-ca
2w ago
2026-10-01 15:38