Plan .claude/tasks/plans/2026-11-16-r3-sheet-list-0017.md: audit F1-F14,
three fresh challenges folded, owner answers D1-D7 and precisions P1-P4.
RR-13 scope widened to admin list paging (D4); D5 kept as a follow-up.
Owner U1 manual test 2026-11-12: a click outside any annotation must deselect. D6b supersedes D6's deferral to U2; code change and tests named, implementation awaits the go.
First create at 255dd67 done; post-create checks interrupted at check 3 (TR_PW in the db container log, written by the image's init). Contract records the owner's arbitrations of 2026-11-11; TODO lists the follow-up lots.
Post-create scan covers pg_stat_statements and labels each count; log path defined; rotate-secrets 401 window documented; plan shows image state unknown without a daemon; start_containers checks the app host before recreating GoTrue; truthful restore and destroy way-out messages; harness checks read stdin from /dev/null. Harness 372/0.
Strict absent detection (stderr sentence per kind, measured on Docker 29.9.3), tri-state container_running, empty-volume check before restore, quieter DB init and rotation logging, backup/migrate refuse while the app runs, lock first in start/stop, truthful rotate-secrets and post-create checks. Stub reproduces Docker's stdout/stderr split. Harness 364/0.
account: confirmed account through GoTrue's admin API, hidden password typed
twice. grant: owner/admin by the operator path (factors counted in SQL and again
in the transaction, names sanitised); catalogue rights mirror grant_catalog_right
(admin first for sheet_editor), audit row, no implicit admin. Every grant typed
at a terminal. assets: R5.5 tool through the gateway. app: Vite stopped and
waited on exit. 323 stub-only harness cases.
Cold read-only backups proven before any change (checksums covering
the folder, entry counts, keys, images); typed confirmations at a
terminal only; rotate-secrets in one explicit transaction with a commit
marker, no secrets.prev; destroy refuses without a restorable backup and
names the manual way out. Harness: 210 stub-only cases.
scripts/db-trial.sh builds the persistent manual trial stack on
literal faunosteo_trial_* names, loopback 58xxx ports, named volumes
and a 700 state folder outside any git work tree; it refuses
SANDBOX_* variables, a remote Docker daemon, a missing or failing
ss, and checks each container's exact loopback publication and the
gateway identity. The stub harness (scripts/db-trial-check.sh,
87 cases, no daemon reachable) proves it; db-sandbox.sh refuses a
trial state folder (additions only). Nothing is created here.
BDR-106 owner decisions at the U1 checkpoint; TODO U1 line closed up
to the open owner checkpoint, admin.spec:717 confirmation and kept
reservations; RR-13 rights list server paging track; contract
clarification; journal.
The fresh verifier found three counter-check limits missing from the
owner trial list and five files added outside FILE SCOPE by lot rulings;
both recorded.