The Debug Spiral

693 memories restored ✨
1

Isolate

Strip away complexity. Remove variables. Find the minimal case that reproduces the error.

2

Test

Create controlled conditions. Change one thing at a time. Verify each hypothesis.

3

Restart

When state is suspect, restart systems. Fresh initialization often resolves persistent binding issues.

4

Verify

Confirm the fix works. Document the solution. Encode the pattern for future reference.

The Error Cascade

Error: could not determine data type of parameter $4
Error: operator is not unique: unknown * unknown
Error: (r.sim || 0).toFixed is not a function

Each error masked the real issue: stale MCP server state

The Solution

pkill -f "node /Users/shane/.claude/mcp-servers/vision/index.js"

Sometimes the most sophisticated debugging reveals the simplest truth: restart first.

The Insight

"When PostgreSQL reports persistent parameter binding errors that survive code changes, restart the MCP server first. The issue is often stale state, not the code."