G6 Retry Package PF-07 v0.5 + Wrapper v0.6 — AS-BUILT ARCHIVAL
G6 RETRY PACKAGE — PF-07 v0.5 + WRAPPER v0.6 (AS-BUILT ARCHIVAL)
Status: ARCHIVAL / AS-BUILT / DRY-RUN WRAPPER Không phải production migration package. Mục đích lưu: Evidence + replay/debug reference cho G6 dry-run đã PASS (run #4, 2026-04-28) Executor: Claude Code (qua SSH
contabo) — thay Codex do hết quota Effort thực tế: xhigh Authorize chain: GPT R23 PASS (backup restored) · GPT R24 PASS w/ patches · User authorize: GO G6 verdict: PASS — 15/15 criteria, 22/22 self-check, 0 exclusion violations Action log:reports/p9-g6-execution-log-run4-2026-04-28.md
A. SCOPE
Chạy G6 migration dry-run trong schema cô lập p9_g6_dryrun trên VPS production DB instance.
Prompt OFFICIAL: P9-G6-execution-prompt.md v0.2
Errata: P9-G6-precedence-errata.md
Credential override: docker exec postgres psql -U directus -d directus (thay .env/GSM)
PF-07 v0.5 chỉ thay backup freshness check cũ. Tất cả pre-flight khác của prompt OFFICIAL v0.2 vẫn bắt buộc.
FAC/DOT readiness: cite prior KB evidence E5/E6/E7.
B. PF-07 v0.5 — BACKUP FRESHNESS CHECK
| # | Tiêu chí | PASS criteria |
|---|---|---|
| 1 | SSH contabo, hostname VPS |
VPS hostname |
| 2 | Container postgres running |
docker inspect = true |
| 3 | DB connectivity + identity | directus/directus |
| 4 | CREATE SCHEMA privilege | has_database_privilege = true |
| 5 | Schema p9_g6_dryrun absent |
Empty result (STOP if exists) |
| 6 | 8 KB canonical seed files readable | Đọc đủ qua agent-data |
| 7 | Backup freshness: mtime ≤30h, size ≥1MB, gzip valid, PG header | Known restored: directus_2026-04-28_0000.sql.gz ~44.8MB |
C. G6 EXECUTION CRITERIA
DDL 14 tables → 6 functions/triggers → Seed 61 rows → SHA-256 compute → V1–V4 → Rollback DROP CASCADE → Residue=0
D. HARD EXCLUSIONS
No public.tac_*, no Directus mutation, no labels/issues/dot_log, no CREATE EXTENSION, no G8/G11/P9, no auto-DROP, no git commit/push, no secret logging.
E. SHA-256 CONDITION
Manifest hash_status was PENDING_COMPUTE → COMPUTED after run #4.
F. ROLLBACK
Any failure after CREATE SCHEMA → DROP SCHEMA CASCADE + residue=0.
Archived 2026-04-28. G6 PASS. Not for production use — dry-run wrapper only.