fix/durable-tab-versions
No handoff yet. An agent working here writes one with amadan branch handoff, so that whoever picks the branch up next — a person, or another agent on another machine — can start without reading the whole history.
Recently
READ-ONLY focused Fable revised SPEC / atomic CODE re-review. Repo /home/paulca/amadan.net/oficina/sheets-core/.claude/worktrees/overnight-versions exact HEADd35cf94. Prior verdict /tmp/sheets-atomic-inherited-fable-review.json: server correct, two blockers missing committed browser queue checks and stale comments. Review git diff1aca44c..HEAD (space after diff): tools/drive/batch-checks.mjs now drives real native paste500 then cut>500 with forced first500 response, awaits actual queue barrier (no arbitrary delay), asserts no second chunk. Invoked by existing clipboard.mjs and committed HTTPS exactcanary/candidateSHA/private-auth-state/signinPOST-refusing canary-batch.mjs. Local actual-browser check using same helper passed; mutation replacing `if (ok === true) return step();` with unconditional `return step();` is caught specifically by failed-first-chunk assertion. Evidence /tmp/sheets-browser-queue-local-result.json and /tmp/sheets-browser-queue-local.log. Local harness is /tmp/sheets-queue-local-check.mjs if needed, but contains only synthetic runtime config; do not print auth logs. Comments now preserve both discarded-response and refetch races and explain serial atomic chunks; clipboard behavior unchanged. Spec revision3 names browser deployed gate and requestbound/investigationthresholds. Full currentmake test /tmp/sheets-atomic-r3-full.log, exact-headCI check via read-onlyamadan if needed. Explicit APPROVE or REQUEST CHANGES for revised SPEC and ATOMIC CODE; deployed canary/copy/reconciliation prerequisites remain unchanged. No edits/deploys/unrelatedreview.
READ-ONLY Fable revised SPEC and full ATOMIC code review; no edits/deploys. Exact repo /home/paulca/amadan.net/oficina/sheets-core/.claude/worktrees/overnight-versions HEAD1aca44c. Atomic implementation37c8055 inherits main4aea8f4; durable watermark on top has separate Fable design/code approvals /tmp/sheets-durable-versions-fable-review2.json and /tmp/sheets-watermark-code-review.json. Read AGENTS.md, docs/superpowers/specs/2026-09-07-atomic-cell-batch.md revision2, original REQUEST CHANGES /tmp/sheets-batch-spec-review.json, and all atomic diff4aea8f4..37c8055 (space after diff). Review handlers_cell_batch.go/app route, store/handle_write_batch.go, cellqueue.js/grid.js and their tests; assess against current watermark implementation1aca44c. Original five requests addressed: transaction-scoped recovery, measured50k/200k writer cost, immediate postcommit live swap, merged5000-cell report cap, stale-recovery regression with mutation proof /tmp/sheets-batch-mutation.log. Full current1aca44c make test and exact-head CI passed. Verify batching final formula values/clear/rollback/events, bounds/auth/copy translation, live publication/order and browser queue failure semantics. Explicit verdicts for revised SPEC and ATOMIC CODE. This code inherited a branch is not presumed reviewed. Human-copy gate unaffected (existing fixed strings only); production requires separately-approved reconciled chrome a75c7a9 plus its pendingcopy, and deployed canary browser gate remains pending. Isolated atomic-only canary may certify batch+durable code without changing production after root approves fixture. No unrelated tabs/bootstrap review in this pass. Keep blockers actionable with exact lines.
READ-ONLY Fable DESIGN review; no edits/deploys/secret reads. Repo /home/paulca/amadan.net/oficina/sheets-core/.claude/worktrees/overnight-versions exact HEAD1aca44c. Read AGENTS.md and docs/superpowers/specs/2026-09-07-canary-fixture-bootstrap.md. Root authorized isolated canary environment overnight-batch at overnight-sheets.bds.oncarlos.com, owners oficina-fixture@example.test, fresh keys provisioned. No SMTP sandbox response; fixture must certify normal persisted-session validation/editor only, never email delivery. Assess startup-only temporary bootstrap with existing BootSchema + single ordinary session hash, exact origin/compiled runID/owner, empty content/member/grant/session DB precondition, exact verified exec-child --socket and --db paths (missing STATE_DIRECTORY not fatal), replacement by unchanged candidate before any browser assertion, exact process SHA and channel proof, normal signout/teardown. Platform current source /home/paulca/amadan.net/carlos/platform if needed; discover ExecBackend.Start/Seed contract read-only, never read secrets.json. Session schema/validation in pinned rastrillo dependency. Candidate contains no auth or fixture backdoor. Bootstrap implementation does not exist yet. Explicit APPROVE or REQUEST CHANGES for design; name minimal missing guards/tests, avoid hypothetical unrelated mechanisms. Root must confirm actual /data/... DB path before building exact guards; native seed alternative is optional and not deployed. This review must not waive later code/test/deployment gates.
READ-ONLY focused Fable design re-review, no edits/deploys. Repo /home/paulca/amadan.net/oficina/sheets-core/.claude/worktrees/overnight-versions exact HEAD9f6abe2. Read your prior review /tmp/sheets-durable-versions-fable-review.json result, then git diff91e9991..HEAD (insert space after diff). Revision2 spec and regressions now address your four required amendments: MAX SQL + missing-tab Open, snapshot continuity/capped-blank watermark/retained-batch rollback tests, pinned namespace-qualified pre-watermark migration IDs and migration check gate. Capped-blank mutation will run after implementation exists. Explicit APPROVE or REQUEST CHANGES for DESIGN before implementation; current missing-column/version regression tests remain intentionally failing. Inspect exact touched files; ignore separate fixture/tabs/reconciliation designs. Keep response focused on blockers.
READ-ONLY Fable spec review; no edits/deploys. Repo /home/paulca/amadan.net/oficina/sheets-core/.claude/worktrees/overnight-versions at91e9991. Read AGENTS.md and docs/superpowers/specs/2026-09-07-durable-tab-versions.md. Review against store/handle_open.go, handle_set.go, handle_report.go, handle_write_batch.go, models.go and new handle_version_watermark_test.go/handle_version_migration_test.go. Atomic batch candidate37c8055 is blocked by real version regression: paste500=503, clear500=1004, next edit=4 after handle reopen; single clear3/5/2 and crash-after-blank3/2 also fail. Proposed additive Tab.ContentVersion watermark persists with input/recalc tx and survives cell deletion; batch rollback must revert it. Assess minimal correct fix, migration preservation, every mutation/recovery path, lock safety and missing regression cases. APPROVE or REQUEST CHANGES. This is design review before implementation, not a deployed-canary claim. Ignore separate workbook-tabs/fixture-bootstrap proposals in this pass.