{"spec_id":"task-deduplication","title":"Spec: Task Deduplication — Never Create Duplicate Tasks for the Same Idea+Phase","summary":"The pipeline creates far too many tasks per idea. With 799 spec tasks across 147 ideas","potential_value":0.0,"actual_value":1.0,"estimated_cost":0.0,"actual_cost":1.0,"value_gap":0.0,"cost_gap":1.0,"estimated_roi":0.0,"actual_roi":1.0,"idea_id":"pipeline-reliability","process_summary":"R1 — Create `check_idea_phase_history(idea_id, phase)` in new `api/app/services/task_dedup_service.py`.; R2 — In `local_runner.py:_seed_task_from_open_idea()`, after fetching `idea_tasks_payload`:; R3 — In `pipeline_advance_service.py:maybe_advance()`, before creating next-phase task:; R4 — In `pipeline_advance_service.py:_maybe_auto_retry()`, before creating retry task:; R5 — In `idea_to_task_bridge.py`, replace `determine_task_type()` to use live task history","pseudocode_summary":null,"implementation_summary":"api/app/services/agent_service_active_task.py (find_active_task_by_fingerprint(), find_active_task_by_session_key())","created_by_contributor_id":null,"updated_by_contributor_id":null,"created_at":"2026-04-09T03:10:09.041729Z","updated_at":"2026-04-09T03:10:09.041729Z","content_path":"specs/task-deduplication.md","content_hash":"648fd55d6f4e83f8","workspace_id":"coherence-network"}