dot-iu-cutter v0.2 — P0-2 Dry-Run Artefact Index

document_path: knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/dot-iu-cutter-v0.2-p0-2-dry-run-artefact-index-2026-05-16.md
revision: r1
date: 2026-05-16
author: Agent (Claude Code CLI, Opus 4.7 1M)
phase: v0.2 — P0-2 DRY-RUN artefact index / chain of custody

---

§1 — Dry-Run Environment

container: pg-dry-run-v0.2-p0-2-2026-05-16   (FRESH sibling; postgres:16; no host port)
volume:    pg-dry-run-v0.2-p0-2-2026-05-16-data
db: directus   bootstrap_su: workflow_admin
system_identifier: 7640333723208519724   (≠ prod 7611578671664259111)
state_now: post-rollback == pre-P0-2 baseline (6 cutter_governance tables)
status: LEFT UP (not torn down — no teardown authorization; retained as evidence)
protected_envs_untouched:
  - pg-dry-run-hb05-2026-05-15
  - pg-dry-run-v0.2-phase-alpha-2026-05-16
production_untouched: true (postgres container; read-only pg_dump only)

§2 — Artefacts on VPS (/root/p0-2-dryrun/, host 38.242.240.89 / vmi3080463)

File	Bytes	SHA256	Role
dot-iu-cutter-v0.2-p0-2-r1.sql	5257	023a3be53c9d41c207cbfbae304f8e3d799f52bf90b951c20a625f9903e93eab	extracted r1 DDL (executed in dry-run)
prod-restore-source-2026-05-16.dump	64537613	69090bd7f96002b49fe42bfd46c1e423d3f092d2dec6c8fdab4b84827d49877a	prod pg_dump used to seed dry-run (v0.1+Phase α)
01-provision.sh	7370	provisioning + preflight script	identity-guarded
02-ddl-verify-rollback.sh	12109	DDL+verify+rollback (run 1; harness assert bug)	committed DDL rc=0
03-reverify-rollback.sh	9973	corrected re-verify + rollback (authoritative)	20/20 + rollback PASS
01-provision.log	1973	provisioning + preflight log	all PASS
02-ddl-verify-rollback.log	2462	run-02 log (DDL committed; 3 cosmetic fails)	DDL_RC=0
03-reverify-rollback.log	2047	run-03 log (authoritative verdict)	OVERALL PASS
pre_cg.txt / pre_cg_sorted.txt	138	pre-P0-2 cutter_governance baseline	RB-4 evidence
postrb_cg.txt	138	post-rollback cutter_governance	== pre (diff clean)
pre_v01.txt / post_v01.txt	112	v0.1 colcount pre/post	V-15diff evidence
restore.stderr	0	pg_restore stderr (empty = clean)	—

SQL artefact SHA256 verified equal across local authoring, scp transfer, and VPS at execution time (chain of custody intact). Revision r1 confirmed.

§3 — Provenance Chain

1_source: knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/
          dot-iu-cutter-v0.2-p0-2-ddl-draft-2026-05-16.sql.md  (GPT-PASSed r1)
2_extract: verbatim §2 fenced SQL → dot-iu-cutter-v0.2-p0-2-r1.sql
           sha256 023a3be5… ; comment-stripped = BEGIN;2×CREATE TABLE;COMMIT;
3_transfer: scp → VPS ; sha256 re-verified equal (no tamper)
4_provision: pg_dump prod (read-only) → restore into FRESH env (rc=0, stderr empty)
5_preflight: 8/8 PASS (identity, cg=6, manifests ABSENT, tac/sandbox state)
6_execute: psql -v ON_ERROR_STOP=1 -f r1.sql → BEGIN/CREATE/CREATE/COMMIT rc=0
7_verify: run-03 corrected → V-01..V-20 + aux = 20/20 PASS
8_rollback: drop child→parent (single tx rc=0) → cg bit-identical to pre baseline
9_prod_check: prod sysid + cg count + manifest ABSENT unchanged

§4 — Controlling Source Documents

gpt_ddl_authoring_review: knowledge/dev/laws/dieu44-trien-khai/reviews/dot-iu-cutter-v0.2-p0-2-ddl-authoring-gpt-review-2026-05-16.md
ddl_draft (r1):           knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-2-ddl-draft-2026-05-16.sql.md
verification_plan:        knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-2-ddl-verification-plan-2026-05-16.md
rollback_draft:           knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-2-rollback-draft-2026-05-16.md
risk_note:                knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-2-risk-review-note-2026-05-16.md
ddl_authoring_report:     knowledge/dev/laws/dieu44-trien-khai/v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-2-ddl-authoring-report-2026-05-16.md
this_dry_run_set:         knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/dot-iu-cutter-v0.2-p0-2-dry-run-*-2026-05-16.md

§5 — Open Notes Carried Forward (for GPT dry-run review)

N1: manifest_unit_block = 13 columns (executed DDL + design field spec).
    Authoring report §2/§3 + GPT DDL-authoring review §2 prose said 14 = miscount.
    Recommend documentation erratum; NO DDL change. (PASS_WITH_NOTES)
N2: run-02 harness expected-string bug (regclass schema-qualification) → 3 cosmetic
    false-negatives; corrected in run-03; DDL not re-executed. No schema impact.
N3: dry-run restored with --no-owner --no-acl (ownership differs from prod;
    immaterial to structural verification; Phase α precedent).

§6 — Status Flags

p0_2_dry_run_status: PASS_WITH_NOTES
ddl_executed_in_dry_run: true
verification: 20/20 PASS
rollback_test: PASS
production_ddl: false
production_mutation: false
production_migration: false
deploy: false
cut_or_verify: false
self_advance_to_command_review: false
agent_self_advance: PROHIBITED
next: GPT review of P0-2 dry-run package → (if PASS) explicit User prompt for a
  production command-review lane in a SEPARATE session.

End of P0-2 dry-run artefact index.