estandar_emisiones_id has no gate in the import

Sub-tickets

Activity

• wi-cli-venus created · 3w ago
• wi-cli-venus assigned · 3w ago
  coder02-mba-l-ca / coder
• wi-cli-venus statusChanged · 3w ago
  coder02-mba-l-ca implementing the estandar_emisiones_id import gate and focused coverage
• wi-cli-venus commented · 3w ago
  New immutable MOVILBA-521 migration ready for audit: historical 486 byte-clean; raw_tipo_motor→estandar_emisiones_id gate + postcondition; live read-only DEV/PROD pre-hash b5b83c4063ac6fa5bf06f6354078a019; new body post-hash 9a2495e4480eeb00159b287e258f48aa; OID/owner/ACL/comment/execution attributes pinned; focused source test 4/4 pass; audit handoff sent to audit-mba-l-cc and audit-mba-l-ca. No DB mutation/import.
• wi-cli-venus commented · 3w ago
  db02 independently validated the expected new pg_proc.prosrc MD5 9a2495e4480eeb00159b287e258f48aa in isolated ephemeral PostgreSQL 17 (36085 octets), with no DEV/PROD mutation. Migration metadata lookup refined to to_regprocedure; current sha256 7fd332c6db6f4d6b93154ad38d7283d1c11441359cef96283878d30c17c7264d; audit updated.
• wi-cli-venus note · 3w ago
  AUDIT TRIAGE - Coder batch #1. Finish the existing estandar_emisiones_id import gate and focused regression coverage using the already frozen migration and hashes. Blocker: preserve immutable artifact identity and obtain DB-lane rehearsal/apply evidence; do not hand-edit DB state. Estimate: 0.5-1.5h.
• wi-cli-venus audit-finding · 3w ago
  AUDIT HOLD 2026-09-20: substantive migration review passes, but requested immutable identity e19c32bc is stale. Clean coder02 worktree HEAD is 2f7682e001742763c314666108c1199a87eecf07 and e19c32bc is not its ancestor. Migration bytes remain blob 7c1b91c71091f57db089662a90a1fc3e8c354093 / SHA256 7fd332c6db6f4d6b93154ad38d7283d1c11441359cef96283878d30c17c7264d; current focused source test passes 5/5. Require refrozen current commit/blob/SHA and clean status before any DB evidence or rehearsal.
• wi-cli-venus verified · 3w ago
  AUDIT 2026-09-20: identity refrozen and source review PASS at clean HEAD 2f7682e001742763c314666108c1199a87eecf07, migration blob 7c1b91c71091f57db089662a90a1fc3e8c354093, SHA256 7fd332c6db6f4d6b93154ad38d7283d1c11441359cef96283878d30c17c7264d; focused tests 5/5. e19c32bc superseded. Released read-only DEV/PROD installed-function pre-evidence only; no write or rehearsal.
• wi-cli-venus audit-finding · 3w ago
  DB read-only PRE evidence: current data resolves emissions fully (DEV snapshot16 2413/2413, PROD snapshot5 2413/2413; 0 unresolved), but frozen artifact is incompatible with PROD. DEV installed prosrc MD5 b5b83c4063ac6fa5bf06f6354078a019 matches PRE; PROD post-516 body is 2b7e946f835170839b0f75d950c85f23. Rebase onto post-516 definition; do not weaken hash or apply unchanged older full-function body. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-521-installed-function-pre-evidence-db02-mba-l-ca.md SHA256 f63d046922045692344ef04415bf2cc8a26ee75907e38a921843ecb771e29177.
• wi-cli-venus audit-finding · 3w ago
  READ-ONLY PRE REVIEW 2026-09-20: evidence SHA256 f63d046922045692344ef04415bf2cc8a26ee75907e38a921843ecb771e29177 verified. Data premise passes in DEV and PROD: ranked source 2413/2413, nonblank raw_tipo_motor 2413/2413, unresolved emissions IDs 0/0, ID-without-raw 0/0. Frozen artifact 2f7682e0 / 7c1b91c7 / 7fd332c6 is HOLD because its full-function PRE/body is based on DEV MD5 b5b83c40 while PROD has newer post-516 MD5 2b7e946f. Do not weaken hash or rehearse/apply old full-body replacement. Rebase emissions-only change on current post-516 function, preserve unrelated logic/metadata, refreeze, and re-review.
• wi-cli-venus progress · 3w ago
  Rebased the emissions gate onto the exact post-MOVILBA-516 reconciler. Commits f5c7bd26 + 1533e456; PRE pins 2b7e946f835170839b0f75d950c85f23, POST pins b2547bbb33d069b287d79acfa5c14de0. Function-body delta is limited to emissions resolution gate, removal of obsolete sin_compuerta report, and emissions apply postcondition. Focused source tests 6/6 pass; audit requested from audit-mba-l-cc. DEV must receive/verify MOVILBA-516 first because fresh evidence still shows its pre-516 body; PROD is on the required base.
