dot-iu-cutter v0.2 — P0-6 + P0-5 Remainder r2 Dry-Run Artefact Index

document_path: knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-r2-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-6 + P0-5-remainder r2 DRY-RUN artefact index
dry_run_status: PASS_WITH_NOTES

---

§1 — Dry-Run Artefacts (retained on VPS)

dry_run_env_name: pg-dry-run-v0.2-p0-6-p0-5-remainder-2026-05-16
  image: postgres:16 ; host_port: none ; lifecycle: ephemeral (torn down post-run)
  DR_SYSID: 7640373642989559852
work_dir: /root/p0-6-p0-5-dryrun/   (on vps 38.242.240.89)
backup_used_for_restore:
  path: /root/p0-6-p0-5-dryrun/prod-directus-20260516T063121Z.sql
  sha256: 80f9dc7f72b307f9bcb295d9c3a35fb763c81e506eb35af07a5e97c9f0d3bf81
  size_bytes: 650320592
  method: pg_dump -U workflow_admin -d directus (prod READ-ONLY)
extracted_sql_artefact:
  path: /root/p0-6-p0-5-dryrun/p0_6_p0_5_r2.sql
  sha256: 89652d5f1f22dad18b6dfeaf88dc77b3452e78a0f28cc79befa389af3025c4b0
  revision: r2  (r1 NOT used — superseded)
  source_doc: v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-ddl-draft-2026-05-16.sql.md (r2)
orchestrator_script:
  path: /root/p0-6-p0-5-dryrun/dryrun_p0_6_p0_5.sh
  sha256: 4a731ab526ce23b57e5f8b744a04cc08bc06498724491735550dc739816fc1e6
run_log:
  path: /root/p0-6-p0-5-dryrun/dryrun.log
  span: MARK START 2026-05-16 06:31:20 UTC → MARK END 06:33:28 UTC
side_logs: restore.log, ddl_exec.log, rb.log (in work_dir)

§2 — Identity / Safety Ledger

PROD_SYSID: 7611578671664259111 (start) ; 7611578671664259111 (reconfirm — unchanged)
DR_SYSID:   7640373642989559852  (≠ PROD — identity guard PASS, asserted pre-DDL)
prod_access: READ-ONLY only (pg_dump + catalog SELECT)
prod_DDL/DML/migration/deploy/CUT/VERIFY: NONE
protected_dry_run_envs (NOT touched; verified running before+after):
  - pg-dry-run-v0.2-p0-2-2026-05-16
  - pg-dry-run-v0.2-phase-alpha-2026-05-16
  - pg-dry-run-hb05-2026-05-15
ephemeral_env_cleanup: container + volume removed (DR_CLEANUP=done)

§3 — Controlling Inputs

1 reviews/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-ddl-r2-gpt-review-2026-05-16.md  (GPT r2 PASS)
2 v0.2-ddl-authoring/dot-iu-cutter-v0.2-p0-6-p0-5-remainder-ddl-draft-2026-05-16.sql.md (r2; source of artefact)
3 v0.2-ddl-authoring/…-verification-plan-2026-05-16.md (r2)
4 v0.2-ddl-authoring/…-rollback-draft-2026-05-16.md (r2)
5 v0.2-ddl-authoring/…-ddl-authoring-report-2026-05-16.md (r2)

§4 — Outputs (this dry-run)

knowledge/dev/laws/dieu44-trien-khai/v0.2-dry-run/
  dot-iu-cutter-v0.2-p0-6-p0-5-remainder-r2-dry-run-execution-report-2026-05-16.md   (primary; PASS_WITH_NOTES)
  dot-iu-cutter-v0.2-p0-6-p0-5-remainder-r2-dry-run-verification-results-2026-05-16.md (19/19 PASS)
  dot-iu-cutter-v0.2-p0-6-p0-5-remainder-r2-dry-run-artefact-index-2026-05-16.md     (this file)
prior (A-1 HALT, r1) retained for audit:
  dot-iu-cutter-v0.2-p0-6-p0-5-remainder-dry-run-*-2026-05-16.md (3 docs, FAIL_HALTED)

§5 — Disposition

dry_run_status: PASS_WITH_NOTES
a1_gate: PASS (entry_id uuid)
ddl_result: SUCCESS (4 tables, 7 FK, cg 8→12)
rollback_test: PASS (cg → 8)
production_untouched: TRUE
production_migration_allowed: FALSE
notes: N-1 benign restore role error (zero impact); N-2 ephemeral env
next_step: GPT review of this dry-run package → (if PASS) production
  command-review authoring lane (separate, explicitly prompted).
  Agent self-advance PROHIBITED.
output_form: p0_6_p0_5_remainder_r2_dry_run_artefact_index

End of r2 dry-run artefact index.