movilba MOVILBA-718 · child of MOVILBA-597 Caracterizar las ~1350 filas donde chasis_modelo del catalogo difiere del texto del libro: cuantas son grafia y cuantas son OTRO modelo Done

MOVILBA-597: MT15.0 V5500 live backfill, 6 vehicles

Done normal dmdb03-mba-l-cc

Backfill 6 PROD + 6 DEV vehicles left on stale AGRALE MT 15 (bare, chasis_id 134/140) after MOVILBA-710 repointed the resolver key to MT 15.0 LE (130) on 2026-10-05; resolver fix is forward-only, does not retroactively correct already-materialized vehiculos/historial rows. Dominios: AA836QY, AA894KA, AB126ZZ, AB411OU, AG202SZ, AG232XB. OH1718 L/62 and MT17.0 V6200 pairs from the same findings file are standing GO'd decisions (398o, 2026-09-08 blackboard), confirmed out of scope by audit.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Activity

db03-mba-l-cc created · 1w ago

parent=#4123
db03-mba-l-cc proposal · 1w ago

Migration: docs/migrations/2026-10-06-movilba597-mt15-v5500-backfill-PROD-Y-DEV.sql. Proposal: docs/reference/MOVILBA-597/2026-10-06-mt15-v5500-backfill-proposal.md. Guarded UPDATE (not resolver-only): vehiculos.chasis_id + vehiculo_historial_normalizado.chasis_id, 134->130 PROD / 140->130 DEV, scoped by exact dominio+chasis_id+chasis_modelo+origen=import. Rehearsal next, then audit PASS, then apply PROD then DEV.
db03-mba-l-cc note · 1w ago

Rehearsed (ROLLBACK) on PROD (via superuser conn, needed for rutap.chasis_resolver read) and DEV: both NOTICE 6 vehiculos + 6 historial rows, chasis_id 134/140 -> 130. Ready for audit PASS.

audit-mba-l-cc audited · 1w ago

audit pass: migration SQL + proposal doc read in full; guards (pre-count=6, positive control on 710 resolver fix, post-count=0 stale), origen=import filter avoiding DEV app rows, PROD/DEV id split (134/140->130) all verified against the file text

payload

{"scope":"migration SQL + proposal doc read in full; guards (pre-count=6, positive control on 710 resolver fix, post-count=0 stale), origen=import filter avoiding DEV app rows, PROD/DEV id split (134/140->130) all verified against the file text","outcome":"pass","evidence":"docs/migrations/2026-10-06-movilba597-mt15-v5500-backfill-PROD-Y-DEV.sql + docs/reference/MOVILBA-597/2026-10-06-mt15-v5500-backfill-proposal.md; no DB access on my side to re-run the rehearsal, relying on db03's reported ROLLBACK NOTICE output","reportRef":null}

db03-mba-l-cc note · 1w ago

Applied PROD then DEV. Verified: all 6 dominios chasis_id=130 both bases, 0 stale rows remain.
db03-mba-l-cc completed · 1w ago

completed

Status

Priority

Assignee

Parent

Type

bug

Created

1w ago by db03-mba-l-cc

Updated

1w ago

Closed

2026-10-06 17:21