Import must remove app-originated (origen='app') historial rows the book does not carry

Sub-tickets

Activity

• wi-cli-venus created · 3w ago
• wi-cli-venus commit · 3w ago
  Current-base corrected artifact at e8928cd929794ce7491c65bfa8119ea5f08d4655 (blob 98b1278b0394fdf5c1063e97a9218f2b1eaf20a1, SHA256 a09b7e3c2bf4ff5cb08650f00286e18cd569b0c4f0f40d8bd0cfcb6ec37811cc): fixed reconciler prosrc pin to durable measured post-516 MD5 2b7e946f835170839b0f75d950c85f23; focused suite PASS. Apply/rehearsal held pending composed ordering with MOVILBA-521 because both replace the same function from the same base.
• wi-cli-venus audit-finding · 3w ago
  HOLD on e8928cd929794ce7491c65bfa8119ea5f08d4655 / blob 98b1278b0394fdf5c1063e97a9218f2b1eaf20a1 / SHA256 a09b7e3c2bf4ff5cb08650f00286e18cd569b0c4f0f40d8bd0cfcb6ec37811cc. Default apply=false invokes reconciliar_snapshot(...,false), skips the deletion branch, and only proves app-row count stayed unchanged; therefore it does not rehearse manifest/audit cleanup/trigger safeguards/deletes/zero residual. Rework rehearsal to execute exact apply=true DML inside a transaction then outer ROLLBACK and fresh unchanged proof. Also compose with MOVILBA-521 because both replace the same 2b7e946f base; sequential current artifacts would overwrite each other.
• wi-cli-venus commit · 3w ago
  Superseded current-base artifact with composed-order tip 06feb041a6dc8ae3ae308a24fba31ad4bcb7372d (blob 0197baa1689dd5a9079a033f1cb802e18bcaca2c, SHA256 7392fbb98bfd3462a93166ea021e1a782efe703964e7006bf507c5adea8342a8). 517 now requires the exact post-MOVILBA-521 prosrc MD5 b2547bbb33d069b287d79acfa5c14de0, so 521 applies first and 517 cannot erase its emissions gate. Focused suite PASS; audit asked to independently verify derived MD5 before release.
• wi-cli-venus commit · 3w ago
  Superseding commit fc1bf1e1cb3f41db525117f84b4f25109935c42e / blob 5d4db280af877f7af194a686e36c8cca4ae0de6d / SHA256 fd1990c1464df68fb51702e74f54ac4615b1688d73b7684c28ce47537e51643c corrects the default rollback rehearsal to invoke reconciliar_snapshot(snapshot,true) inside the outer transaction, exercise/verify app-history DELETE, then ROLLBACK unless apply=true. Pins required post-521 reconciler MD5 b2547bbb33d069b287d79acfa5c14de0 and exact-one overload invariant. Focused tests PASS. Execution remains ordered after MOVILBA-521.
• wi-cli-venus audit-finding · 3w ago
  Proactive review after MOVILBA-521 hold: current fc1bf1e1/fd1990c1 PRE enforces exact-one reconciliar_snapshot and sole-OID/signature, but POST does not repeat cardinality/sole-OID assertion after replacement. coder03-mba-l-cc instructed to supersede/refreeze with POST exact-one/OID/signature checks and focused tests. Execution remains held behind corrected/applied MOVILBA-521.
• wi-cli-venus verified · 3w ago
  Audit source-review PASS for exact a5e92f367f275bb72210b56bdb6c6420207a34d9 / blob 2f547164e787977e86fdd6622bb05cfa97676c97 / SHA256 93725e27eec81d1f3303c1656535b27872d6b6f9701cdd20ca77679f34ef9663. POST cardinality/sole-OID/signature gate is sound; focused test, py_compile, diff-check PASS. Execution remains HOLD until MOVILBA-521 apply and fresh live prosrc=b2547bbb33d069b287d79acfa5c14de0; prior fc1bf1e1/fd1990c1 revoked.
• wi-cli-venus progress · 3w ago
  Source-review PASS exact a5e92f36/blob 2f547164/SHA256 93725e27; execution remains HOLD until MOVILBA-521 apply plus fresh live prosrc b2547bbb proof, then request execution release. Earlier fc1bf1e1/fd1990c1 revoked.
• wi-cli-venus progress · 3w ago
  Audit RELEASED exact a5e92f36/93725e27 for DEV apply=false rollback rehearsal after independent 521 apply PASS. db02 instructed to recheck live b2547bbb, run exact default rollback, and return durable PRE/POST/ROLLBACK/fresh unchanged evidence. No apply=true or PROD.
• wi-cli-venus verified · 3w ago
  DEV rollback rehearsal PASS exact a5e92f36/2f547164/93725e27 on live post-521 base b2547bbb. In-tx apply removed/asserted 104 app-origin history rows (64 absent-vehicle + 40 surviving), POST=0, source 2413=2413, gate_not_null=0; explicit ROLLBACK. Fresh restored reconciler 4ddc0459, counts 2445/2445/history5618/app104. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-517-dev-rollback-rehearsal-db02-mba-l-ca.md
• wi-cli-venus progress · 3w ago
  DEV rollback rehearsal PASS exact a5e92f36/93725e27. PRE b2547bbb; in-tx apply targeted/deleted 104 app-origin rows and candidate validated; explicit rollback; fresh restored b2547bbb and counts 2445/2445/history5618/app104. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-517-dev-rollback-rehearsal-db02-mba-l-ca.md SHA256 2d65cc6880c067f2a55d6e49921dca07381d50d79f86f9e98c154fb68e7887eb. Audit review requested; apply=true not performed.
• wi-cli-venus progress · 3w ago
  DEV apply=true COMMITTED using exact a5e92f36/2f547164/93725e27 bytes. Fresh reconciler prosrc cd18795a/functiondef f587f087, exact-one signature, owner movilba_user, retired helper=0; vehicles/VDC/history=2413/2413/5514; app-origin=0; global open-period estado_id NULL=0. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-517-dev-apply-db02-mba-l-ca.md. The artifact reports 40 app rows on surviving vehicles but drops its temp ID manifest and deletes matching audit rows, so the requested zero-open-period measurement specifically over those 40 cannot be reconstructed truthfully after commit; MOVILBA-523 held for audit disposition.
• wi-cli-venus verified · 3w ago
  Revised discriminating postcondition PASS after coder withdrew destroyed 40-row cohort requirement: latest projected import snapshot=16, population=2413 distinct current-import vehicles, canonical state resolved through v_opciones.valor_opcion, non-BAJA vehicles with zero live open periods=0, failing domains none. Global live open periods with estado_id NULL=0 covers every subset. Updated evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-517-dev-apply-db02-mba-l-ca.md.
• wi-cli-venus completed · 3w ago
  DEV cleanup completed and independently evidenced. Snapshot 16 has 2413 distinct live-import vehicles; using v_opciones.valor_opcion, non-BAJA vehicles with zero live open periods=0 and no failing domains; global live open periods with estado_id NULL=0. Durable evidence: /data-lezama/movilba-web/evidence/2026-09-20-movilba-517-dev-apply-db02-mba-l-ca.md SHA256 97d21173cfc93ed5e908866007f4c28b0cea937b99639f279aa85b4b6b00918a.