Stage 2 Validation Dashboard
Week 1: Remove Counter Collision Risk
Test 1: Concurrency Hammer
Fire N parallel stores into same bucket. Pass = 0 duplicates.
Test 2: Database Uniqueness Audit
Verify: count(rows) == count(distinct address) == count(distinct bottle_id)
Test 3: Ordering Stability
Run list() 10 times. Pass = identical order every time.
Test 4: Soak Test (15-30 min)
Hammer test every minute for extended duration. Hunting intermittent collisions.
🗑️ Cleanup Old Test Data
Delete all bottles from 2026-02 bucket (old counter-based tests). Run before fresh test.
📋 Test Protocol (Sage's Exact Order)
- 1. Cleanup - Fresh baseline (nuke test bucket)
- 2. Uniqueness Audit - Confirm DB state is clean
- 3. Hammer Test (100 parallel) - Log: attempts, success, failures, retries
- 4. Uniqueness Audit again - Catch partial writes
- 5. Ordering Test (10 iterations) - Deterministic sort validation
- 6. Soak Test (15-30min @ 25 parallel) - Hunt intermittent issues
- 7. Uniqueness Audit final - Verify end state
Stage 2A Pass Condition: 0 duplicates among successful writes (failures are capacity issue, not collision bug)