Review remediation: Lane G2 — MQTT + Sql #744

Open
opened 2026-10-22 06:05:20 -04:00 by dohertj2 · 0 comments
Owner

From the 2026-10-21 Fable system review. Findings R0x:ID refer to docs/reviews/2026-10-21/0x-*.md (location, evidence, failure scenario, fix recipe). Plan: docs/superpowers/plans/2026-10-22-review-remediation.md.

Lane G2 — MQTT + Sql

MQTT:

  • Failed SUBSCRIBE ⇒ pending set retried on reconnect/reconcile, SubscribeAsync throws on a transport failure (R06:M-1).
  • Wire birthObservationWindowSeconds into MqttDriverBrowser.OpenBudget + discovery UntilStable (M-4).
  • Array leaves not bindable, plus a Sparkplug-array-read feature issue (M-5).
  • Prune LastValueCache on Register (M-2).
  • Dispose the failed connection (M-3).
  • Wildcard topic trie (M-6); static UTF-8 encoder (M-7).
  • Bounded concurrent publishes (M-8); guards (M-10, M-11).

Sql:

  • Row cap with a TOP/LIMIT N+1 dialect + config-error status (S-1).
  • Rate-limited warnings (S-6); plan cache (S-7).
  • Dispose _gate (S-3).
  • Query model refused at the deploy gate via the parser + feature issues for MySql/Odbc/allowWrites (S-4).
  • IS_NULLABLE in browse attributes (S-5).
  • Withhold JSON parser text (S-8); IBatchSubscribable.

Driver lane gates:

  • Wave 4 fixture runs on 10.100.0.35: modbus standard, s7 s7_1500, abcip controllogix, opcuaclient opc-plc, mqtt + sparkplug, sql. Each lane adds or extends an IntegrationTests case per High finding.
  • Hardware userGates for real controllers: AbCip/AbLegacy/TwinCAT array writes, FOCAS macro > 32767, AbCip probe-typo recovery.
From the 2026-10-21 Fable system review. Findings `R0x:ID` refer to `docs/reviews/2026-10-21/0x-*.md` (location, evidence, failure scenario, fix recipe). Plan: `docs/superpowers/plans/2026-10-22-review-remediation.md`. ### Lane G2 — MQTT + Sql **MQTT:** - Failed SUBSCRIBE ⇒ pending set retried on reconnect/reconcile, `SubscribeAsync` throws on a transport failure (`R06:M-1`). - **Wire `birthObservationWindowSeconds`** into `MqttDriverBrowser.OpenBudget` + discovery UntilStable (`M-4`). - Array leaves not bindable, plus a Sparkplug-array-read feature issue (`M-5`). - Prune `LastValueCache` on Register (`M-2`). - Dispose the failed connection (`M-3`). - Wildcard topic trie (`M-6`); static UTF-8 encoder (`M-7`). - Bounded concurrent publishes (`M-8`); guards (`M-10`, `M-11`). **Sql:** - Row cap with a `TOP/LIMIT N+1` dialect + config-error status (`S-1`). - Rate-limited warnings (`S-6`); plan cache (`S-7`). - Dispose `_gate` (`S-3`). - `Query` model refused at the deploy gate via the parser + feature issues for MySql/Odbc/allowWrites (`S-4`). - `IS_NULLABLE` in browse attributes (`S-5`). - Withhold JSON parser text (`S-8`); `IBatchSubscribable`. **Driver lane gates:** - Wave 4 fixture runs on `10.100.0.35`: modbus `standard`, s7 `s7_1500`, abcip `controllogix`, opcuaclient opc-plc, mqtt + sparkplug, sql. Each lane adds or extends an IntegrationTests case per High finding. - Hardware userGates for real controllers: AbCip/AbLegacy/TwinCAT array writes, FOCAS macro > 32767, AbCip probe-typo recovery.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: dohertj2/lmxopcua#744