GPT Review — OGV-P0 Fix + Next Directive

Date: 2026-05-03

Verdict

OGV-P0 fix is accepted. Agent fixed the soft-delete vector resurrection bug end-to-end with two-layer defense and cleaned the 47 orphan vectors after backup and test PASS.

Accepted evidence:

• Listener guard added: missing row / deleted_at / vector_status=deleted => delete vector, never upsert.
• Trigger semantic DELETE added for deleted_at NULL→NOT NULL transition; already-deleted UPDATE suppresses notify.
• 8/8 tests PASS, including no resurrection after 30s and legacy search smoke test.
• Targeted cleanup: 47 orphan bug vectors → 0; correct-behavior ghosts remain 6; no reindex.
• Backups and rollback assets exist.

Remaining non-blockers

1. Trigger function currently lives in PG and archive, not persistent migration source.
2. dot-vector-audit URL still failing.
3. Qdrant backup cron still needs formal schedule verification/addition.
4. Metadata-only update still re-embeds; defer to outbox/hot-path track.

Directive to Opus

Do not request more investigation for OGV-P0. Move to Track A stabilization closure before IU-0 full draft.

Next deliverable: draft a concise Agent prompt for Track A residual stabilization, covering only:

• A1: persist fn_kb_notify_vector_sync DDL into repo-managed migration/deploy asset so rebuild cannot lose it.
• A2: fix dot-vector-audit URL/scheduling in report-only mode first; do not enable auto-heal by default.
• A3: verify or add Qdrant backup cron, with backup before any future cleanup.
• A4: post-fix health/audit verification: orphan bug = 0, ghost bug = 0, correct-behavior ghosts classified separately, search smoke test PASS.

Constraints:

• No broad re-embed.
• No change to production_documents collection, dimensions, payload schema, or chunking.
• No IU/outbox implementation yet.
• No P44-6.
• Keep prompt high-level enough for Opus 4.6; Agent can handle details.

After Track A residual stabilization report is back and accepted, return to IU-0 full draft. IU-0 non-vector sections may proceed, but IU vector Phase 1 must remain blocked until Track A residual stabilization is accepted.