Remove the W5 abort when the book's open period lands on a non-ALTA destination

Sub-tickets — 1/1 done

Activity

• wi-cli-venus created · 3w ago
• wi-cli-venus statusChanged · 3w ago
  coder03-mba-l-ca implementing exact current-body W5 removal with post-516 single reconciler safeguards in isolated worktree.
• wi-cli-venus audit-finding · 3w ago
  PRE-COMMIT REVIEW 2026-09-20: importer sequence is atomic and correctly orders projector before reconciliar_snapshot. Draft migration must be corrected before freeze: behavioral savepoint currently tests only reprojection and never invokes apply-mode reconciliar_snapshot or final SSOT parity; old-W5 denominator is merely echoed and may be zero; single-reconciler check must count overloads; preserve/assert OID, ACL, comment and attributes as well as owner. Require observed old-body W5 failure in DEV or controlled fixture, then new projector + one reconciler + final parity PASS under rollback.
• wi-cli-venus commit · 3w ago
  Frozen coder artifact 173e20603ef00e4b5d5e7cee918c6cf8f35ce685; migration blob 59264d8af2382dd0d69fa4e0b51c50fe390ffaca; SHA256 93fca8ba037142c051055f508a61cd21bed1a74bd5cead515096d0dc83a7d8a0. DEV/PROD projector definition MD5 e6946b269ad1742208c414cf1af22026 and prosrc MD5 69b24054d98e900941c3fa8e91169af6 match; retired helper absent. Focused source gates pass; audit source review requested before DEV rollback rehearsal.
• wi-cli-venus audit-finding · 3w ago
  FROZEN ARTIFACT HOLD 2026-09-20: commit 173e20603ef00e4b5d5e7cee918c6cf8f35ce685, migration blob 59264d8af2382dd0d69fa4e0b51c50fe390ffaca, SHA256 93fca8ba037142c051055f508a61cd21bed1a74bd5cead515096d0dc83a7d8a0. Hash/blob/clean identity verified; py_compile, both source tests (via Node strip-types), and diff-check pass. Behavioral fixture, reconciler apply=true, final parity, and metadata preservation are present. Remaining blocker: prior audit requirement to count exactly one installed rutap.reconciliar_snapshot overload is absent; artifact only asserts to_regprocedure(integer,boolean) exists and retired helper is absent. Add pg_proc name-count=1 while preserving exact-signature assertion, refreeze, and do not rehearse current bytes.
• wi-cli-venus audit-finding · 3w ago
  HOLD on frozen commit 173e20603ef00e4b5d5e7cee918c6cf8f35ce685: artifact proves reconciliar_snapshot(integer,boolean) exists and retired reconciliar_estado_abierto_snapshot is absent, but does not prove exactly one rutap.pg_proc row named reconciliar_snapshot exists. Add fail-closed count=1 over pg_proc/pg_namespace and assert that sole OID equals to_regprocedure('rutap.reconciliar_snapshot(integer,boolean)'); update focused source test; refreeze commit/blob/SHA before any DB rehearsal.
• wi-cli-venus commit · 3w ago
  Corrected exact artifact at 499b9f047e2c6539057c8fec9f44a61567cee8a9 (blob 941231a7254cad1ce8ec5a81adc9e8891f0be5ca, SHA256 8034629632268afe606a211c7801a1b91e9e6540ef06eb49f81f45d83ca2e621): fail-closed count=1 across rutap.reconciliar_snapshot overloads plus sole OID/signature match. Focused source test PASS. Audit released DEV apply=false rehearsal; db02 assigned.
• wi-cli-venus verified · 3w ago
  Audit exact-byte PASS for commit 499b9f047e2c6539057c8fec9f44a61567cee8a9, blob 941231a7254cad1ce8ec5a81adc9e8891f0be5ca, SHA256 8034629632268afe606a211c7801a1b91e9e6540ef06eb49f81f45d83ca2e621. Released DEV apply=false rollback rehearsal only: exact-one reconciler name/OID/signature gate, exact-body transform, metadata preservation, controlled old-W5 fixture, reprojection plus sole reconciler parity, SAVEPOINT rollback, no CASCADE.
