[test-efficacy-2026-04-09] Vitest concurrent DB test isolation failure

[test-efficacy-2026-04-09] When running vitest with concurrent tests that share database state, tests intermittently fail because transactions from one test are visible to others. The issue manifests as unique constraint violations or missing row errors.