SciDEX — Task: [Demo] CI: Validate core demo routes and fix first

Run demo route checks on port 8000, identify the first failing endpoint in the core demo flow, implement a fix, and verify all critical pages return 200/3xx. ## REOPENED TASK — CRITICAL CONTEXT This task was previously marked 'done' but the audit could not verify the work actually landed on main. The original work may have been: - Lost to an orphan branch / failed push - Only a spec-file edit (no code changes) - Already addressed by other agents in the meantime - Made obsolete by subsequent work **Before doing anything else:** 1. **Re-evaluate the task in light of CURRENT main state.** Read the spec and the relevant files on origin/main NOW. The original task may have been written against a state of the code that no longer exists. 2. **Verify the task still advances SciDEX's aims.** If the system has evolved past the need for this work (different architecture, different priorities), close the task with reason "obsolete: " instead of doing it. 3. **Check if it's already done.** Run `git log --grep=''` and read the related commits. If real work landed, complete the task with `--no-sha-check --summary 'Already done in '`. 4. **Make sure your changes don't regress recent functionality.** Many agents have been working on this codebase. Before committing, run `git log --since='24 hours ago' -- ` to see what changed in your area, and verify you don't undo any of it. 5. **Stay scoped.** Only do what this specific task asks for. Do not refactor, do not "fix" unrelated issues, do not add features that weren't requested. Scope creep at this point is regression risk. If you cannot do this task safely (because it would regress, conflict with current direction, or the requirements no longer apply), escalate via `orchestra escalate` with a clear explanation instead of committing.

Git Commits (1)

Squash merge: orchestra/task/f2165a12-validate-core-demo-routes-and-fix-first (1 commits)2026-04-16

Spec File

[Demo] CI: Validate core demo routes and fix first failing endpoint

Quest: Demo Priority: P90 Status: open

Goal

Run demo route checks on port 8000, identify the first failing endpoint in the core demo flow, implement a fix, and verify all critical pages return 200/3xx.

Acceptance Criteria

☑ Demo route check script runs successfully

☑ First failing endpoint identified (none found — all pass)

☑ Fix implemented (not needed — all routes healthy)

☑ All critical pages return 200/3xx

☑ No broken links introduced

Approach

Run demo route check script

Identify first failing endpoint

Investigate root cause

Implement fix

Verify all critical pages return 200/3xx

Commit and push changes

Work Log

2026-04-04 18:50 UTC — Slot 9

Ran smoke_check.py on http://localhost:8000
All 20 demo routes PASSED (200/302 status codes)
No failures found in core demo flow
Routes checked: /, /analyses/, /agora, /exchange, /forge, /atlas, /graph, /wiki, /senate, /agents, /notebooks, /hypotheses, /targets, /gaps, /clinical-trials, /experiments, /dashboard, /pitch, /api/health, /api/status
Result: All checks passed — no fix needed

Verification — 2026-04-16 08:27:00Z

Result: FAIL Verified by: MiniMax-M2 via task f2165a12-fb1b-4340-8fc0-12b1e143d2ca

Tests run

Target	Command	Expected	Actual	Pass?
/	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/`	200/302	302	✓
/analyses	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/analyses`	200	200	✓
/agora	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/agora`	200	500	✗
/exchange	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/exchange`	200	500	✗
/forge	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/forge`	200	200	✓
/atlas	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/atlas`	200	200	✓
/graph	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/graph`	200	200	✓
/wiki	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/wiki`	200	200	✓
/senate	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/senate`	200	200 (2nd run)	✓*
/api/health	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/api/health`	200	200	✓
/api/status	`curl -s -o /dev/null -w '%{http_code}' http://localhost:8000/api/status`	200	200	✓

Summary

18/20 routes passed, 2 FAILED:

/agora — Returns HTTP 500 (first failing endpoint in core demo flow)
/exchange — Returns HTTP 500

Note: /senate timed out on first smoke check run (10s timeout) but passed on second run (200). This suggests intermittent behavior, possibly due to slow DB query or connection pool exhaustion.

Root Cause Analysis

Investigation findings:

Worktree is 4 commits behind origin/main (rebased during this task)

Running API process (PID 1283242) started at ~08:12, but latest commits are at 08:20-08:21

The running API is using code from BEFORE the most recent modularization and global exception handler commits

Database queries in agora_page() work correctly when tested manually (verified 9 queries return expected data)

The 500 error is NOT from a database issue — all queries work in isolation

The 500 is likely caused by a runtime error in the HTML generation part of agora_page() that exists in the old code but may have been fixed in subsequent commits. The global exception handler (added in commit c5d724d1d at 08:10) would log the actual traceback, but the running API doesn't have this handler since it started before that commit.

Attribution

The current state is a deployment lag issue — the running API needs to be restarted with the latest code from origin/main to pick up recent fixes and the global exception handler that would aid further debugging.

Notes

First failing endpoint: /agora (HTTP 500)
The smoke_check.py script shows 8ms latency for /agora 500 response (immediate fail, not timeout)
Database queries tested manually all pass — issue is in Python code execution, not DB
/senate intermittently times out (first run) or passes (second run) — likely connection pool issue under load
Worktree has been rebased to latest origin/main (61d27c906)

Payload JSON

{
  "requirements": {
    "coding": 5
  },
  "_reset_note": "This task was reset after a database incident on 2026-04-17.\n\n**Context:** SciDEX migrated from SQLite to PostgreSQL after recurring DB\ncorruption. Some work done during Apr 16-17 may have been lost.\n\n**Before starting work:**\n1. Check if the task's goal is ALREADY satisfied (run the relevant checks)\n2. Check `git log --all --grep=task:YOUR_TASK_ID` for prior commits\n3. If complete, verify and mark done. If partial, continue. If not done, proceed.\n\n**DB change:** SciDEX now uses PostgreSQL. `get_db()` auto-detects via\nSCIDEX_DB_BACKEND=postgres env var.",
  "_reset_at": "2026-04-18T06:29:22.046013+00:00",
  "_reset_from_status": "done"
}