host_probes retention: prune rows >30d (table grows ~2.5k/day unbounded, 32.5k rows, v2.sqlite bloat driver)

Sub-tickets

Questions

Activity

• wi-cli-whey created · 2026-06-05
• wi-cli-whey note · 2026-06-05
  Surfaced by nw-whey during DB triage. host_probes = 32,502 rows since 2026-05-23, ~2,500/day, no retention -> primary v2.sqlite growth driver. 14,702 rows already >7d. Proposed: hub-side periodic prune (or cron) deleting host_probes WHERE ts < now-30d. 30d keeps #606-style outage analysis viable while bounding growth. hub-llmmsgsrv-cc owns hub.mjs + schema; pick mechanism (in-hub sweeper like the roster sweeper, vs systemd timer) + exact window. Low pri - bloat is slow, rows are small.
• wi-cli-whey canceled · 2026-06-05
  malformed ref from buggy --agent HTTP add; recreating clean