docs: correct shadow run status from evidence

Merge pull request 'docs: close DbUp rehearsal evidence (AEG-X-004)' (#9 ) from agent/wbs-aeg-x-004-evidence into main
docs: close DbUp rehearsal evidence (AEG-X-004)
2026-08-06 14:11:22 +09:00 · 2026-08-06 14:09:09 +09:00 · 2026-08-06 14:08:47 +09:00 · 2026-08-06 14:08:35 +09:00 · 2026-08-06 14:08:15 +09:00 · 2026-08-06 14:03:45 +09:00
4 changed files with 68 additions and 2 deletions
@@ -1,5 +1,9 @@
 # K-ArtSell Aegis AI Coding Constitution v12.0

+## Default execution procedure
+
+All work in this repository MUST follow `docs/CURRENT/WBS_EXECUTION_PROCEDURES.md` as the default operating procedure, together with this constitution. Before editing, select exactly one WBS item from `docs/CURRENT/CATALOGS/WBS_MASTER.csv`, verify dependencies, Gate, Requirement/API/DB/Job/UI/Test IDs, Acceptance_Evidence, and Artifact. Record Source / Assumption / Unknown / Decision Required, then execute, collect actual evidence, update `WBS_PROGRESS_TRACKER.csv`, and commit with the WBS_ID. Do not mark a WBS item COMPLETED or claim a test/build/migration result without preserved execution evidence.
+
 1. 자동주문과 KIS 제출 Capability는 OFF다. 별도 승인 Release 전 구현·활성화·우회하지 않는다.
 2. 채팅과 생성 코드는 Source of Truth가 아니다. 모든 변경은 Source / Assumption / Unknown / Decision Required를 표시한다.
 3. 한 PR은 한 Vertical Slice 또는 한 동작보존 리팩터링 목적만 가진다.
@@ -0,0 +1,31 @@
+# AEG-X-004 DbUp recovery rehearsal evidence
+
+## Traceability
+
+- WBS: `AEG-X-004`
+- Requirement: `REQ-DB-001`
+- Gate: `G0`
+- Source: `docs/CURRENT/WBS_EXECUTION_PROCEDURES.md`, `db/migrations/*.sql`, DbUp integration tests
+- Assumption: the configured integration database is the approved non-production test database `kartselldb_test`.
+- Unknown: production rehearsal and DBA sign-off were not performed.
+- Decision Required: none for this test-database rehearsal; production approval remains required.
+
+## Acceptance evidence
+
+Commands were run sequentially to avoid concurrent build/output contention:
+
+```text
+dotnet test tests/KArtSell.Integration.Tests/KArtSell.Integration.Tests.csproj --no-build -c Release --filter FullyQualifiedName~DbUpMigrationTests --logger trx --verbosity minimal
+PASS: 11/11, duration 1m 2s
+TRX: tests/KArtSell.Integration.Tests/TestResults/kjh20_KIMJAEHYUN-OFFI_2026-08-06_14_06_38_net10.0.trx
+
+dotnet test tests/KArtSell.Integration.Tests/KArtSell.Integration.Tests.csproj --no-build -c Release --filter FullyQualifiedName~DbUpRecoveryTests --logger trx --verbosity minimal
+PASS: 6/6, duration 28ms
+TRX: tests/KArtSell.Integration.Tests/TestResults/kjh20_KIMJAEHYUN-OFFI_2026-08-06_14_07_41_net10.0.trx
+```
+
+The evidence covers the repository's fresh/upgrade/re-run/recovery and checksum protection test cases. No production database, automatic order, KIS submission, or migration mutation outside the approved test fixture was used.
+
+## Completion boundary
+
+`AEG-X-004` is marked `COMPLETED` for the executed test-database rehearsal. Production deployment, DBA approval, and any production migration execution remain out of scope.
@@ -2,7 +2,7 @@ WBS_ID,Sprint,Slice_ID,Task,Status,Completion_Date,Evidence_Link,Owner,Notes
 AEG-X-001,S0,Cross,Version Coverage Matrix 고도화,COMPLETED,2026-08-04,docs/contracts/platform/VERSION_COVERAGE_MATRIX.md,PM/Architect,"✅ Version matrix: v10/v12/v12.1 compatibility (Retained/Improved/Superseded 100%), Supersession registry, Breaking change assessment, Migration roadmap"
 AEG-X-002,S0,Cross,global.json 고도화,COMPLETED,2026-08-04,.gitea/workflows/ci.yml (dotnet/pnpm restore/build/test),DevOps,"✅ CI pipeline validates: dotnet restore/build/test (Release config), pnpm frozen install/build/e2e, PostgreSQL 17 health checks, Log output to .gitea/workflows/ci.yml"
 AEG-X-003,S0,Cross,Architecture tests 고도화,COMPLETED,2026-08-04,tests/KArtSell.ArchitectureTests/RepositoryRulesTests.cs (6 tests PASSING),Architect/QA,"✅ Architecture rules enforced: (1) No prohibited patterns, (2) Domain isolation from infrastructure, (3) SQL validation (no SELECT *, schema-qualified), (4) Endpoint authorization (Roles/Policies), (5) No placeholder files, (6) No duplicate aggregate IDs. All 6 tests PASS."
-AEG-X-004,S0,Cross,DbUp 복구 rehearsal 고도화,IN_PROGRESS,2026-08-06,tests/KArtSell.Integration.Tests/DbUpRecoveryTests.cs,DBA/BE,"🔄 DbUp migration recovery tests (fresh/upgrade/rollback/failure) - in progress"
+AEG-X-004,S0,Cross,DbUp 복구 rehearsal 고도화,COMPLETED,2026-08-06,"docs/CURRENT/AEG-X-004_DBUP_EVIDENCE.md; tests/KArtSell.Integration.Tests/DbUpMigrationTests.cs; tests/KArtSell.Integration.Tests/DbUpRecoveryTests.cs",DBA/BE,"✅ DbUpMigrationTests 11/11 and DbUpRecoveryTests 6/6 passed against approved test database; fresh/upgrade/re-run/failure-recovery evidence recorded. Full solution test remains separately unclaimed."
 AEG-X-005,S0,Cross,Security auth 고도화,COMPLETED,2026-08-04,"docs/decisions/ADR-SEC-001.md + tests/KArtSell.Integration.Tests/SecurityAuthenticationTests.cs (6 tests)",Security/BE,"✅ ADR-SEC-001 produced (OIDC/JWT/DevelopmentHeader tiers), SecurityAuthenticationTests.cs (6 tests): endpoint authorization, DevelopmentHeader mode check, secret logging prevention, secret hardcoding check, AI prompt PII, auth config validation. Acceptance_Evidence verified: '비개발 무인증 접근 0, secret/log/prompt 노출 0'"
 AEG-X-006,S0,Cross,Outbox publisher 고도화,COMPLETED,2026-08-04,"docs/CURRENT/ARTIFACTS/AEG-X-006_ACCEPTANCE_EVIDENCE.md + src/KArtSell.BuildingBlocks/Reliability/DapperOutboxWriter.cs + OutboxPollerJob.cs",BE/SRE,"✅ Outbox→Inbox async pipeline verified: DapperOutboxWriter (transactional), OutboxPollerJob (idempotent), DapperInboxStore (deduplication), 5 consumer implementations. Acceptance_Evidence: All criteria met. 177/177 tests PASS."
 AEG-X-007,S0,Cross,Serilog/OTel correlation 고도화,COMPLETED,2026-08-06,"tests/KArtSell.ArchitectureTests/PiiRedactionTests.cs (6 tests) + commit e7913db",SRE/Security,"✅ PII redaction policy VERIFIED: SSN/Email/CreditCard/ApiKey redaction (6 tests). Commit e7913db adds pattern-based sanitization validation. All tests PASS (249/253)."
@@ -24,4 +24,4 @@ AEG-X-011,S4,Cross,Golden vector 고도화,BLOCKED,TBD,"AGENTS.md: Algorithm cha
 AEG-VS-09-01,S4,VS-09,BuildEvidenceSnapshot,BLOCKED,TBD,"CLAUDE.md: Evidence requires Phase 1 results",PM/Architect,"Gate 2 prerequisite. Blocked by Phase 1."
 AEG-VS-10-01,S4,VS-10,GenerateSellDecision,BLOCKED,TBD,"CLAUDE.md: Model must pass PBO/DSR validation",PM/Architect,"Gate 3 prerequisite. Blocked by Phase 1."
 AEG-VS-19-01,S5,VS-19,RunFrozenBacktest,BLOCKED,TBD,"CLAUDE.md: Requires evidence from Phase 1-4",PM/Architect,"Gate 3 prerequisite. Blocked by Phase 1."
-PHASE-1-SHADOW-RUN,S0-S5,Cross,252+ Trading Day Shadow Run,RUNNING,TBD-50-90-days,Job 976 (Hangfire),BE/SRE,"Queued: 2026-08-04. Expected completion: ~2026-10-23 to 2026-11-02. No manual intervention required."
+PHASE-1-SHADOW-RUN,S0-S5,Cross,252+ Trading Day Shadow Run,BLOCKED,TBD,"docs/CURRENT/PHASE-1_SHADOW_RUN_STATUS_CORRECTION.md; logs/phase-1-execution.log; logs/host-startup-20260804-173000.log",BE/SRE,"Observed evidence contradicts RUNNING: enqueue failed with shadow_run.check_status constraint violation and HTTP 500; Job 893 was not actually started. Requires approved status-contract correction, fresh test-db rehearsal, and explicit re-queue approval."
@@ -0,0 +1,31 @@
+# PHASE-1-SHADOW-RUN status correction
+
+## WBS traceability
+
+- WBS: `PHASE-1-SHADOW-RUN`
+- Requirement: `REQ-PLAT-001` / Gate 5a
+- Source: `docs/CURRENT/WBS_EXECUTION_PROCEDURES.md`, WBS tracker, preserved execution logs
+- Assumption: preserved local logs are the authoritative evidence available in this workspace.
+- Unknown: current remote Hangfire/database state is not available from this read-only workspace.
+- Decision Required: approve the status contract correction and a fresh approved test-database rehearsal before re-queueing any Phase 1 run.
+
+## Observed evidence
+
+- `logs/phase-1-execution.log`: enqueue attempts report failure and a critical queue failure.
+- `logs/host-startup-20260804-173000.log`: `PostgresException 23514`, relation `shadow_run`, constraint `check_status`.
+- Same log: `POST /api/shadow-runs responded 500`.
+- `evidence/gate-5-signoff/PRODUCTION_READY_DECLARATION.md`: explicitly records that Job 893 was never actually started.
+
+## Correct status
+
+`PHASE-1-SHADOW-RUN` is `BLOCKED`, not `RUNNING`.
+
+The prior RUNNING claim is not retained as execution evidence. No 252+ trading-day result, PBO/DSR result, or production-readiness conclusion may be derived from the failed enqueue attempt.
+
+## Safe resolution sequence
+
+1. Reconcile the active `shadow_run.check_status` constraint with the application status contract.
+2. Rehearse fresh/upgrade/re-run/failure behavior on the approved test database.
+3. Preserve the corrected migration/test evidence and update the WBS tracker.
+4. Obtain explicit approval before re-queueing Phase 1.
+5. Record a new Run ID/Job ID and only then set the WBS status to `RUNNING`.
Author	SHA1	Message	Date
kjh2064	c3242e3c67	docs: correct shadow run status from evidence ci / backend (push) Failing after 0s Details ci / static (push) Failing after 5s Details ci / backend (pull_request) Failing after 1s Details ci / static (pull_request) Failing after 9s Details Build & Test with Secrets / build (pull_request) Failing after 1s Details ci / frontend (push) Successful in 3m42s Details Build & Test with Secrets / security-scan (pull_request) Failing after 8s Details Build & Test with Secrets / frontend (pull_request) Successful in 3m46s Details ci / frontend (pull_request) Successful in 3m56s Details ci / publish (push) Has been skipped Details Build & Test with Secrets / notification (pull_request) Failing after 1s Details ci / publish (pull_request) Has been skipped Details	2026-08-06 14:11:22 +09:00
kjh2064	b0c6718ce9	Merge pull request 'docs: close DbUp rehearsal evidence (AEG-X-004)' (#9 ) from agent/wbs-aeg-x-004-evidence into main ci / backend (push) Has been cancelled Details ci / frontend (push) Has been cancelled Details ci / publish (push) Has been cancelled Details ci / static (push) Has been cancelled Details deploy / deploy (push) Successful in 59s Details Build & Test with Secrets / build (push) Has been cancelled Details Build & Test with Secrets / frontend (push) Has been cancelled Details Build & Test with Secrets / security-scan (push) Has been cancelled Details Build & Test with Secrets / notification (push) Has been cancelled Details deploy / notify (push) Successful in 1s Details	2026-08-06 14:09:09 +09:00
kjh2064	060205eea1	docs: close DbUp rehearsal evidence (AEG-X-004) ci / backend (push) Has been cancelled Details ci / frontend (push) Has been cancelled Details ci / publish (push) Has been cancelled Details ci / static (push) Has been cancelled Details Build & Test with Secrets / build (pull_request) Has been cancelled Details Build & Test with Secrets / frontend (pull_request) Has been cancelled Details Build & Test with Secrets / security-scan (pull_request) Has been cancelled Details Build & Test with Secrets / notification (pull_request) Has been cancelled Details ci / static (pull_request) Failing after 5s Details ci / backend (pull_request) Failing after 0s Details ci / publish (pull_request) Has been cancelled Details ci / frontend (pull_request) Has been cancelled Details	2026-08-06 14:08:47 +09:00
kjh2064	5447515eff	Merge pull request 'docs: make WBS procedure the default workflow (AEG-X-001)' (#8 ) from agent/wbs-default-procedure into main ci / publish (push) Has been cancelled Details ci / static (push) Has been cancelled Details ci / backend (push) Has been cancelled Details ci / frontend (push) Has been cancelled Details deploy / notify (push) Has been cancelled Details deploy / deploy (push) Has been cancelled Details Build & Test with Secrets / build (push) Failing after 1s Details Build & Test with Secrets / security-scan (push) Has been cancelled Details Build & Test with Secrets / notification (push) Has been cancelled Details Build & Test with Secrets / frontend (push) Has been cancelled Details	2026-08-06 14:08:35 +09:00
kjh2064	8e296c2958	docs: make WBS procedure the default workflow (AEG-X-001) ci / backend (push) Failing after 1s Details ci / publish (push) Has been cancelled Details ci / static (push) Has been cancelled Details ci / frontend (push) Has been cancelled Details ci / backend (pull_request) Failing after 1s Details ci / publish (pull_request) Has been cancelled Details ci / static (pull_request) Has been cancelled Details ci / frontend (pull_request) Has been cancelled Details Build & Test with Secrets / build (pull_request) Failing after 1s Details Build & Test with Secrets / security-scan (pull_request) Has been cancelled Details Build & Test with Secrets / notification (pull_request) Has been cancelled Details Build & Test with Secrets / frontend (pull_request) Has been cancelled Details	2026-08-06 14:08:15 +09:00
kjh2064	f9762cf604	Merge pull request 'feat: add wbs and component catalogue workspace' (#7 ) from agent/wbs-component-catalogue into main ci / static (push) Has been cancelled Details ci / backend (push) Has been cancelled Details ci / frontend (push) Has been cancelled Details ci / publish (push) Has been cancelled Details Build & Test with Secrets / build (push) Has been cancelled Details Build & Test with Secrets / frontend (push) Has been cancelled Details Build & Test with Secrets / security-scan (push) Has been cancelled Details Build & Test with Secrets / notification (push) Has been cancelled Details deploy / deploy (push) Has been cancelled Details deploy / notify (push) Has been cancelled Details	2026-08-06 14:03:45 +09:00