• wi-cli-venus verified · 3w ago
  db03 read-only semantic diff confirms DEV prosrc b5b83c4063ac6fa5bf06f6354078a019 versus PROD post-516 2b7e946f835170839b0f75d950c85f23 is material, not formatting. PROD includes origin-agnostic candidate deletion, validadoras component cleanup, app/import wide-history deletion, archive/audit cleanup, six trigger identity/restoration guards, removal of legacy origen brake, and expanded postconditions. Thus 521 strict PRE 2b7e is correct; DEV must receive/verify frozen MOVILBA-516 first. db03 was asked to run the DEV-only prerequisite then independently rehearse 521; PROD unchanged.
• wi-cli-venus audit-finding · 3w ago
  A delayed audit PASS for superseded HEAD 2f7682e0 / SHA 7fd332c6 was explicitly revoked in-thread after post-516 semantic evidence. That artifact must not be rehearsed/applied. Only HEAD 1533e456 / SHA 8d977ae0d9c15b3f21ea64e671d6198d64280ac8e166031d48be87b21f7609ab is current and awaits audit-mba-l-cc. Parked db03-ca redirected DB execution to active db03-mba-l-cc; exact prerequisite/rehearsal handoff sent there. DEV must receive frozen 516 first; PROD unchanged.
• wi-cli-venus progress · 3w ago
  Active db03-cc independently verified DEV=b5b83c40, PROD=2b7e946f, frozen 516 identity f872859a/SHA 87a4e54d, and current 521 clean identity 1533e456/blob 48ca4e4c/SHA 8d977ae0. Ownership clarified: db02-ca performs DEV writes/rehearsals. Coordinated request sent: db02 applies frozen 516 to DEV while audit-mba-l-cc exact-byte reviews current 521; 521 remains unreleased until new audit PASS. PROD unchanged.
• wi-cli-venus verified · 3w ago
  MOVILBA-516 DEV prerequisite complete and independently audited. Evidence SHA b7d7091d8704d73c181ccfe08a1180c522b3c26755d33c2c4510e2c83234b5bd. Audit-requested exact side-by-side live query now returns identical identities: DEV movilba_dev|prosrc 2b7e946f835170839b0f75d950c85f23|functiondef 85fd83e2ac82c0e598305acb326e9186; PROD movilba|same hashes. Current 521 bytes independently derive POST b2547bbb33d069b287d79acfa5c14de0. 521 and 517 are cumulative function replacements: mandatory order 521 first, then 517 tip 06feb041; both remain held until audit releases 521.
• wi-cli-venus audit-finding · 3w ago
• wi-cli-venus audit-finding · 3w ago
  AUDIT SOURCE HOLD 2026-09-20 on current exact artifact HEAD 1533e4562db3fc1eaa0ac352c70da2f491aa6c7a / blob 48ca4e4cf092300bad9c6c60dd2083d4a27df0dc / SHA256 8d977ae0d9c15b3f21ea64e671d6198d64280ac8e166031d48be87b21f7609ab. Exact body diff against frozen MOVILBA-516 is correctly limited to the emissions resolution gate, removal of sin_compuerta, and emissions postcondition; metadata preservation, named trigger identities, no CASCADE, and defer_end are present. Defect: PRE does not require exactly one rutap.reconciliar_snapshot by name, and POST selects pg_proc by namespace+proname without cardinality/signature, so an unexpected overload can be silently selected. Require count(*)=1, sole OID=to_regprocedure(integer,boolean), OID-bound post-read, and focused tests. The DEV/PROD identity discrepancy is now resolved by the exact side-by-side query already recorded: both are prosrc 2b7e946f / functiondef 85fd83e2. Supersede 1533e456 after fix; no rehearsal/apply of these bytes.
• wi-cli-venus audit-finding · 3w ago
  Audit HOLD on exact artifact 1533e456/8d977ae0: PRE/POST do not enforce exactly one rutap.reconciliar_snapshot by name nor prove sole OID equals integer,boolean regprocedure. Artifact revoked; coder02 instructed to correct both gates, add cardinality/OID/signature tests, refreeze, and request audit. Identical live query confirms DEV and PROD both prosrc 2b7e946f835170839b0f75d950c85f23 and functiondef 85fd83e2ac82c0e598305acb326e9186. No DB execution.
• wi-cli-venus progress · 3w ago
  Superseding exact-one artifact frozen: commit d2cb1734cb8e17259222a08b48096b2ea51b739c, migration blob 414d730e26a245403ab9374a7ddf689a7b996936, SHA256 275ed8e8dec24659356e381c024dee19f9e286445a24f22ac219a3dc813446e8. PRE/POST enforce count=1 by schema+name, sole OID = expected (integer,boolean) signature, then use bound OID. Function body unchanged MD5 b2547bbb33d069b287d79acfa5c14de0. Focused source tests 7/7 and diff-check pass; clean tree. Audit requested; DB execution held.
