movilba
MOVILBA-660
· child of MOVILBA-647 MOVILBA-585 mitad B: censo PROD vs DEV de funciones, triggers, constraints e indices, diffeado en LAS DOS direcciones y con el lado correcto nombrado por diferencia Done
PROD: fn_validadoras_historial_tipo_check huerfana y el modelo de validadoras_historial sin artefacto de migracion
Done normal
dmdb03-mba-l-cc
Seguimiento de MOVILBA-647 (UNRESOLVED de db03): en PROD el modelo de reemplazo de validadoras_historial no tiene artefacto de migracion que diga quien lo aplico (en el repo solo esta la variante -DEV), y deja huerfana fn_validadoras_historial_tipo_check en PROD. Hacer: (1) confirmar con pg_depend/pg_trigger que ninguna tabla, trigger ni constraint la referencia en PROD; (2) escribir el artefacto que falta en docs/migrations/ describiendo el estado PROD medido; (3) si esta huerfana, DROP FUNCTION en PROD (no destruye datos), rehearsal bajo ROLLBACK primero, y dejar DEV igual a PROD. Audit verifica.
Activity
-
parent=MOVILBA-647
-
db03-mba-l-cc / db
-
STARTED MOVILBA-660 at Fri Oct 2 10:50:54 AM -03 2026
-
MOVILBA-647's premise was wrong, not a real gap: docs/migrations/2026-08-31-movilba128-validadoras-schema-align-PROD.sql IS the missing artifact - it DROP TABLE CASCADEs validadoras_historial and recreates DEV's model, which took the tipo_check trigger down with it without dropping the function itself. Earlier search missed it by looking for a '-replacement-PROD.sql' filename; actual file is '-schema-align-PROD.sql'.\n\n(1) Confirmed orphan on PROD 2026-10-02: zero pg_trigger refs, zero pg_depend refs, zero other function bodies call it by name (swept public+rutap, excluding aggregates).\n(2) Wrote docs/migrations/2026-10-02-movilba660-drop-orphan-tipo-check-PROD.sql documenting the measured state and the DROP, under lock movilba_prod.fn_validadoras_historial_tipo_check.\n(3) Rehearsed (ROLLBACK, clean) then applied (COMMIT) against PROD via SUPERUSER_ELAZAR_URL. Verified absent post-apply: to_regprocedure returns NULL. DEV already lacked it (MOVILBA-647 census) - no DEV action needed, both bases now match with no further step.\n\nDDL on an orphan with proven zero dependents, pre-live routine fix per project CLAUDE.md - no separate GO required. Send to audit for verdict.
-
audit pass: docs/migrations/2026-10-02-movilba660-drop-orphan-tipo-check-PROD.sql: gate/verify logic only (expected_database/server guard, pre-flight REFUSED checks, DROP FUNCTION, post-verify to_regprocedure NULL).
payload
{"scope":"docs/migrations/2026-10-02-movilba660-drop-orphan-tipo-check-PROD.sql: gate/verify logic only (expected_database/server guard, pre-flight REFUSED checks, DROP FUNCTION, post-verify to_regprocedure NULL).","outcome":"pass","evidence":"Template matches other PROD migrations in repo; internally fail-closed. DB EXECUTION NOT PERFORMED BY AUDIT - relying on db03 claimed rehearsal/apply/post-verify against live PROD.","reportRef":null} -
coder03-mba-l-cc 2026-10-05: closed at db03's report; audit PASS already recorded in bwi (2026-10-02).
task
2w ago by coder03-mba-l-cc
1w ago
2026-10-05 15:01