P10A-2B Execute Report — DIEU-35 Pilot Insert + Render

Run date: 2026-04-29 Status: PASS (6/6 criteria) Publication ID: 27e48995-d6a1-4a44-8559-cab6a07fdbe0 Operator: Codex (codex-webtest) Authorization: GPT (delegated technical approval) Package SHAs: all 4 verified pre-execute (insert/render/rollback/verify)

Summary

Approved P10A-2A SQL package executed end-to-end on VPS PostgreSQL. 1 publication + 36 logical units + 36 unit versions + 36 publication members written in a single transaction. Reassembled markdown matches original source with zero substantive content drift (40-line diff = synthetic root + 2 parent placeholders + 1 absorbed blank line).

Phase 0 — Preflight (4/4 PASS)

Check	Result
PF-1 DB+role	directus / directus ✅
PF-2 Schema/triggers/collision	columns=54, triggers=6, collision_pub=0, collision_lu=0 ✅
PF-3 Backup	directus_2026-04-29_0000.sql.gz (45MB, 02:00 UTC) at /opt/incomex/backups/pg/ ✅
PF-4 SHA256 (4 files)	all match expected ✅

Pre-insert snapshot: all 4 target tables had 0 rows.

Phase 1 — Insert (PASS)

docker exec -i postgres psql -U directus -d directus \
  -v ON_ERROR_STOP=1 -X \
  < /tmp/p10a-2a-insert-candidate.sql 2>&1 | tee /tmp/p10a-2b-insert-output.log

Output: BEGIN, 3 NOTICEs (pub_id + lu_ids + uv_ids), DO, COMMIT. EXIT=0.

Pub ID 27e48995-d6a1-4a44-8559-cab6a07fdbe0 regex-validated and DB-confirmed (1 row).

Phase 2 — Post-verify (PASS)

Check	Expected	Got
pub	1	1 ✅
pm	36	36 ✅
uv	36	36 ✅
lu	36	36 ✅
publication.lifecycle_status	proposed	proposed ✅
unit_version.lifecycle_status	draft	draft ✅
Warnings beyond ID notices	none	none ✅

Note: BG-UV-03 spec'd a warning for §8.2 empty body. The §8.2 unit was created with body_len=1, no PG warning was emitted in the insert log — birth gate accepted it (likely because body is not empty by char-count, just minimal placeholder).

Phase 3 — Render + Deliverables (PASS)

Render method:

1. Raw render: psql -t -A -F'\t' produced TSV with embedded newlines (pre-converted).
2. CSV re-render via COPY ... TO STDOUT WITH CSV HEADER cleanly handled multi-line bodies → 36 records correctly parsed.
3. Python CSV reader → reassembled.md (#/##/### based on depth, title + body per unit).
4. Original fetched via Agent Data HTTP API (?full=true, 39939 bytes, 817 lines).
5. diff -u produced 40-line diff (4 hunks, all structural).

Diff summary

Hunk	Location	Cause
1	top of file	Synthetic root + S0 heading prepended (by package design)
2	line ~107	§4 parent placeholder (parent — see children dieu35.s4.*)
3	line ~302	One blank line absorbed (cosmetic)
4	line ~424	§6 parent placeholder + spacing tweak

All differences are structural artifacts of the materialized-tree design. Body bytes preserved.

Pass/Fail Matrix

#	Criterion	Result
1	Preflight 4/4	✅ PASS
2	Insert completes 0 errors	✅ PASS
3	Row counts 1+36+36+36	✅ PASS
4	Lifecycle proposed+draft only	✅ PASS
5	Reassembled readable	✅ PASS
6	6 deliverables uploaded to KB	✅ PASS

Deliverables (KB)

Folder: knowledge/dev/laws/dieu38-trien-khai/reports/p10a-2b-d35-pilot/

1. original.md — source markdown snapshot (39939 bytes / 817 lines)
2. reassembled.md — reassembled from PG render (40241 bytes / 827 lines)
3. diff-report.md — 40-line diff -u + structured analysis
4. tree-report.md — 36 units with depth/canonical_address/section_type/title/body_len
5. row-count-report.md — counts + full lu_id/uv_id inventory
6. rollback-instructions.md — resolved rollback SQL + lifecycle warning

VPS Code Hygiene (Đ41)

Persistent files on VPS:

• /tmp/p10a-2b-insert-output.log — full psql stdout from Phase 1
• /tmp/p10a-2b-render-raw.tsv, /tmp/p10a-2b-render.csv — render artifacts
• /tmp/p10a-2b-reassembled.md, /tmp/p10a-2b-original.md, /tmp/p10a-2b-diff.txt
• /tmp/p10a-2b-render-csv.sql, /tmp/p10a-2b-reassemble.py — helper scripts (ad-hoc, /tmp only)
• /tmp/p10a-2b-pre-snapshot-rowcounts.txt — pre-insert evidence

No edits made to repo files. Nothing to git-commit.

Hard Exclusions Honored

• ✅ No DDL
• ✅ No seed/role/permission/token changes
• ✅ No Nuxt/KG/vector
• ✅ Only DIEU-35 touched
• ✅ No tac_change_set / tac_change_set_member writes
• ✅ No lifecycle transition to enacted
• ✅ No rollback executed
• ✅ No existing rows modified

Stop

Per package directive: STOP. Awaiting User review of deliverables before any further action.