fix(service): aggregate health must exclude unconfigured adapters

[rickylabs]

Readiness-authority fix. Evidence (eis-chat#150): aggregate health includes an unused MySQL adapter in a SQLite-only app, so response status cannot be trusted and the POC fell back to listener probes. Blocks trustworthy health-gated activation everywhere: PM readiness (E14), deploy health-gated up, update confirm gates.

Acceptance:

• gate: unconfigured/unused adapters excluded from aggregate health; per-adapter-class unit tests
• gate: consumer-compile check; scaffold.runtime health-path assertion

Design source: PR #822 (rfc.md + plan.md rev 10, 9-cycle adversarial trail) in .llm/runs/rfc-single-deployment--orchestrator/.

[rickylabs]

Gate boxes checked with executed evidence (PR #847, head 13f6349 + sign-off 711ac99):

• Aggregate exclusion + per-adapter-class unit tests: health_test.ts + define-service_test.ts — database/kv/service/custom exclusion cases with zero-invocation sentinels; provider-aware selection (SQLite-only app excludes unused MySQL); readiness regression (200→503). Re-run independently by the open-model IMPL-EVAL (verdict PASS in slices/g1-826-health/evaluate.md).
• Consumer-compile + scaffold.runtime health-path assertion: type-assignability_test.ts green; upgraded users-service probe (aggregate semantics + exact adapter set, unit-tested in runtime-gates_test.ts) executed inside the green scaffold-runtime (aspire + docker + postgres) CI lane on PR fix(service): exclude unconfigured adapters from aggregate health #847.

— beta-11 supervisor (Tier-A review + Qwen IMPL-EVAL PASS recorded)