• wi-cli-venus audit-finding · 3w ago
  DEV apply=false rehearsal SAFE FAILURE on exact 499b9f047e2c6539057c8fec9f44a61567cee8a9 / blob 941231a7254cad1ce8ec5a81adc9e8891f0be5ca / SHA256 8034629632268afe606a211c7801a1b91e9e6540ef06eb49f81f45d83ca2e621. psql variables inside dollar-quoted DO bodies are not interpolated; first abort at line 249 on :m518_snapshot_id, with the same defect in fixture_w5, behavior and parity blocks. ON_ERROR_STOP rolled back; fresh projector identity unchanged e6946b26/69b24054, reconciler count 1, retired helper 0. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-rollback-rehearsal-safe-failure-db02-mba-l-ca.md SHA256 629c8d95d89e1b09ddcfb235035d809f51b8608563d4518699902bcfb9e5072b. Correct/refreeze/re-review; do not rerun these bytes.
• wi-cli-venus audit-finding · 3w ago
  AUDIT RELEASE REVOKED 2026-09-20 for MOVILBA-518 exact artifact 499b9f047e2c6539057c8fec9f44a61567cee8a9 / blob 941231a7254cad1ce8ec5a81adc9e8891f0be5ca / SHA256 8034629632268afe606a211c7801a1b91e9e6540ef06eb49f81f45d83ca2e621. DEV rollback rehearsal safe-failed because psql does not interpolate :m518_* variables inside dollar-quoted DO bodies (fixture_pre, fixture_w5, behavior, parity). ON_ERROR_STOP rolled back and fresh state is unchanged. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-rollback-rehearsal-safe-failure-db02-mba-l-ca.md SHA256 629c8d95d89e1b09ddcfb235035d809f51b8608563d4518699902bcfb9e5072b. Fix with SQL-visible temp control state read inside each DO, refreeze, re-review; do not rerun revoked bytes.
• wi-cli-venus commit · 3w ago
  DEV rollback rehearsal safe-failed without mutation on revoked 499b9f04/80346296 (evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-rollback-rehearsal-safe-failure-db02-mba-l-ca.md SHA256 629c8d95d89e1b09ddcfb235035d809f51b8608563d4518699902bcfb9e5072b). Corrected dollar-quoted DO variable scope via transaction-local m518_fixture_control; frozen clean artifact ec1956ab5cd47831e665289bed52a94bf6941ad4 / blob f4fdf36c8868f0816fb16a4db123af573e9e71d0 / SHA256 8e3f229a9a8150856ae7f053680b1dd831ab47fa779697ce6741e9548d1c5fb0. Focused gates PASS; audit re-review requested; no DB rerun yet.
• wi-cli-venus verified · 3w ago
  Audit released corrected exact ec1956ab5cd47831e665289bed52a94bf6941ad4 / blob f4fdf36c8868f0816fb16a4db123af573e9e71d0 / SHA256 8e3f229a9a8150856ae7f053680b1dd831ab47fa779697ce6741e9548d1c5fb0 for DEV apply=false rollback rehearsal only. Verified SQL-visible transaction-local control table, SELECT INTO STRICT in DO blocks, zero :m518_ inside dollar-quoted bodies, focused test 1/1, py_compile and diff-check; no CASCADE. Revoked old 499b9f04/80346296 must not rerun.
• wi-cli-venus verified · 3w ago
  CORRECTION: prior ec1956ab/8e3f229a rehearsal release revoked due missing exact-one gate on replaced projector. Audit now releases exact e8d2b7203fc186425f4945b071f8f9f806a65467 / blob f4f2adad3b210b4094ed79613680993654172cbf / SHA256 7929a44478098feafeef4b1e4a914a58b9e791e43c9e9a774171bbbe351cc7c6 for DEV apply=false rollback rehearsal only. PRE+POST enforce exactly one rutap.proyectar_snapshot, sole bound OID, bigint signature, and definition reads by bound OID. Harness fix intact; focused test, py_compile, diff-check PASS.
• wi-cli-venus verified · 3w ago
  DEV rollback rehearsal PASS for exact hardened e8d2b720/f4f2adad/7929a444. Controlled W5 sentinel passed: projector 5514=5514, conflicts=0, abiertas_sin_estado=0; reconciler 2413=2413, gate_not_null=0, emissions=0; metadata checks passed; ROLLBACK TO SAVEPOINT plus final ROLLBACK. Fresh state projector e6946b26, reconciler 2b7e946f, counts 2445/2445/history5618, W5=2 restored. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-rollback-rehearsal-db02-mba-l-ca.md
• wi-cli-venus verified · 3w ago
  DEV apply PASS exact e8d2b720/f4f2adad/7929a444. Controlled W5 sentinel passed, savepoint rollback restored data, COMMIT installed projector only. Fresh projector functiondef ca89b7fe, prosrc b8287b51; reconciler b2547bbb; exact-one both=1; retired=0; counts 2445/2445/history5618; W5 2->2. Old-projector negative W5 control still required before PROD. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-apply-db02-mba-l-ca.md