• wi-cli-venus verified · 3w ago
  Superseding exact artifact independently source-verified: d2cb1734cb8e17259222a08b48096b2ea51b739c / blob 414d730e26a245403ab9374a7ddf689a7b996936 / SHA256 275ed8e8dec24659356e381c024dee19f9e286445a24f22ac219a3dc813446e8. PRE/POST exact-one schema+name, sole-OID and integer,boolean signature checks present; body unchanged b2547bbb; focused tests 7/7; tree clean. No DB execution pending audit release.
• wi-cli-venus verified · 3w ago
  Audit released exact d2cb1734cb8e17259222a08b48096b2ea51b739c / blob 414d730e26a245403ab9374a7ddf689a7b996936 / SHA256 275ed8e8dec24659356e381c024dee19f9e286445a24f22ac219a3dc813446e8 for DEV apply=false rehearsal only. PRE/POST exact-one schema+name count and signature OID binding verified; body b2547bbb unchanged; focused tests 7/7 and diff-check pass.
• wi-cli-venus progress · 3w ago
  Audit PASS: exact d2cb1734 / blob 414d730e / SHA256 275ed8e8 released for DEV apply=false rollback rehearsal only. Artifact PRE is already pinned to post-516 prosrc 2b7e946f; POST expects b2547bbb. db02 instructed to recheck exact live identity then return PRE/POST/ROLLBACK/fresh unchanged evidence. apply=true remains held; 517 remains after 521 apply/fresh proof.
• wi-cli-venus verified · 3w ago
  DEV rollback rehearsal PASS for exact d2cb1734/414d730e/275ed8e8. PRE 2b7e946f/85fd83e2; in-tx POST b2547bbb/4ddc0459; snapshot16 dry-run 2413=2413, gate_not_null=0, emissions changes=0, no writes; explicit ROLLBACK; fresh 2b7e946f/85fd83e2 and 2445/2445 restored. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-521-dev-rollback-rehearsal-db02-mba-l-ca.md SHA256 c58ec21f6487073dd93f614deccb57e865645fbf186ab2294374c97c6763a3f1. Await independent review before apply.
• wi-cli-venus progress · 3w ago
  DEV rollback rehearsal PASS on exact d2cb1734/275ed8e8. PRE 2b7e946f; in-tx POST b2547bbb; snapshot16 dry-run 2413 rows, gate_not_null=0, emissions changes=0, no writes; explicit rollback; fresh reconnect restored 2b7e946f and 2445/2445 counts. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-521-dev-rollback-rehearsal-db02-mba-l-ca.md SHA256 c58ec21f6487073dd93f614deccb57e865645fbf186ab2294374c97c6763a3f1. Audit review requested; apply=true not performed.
• wi-cli-venus verified · 3w ago
  Audit reviewed DEV rollback rehearsal evidence SHA256 c58ec21f6487073dd93f614deccb57e865645fbf186ab2294374c97c6763a3f1: exact d2cb1734/414d730e/275ed8e8, PRE/POST gates PASS, snapshot16 dry-run 2413/2413 and NOT NULL gate 0, explicit rollback, fresh state exactly restored. Released DEV apply=true for exact bytes only; require COMMIT and fresh identity/runtime proof. No PROD action.
• wi-cli-venus note · 3w ago
  Coverage qualification: DEV rehearsal had 0 estandar_emisiones changes, so the new rejection branch was not behaviorally exercised. This does not block released DEV install, but a controlled negative fixture demonstrating abort+rollback is required before PROD apply/release. Do not cite the zero-change dry-run as gate proof.
• wi-cli-venus verified · 3w ago
  DEV apply PASS exact d2cb1734/414d730e/275ed8e8. COMMIT. Fresh reconciler prosrc/functiondef b2547bbb/4ddc0459, owner movilba_user, exact-one=1, retired=0. Runtime dry-run s16 2413=2413, NOT NULL=0, emissions changes=0/no writes; counts remain 2445/2445. Negative emissions fixture still required before PROD. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-521-dev-apply-db02-mba-l-ca.md
• wi-cli-venus progress · 3w ago
  DEV apply=true PASS/COMMIT exact d2cb1734/275ed8e8. Fresh prosrc/functiondef b2547bbb/4ddc0459, owner movilba_user, exact-one=1, retired=0, counts 2445/2445; dry-run 2413/2413, no writes. Evidence /data-lezama/movilba-web/evidence/2026-09-20-movilba-521-dev-apply-db02-mba-l-ca.md SHA256 bf2a3ba464e1ee77f4b69f0d704a9dc9f9365dd8fc83f52655020f3f93967515. Audit review requested. PROD remains blocked pending controlled negative fixture proving emissions gate abort+rollback.
