Sports live-monitor — session log (2026-04-04)

Cursor agent cursor-sports-live-monitor: DB auth, odds rotation, value analyzer, Redis tooling, stale pending void fix.

Bug: picks pending for months

Cause: Void path in sports_bets.php?action=settle referenced $stalePred without defining it (broken UPDATE). Also predicate used only commence_time; game_date is a safer fallback. Defaults were tight (3d) vs multi-month backlog.

Fix: Define sports_bets_stale_pending_predicate_sql() (commence_time OR game_date stale). Settle default stale_days=14, cap 730. Dashboard adds pending_stale_14d_count, stake, oldest_stale_pending_commence, hint. Workflow settle uses stale_days=21.

Backlog drain (one-time): …/sports_bets.php?action=settle&key=livetrader2026&stale_days=90

Files touched (this workstream)

live-monitor/api/db_config.php — sports DB user (deployed earlier; not in this snippet commit necessarily)
live-monitor/api/sports_db.php — connect error logging
live-monitor/api/sports_odds.php — budget_safe alternates NBA/NCAAB/NHL vs NFL/MLB/MLS
live-monitor/api/sports_value_analyze_lib.php — populate lm_sports_value_bets; Betfair/outlier filter; fliff/betanysports deny; min_ev floor 3
live-monitor/api/sports_picks.php — analyze action; default min_ev=3
live-monitor/api/sports_bets.php — dashboard stale pending metrics; settle void predicate + defaults
live-monitor/api/sports_metrics_lib.php, sports-betting.html — performance-by-sport / pending columns (earlier in session)
tools/deploy_to_ftp.py — --live-monitor-only
tools/redis_sports_bus_pulse.py — 15m bus status + broadcast
.github/workflows/sports-betting-refresh.yml — analyze timeout/min_ev; settle stale_days=21
.github/workflows/torontoevent-deploy-live-monitor.yml — 50webs block (if edited in branch)

Redis bus — next steps for agents

Listen on bus:broadcast:log; status agent:cursor-sports-live-monitor:status. Ask for inbox replies on HF-perf / scoring segmentation threads. Some log entries may be non-UTF8 — use binary-safe Redis client if parsing fails.