• wi-cli-venus note · 3w ago
  Negative W5 fixture authored: docs/migrations/2026-09-20-movilba-518-w5-negativo-fixture-DEV-ROLLBACK-ONLY.sql SHA256 ad5c2cb2, commit f3c4a183 on dev/lezama/origin. Old body obtained by inverting 518's own literals against the live hardened body, accepted only on md5(pg_get_functiondef)=e6946b269ad1742208c414cf1af22026 (518's frozen PRE pin). Git-history route is unavailable: 479 is the last verbatim body, 514 and 518 both replaced by text substitution. Rollback-only, no apply mode. With audit-mba-l-ca.
• wi-cli-venus note · 3w ago
  Audit (audit-mba-l-cc) RELEASED the W5 negative fixture ad5c2cb2 / f3c4a183 for DEV rollback-only. Non-blocking notes closed: source test tools/import/movilba-518-w5-negative-fixture-source.test.ts SHA256 18bbc50f, commit c2b15df9, asserts literal byte-equality with the released 518 artifact and was seen to FAIL on a one-space perturbation; SAVEPOINT left as released so the reviewed bytes are the executed bytes. db02-mba-l-ca to execute.
• wi-cli-venus note · 3w ago
  DEV W5 negative fixture PASS by db02-mba-l-ca on the released bytes ad5c2cb2 (f3c4a183); audit ACCEPTED. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-518-dev-w5-negative-fixture-db02-mba-l-ca.md SHA256 0be7b3d1, re-hashed by coder03 and matching. Old reconstructed body raised the exact MOVILBA-269/333 W5 error for 1 contradiction (AA013AA/3344); hardened body projected 5528 over the SAME contradiction; ROLLBACK; fresh state b8287b51/ca89b7fe, exact-one=1, 2413/2413/5528, AA013AA back to ALTA, W5=0. The W5 removal is now a control seen to fail and to pass on DEV. PROD remains gated on 514 apply=true first, then separate PROD rehearsals with their own pre-md5 pins.
• coder04-mba-l-ca progress · 3w ago
  coder04-mba-l-ca | 2026-09-24 04:01 ART. Measured installed rutap.proyectar_snapshot(bigint) by read-only pg_get_functiondef in both movilba_dev and movilba: exact old W5 abort phrase whose live ficha is not ALTA absent on both. BWI has DEV negative-control PASS, but this pass did not exercise a PROD negative control or dependent 514 gate; leaving inProgress on parked coder03-mba-l-ca pending DB verification.
• coder03-mba-l-cc assigned · 2w ago
  coder03assistant-mba-l-ca
• coder03assistant-mba-l-ca progress · 2w ago
  coder03assistant-mba-l-ca | 2026-09-28 13:56 ART — Read current BWI chain. The DEV W5 positive/negative controls are already recorded; outstanding gate is the separate PROD negative-control rehearsal after the required PROD MOVILBA-514 prerequisite, and that is DB-lane work. Referred the exact gate to db04-mba-l-ca; no database access or writes from this coding lane.
• db04-mba-l-ca progress · 2w ago
  db04-mba-l-ca 2026-09-28 14:06 ART. Read-only PROD movilba installed check (current_database() first): rutap.proyectar_snapshot(bigint) prosrc md5 9692440fbef91143dac23c97d93af8b4; old W5 RAISE phrase 'whose live ficha is not ALTA' position 0; MOVILBA-518 replacement comment present, followed by W5/post-516 flow. MOVILBA-514 PROD gate was historically satisfied (514 BWI completion 2026-09-20), but 607 later reversed the dedicated air catalog: current opciones has shared 24 SI/25 NO, no 126/127, and projector uses v_si_id rather than v_aire_si_id. The released 2026-09-20 DEV negative fixture is DEV-only and pins prosrc b8287b51 plus functiondef ca89b7fe; it cannot be run against current PROD and must not be repurposed as a PROD control. PROD's absence of the W5 branch is measured, but no independent PROD negative-control rehearsal was exercised. Any such control requires a new rollback-only instrument constructed against the current 607/579 projector body, not the stale 514-era artifact. No DB writes.
• coder03assistant-mba-l-ca completed · 1w ago
  Installed PROD projector has the retired W5 abort absent and the MOVILBA-518 replacement present; PROD/DEV/pod all run v5.6.161. Historical DEV negative control passed. LIMIT: a new rollback-only PROD negative-control rehearsal against the post-607 function was not exercised; stale DEV fixture must not be replayed.