• wi-cli-venus progress · 3w ago
  Prepared DEV-only rollback negative fixture; it proves healthy ENSAYO has zero gate rows, forced NULL emits exactly one emissions gate report, then apply=true raises before DML. Focused source tests 8/8 and diff-check pass; exact-byte audit review requested before db02 execution.
• wi-cli-venus verified · 3w ago
  Audit PASS/RELEASE: DEV-only rollback negative fixture exact SHA256 45620b9252a1f054bf8571176fd49188fbebcfbee26f6df37868e4b318346cb1 handed to db02 for execution. PROD remains held pending fresh restoration evidence.
• wi-cli-venus verified · 3w ago
  DEV rollback-only negative fixture PASS: baseline gate=0; controlled emissions NULL produced one report and exact apply=true rejection; rollback fresh proof restored post-517 function identity and 2413/2413/5528 counts. Evidence SHA256 77210fc896b87068ae7fb202ca1ed9e863607cb5d94e306dad029ac8acbdd9dc. PROD remains held pending release.
• wi-cli-venus note · 3w ago
  Released migration landed on dev in c7bfcdc1 (dev/lezama/origin): docs/migrations/2026-09-19-movilba-521-emissions-gate-DEV-Y-PROD.sql blob 414d730e SHA256 275ed8e8, plus tools/import/reconciliar-snapshot-emissions-gate-source.test.ts, both from coder02's released tip d2cb1734 and re-hashed after checkout; companion test 7/7. dev carried no 521 file while DEV runs the gate. Landed by blob, not by merge: that branch forks at 77cc3cb7 and merging it would drag 67 files including tools/rutap-snapshot-import.py, reverting the executable importer of 3b817b32. PROD chain established from the bytes: PROD 2b7e946f -> 521 -> b2547bbb -> 517 -> cd18795a, so 521 precedes 517 on PROD and neither pin needs re-freezing.
• wi-cli-venus verified · 3w ago
  audit-mba-l-cc VERIFICO el landing c7bfcdc1: 2 archivos, blob 414d730e/SHA256 275ed8e8 y test blob 8d4bd6c8 identicos a d2cb1734; landing por blob aceptado frente al riesgo de arbol viejo de 67 archivos. 527 cerrado del lado de audit (af057581). Gate PROD sin cambios: ensayo rollback superuser de db03 sobre 2b7e946f con los bytes de c7bfcdc1, despues apply pedido por coder.
• wi-cli-venus commit · 3w ago
  Fixture negativo ejecutable landeado en dev: a6dab614 (dev/lezama/origin). Bytes ejecutados por db02, re-hasheados tras la copia: SQL 7fd55fb5b79b2a4770e668524ba12f375f10a1298088a4191cae332804c36743, test 54ab5fd0fb83f59f8cb765763c3e4b46cfa938f755523c06a58a695ce4a526ef; evidencia 77210fc896b87068ae7fb202ca1ed9e863607cb5d94e306dad029ac8acbdd9dc. Test focalizado pasa en dev. CAVEAT: pinea el reconciliador DE DEV (prosrc cd18795a / functiondef f587f087, cuerpo post-517); PROD sigue en 2b7e946f, asi que este fixture NO corre contra PROD y no es parte de la cadena de ensayo PROD de 521.
• coder03-mba-l-cc assigned · 2w ago
  coder03-mba-l-cc
• coder03-mba-l-cc assigned · 2w ago
  db04-mba-l-ca
• db04-mba-l-ca verified · 1w ago
  2026-10-05 SELECT-only live check: both installed rutap.reconciliar_snapshot bodies now include estandar_emisiones_id in the raw-present/typed-NULL gate (PROD prosrc lines 117-165, DEV equivalent), the change count (PROD line 215), UPDATE SET (line 557), comparison tuple (lines 569/575), and postcondition (lines 780/783). PROD snapshot 8 and DEV snapshot 20 each have 5,548 normalized rows, 5,548 resolved emissions IDs, and 0 with nonblank raw_tipo_motor plus NULL estandar_emisiones_id. Historical BWI event 2026-09-20 records a DEV rollback mutant that forced one NULL and observed apply=true rejection; no new mutant was run today and PROD mutant remains unexercised. The original missing-gate defect no longer reproduces; no DB write.
• db04-mba-l-ca completed · 1w ago
  Installed PROD and DEV reconciliation now gates nonblank raw_tipo_motor with unresolved estandar_emisiones_id, synchronizes the ID, and postchecks it. Current snapshots are 5548/5548 resolved in each base with zero gate failures. DEV negative control is recorded from 2026-09-20; PROD negative mutant not newly exercised, disclosed in verified event. No remaining missing-gate implementation.