04 - O3 Live Read-only Probe Result

Gate

G3 - query live state for completed Constitution cut using read-only path only.

Probe execution constraints

• SQL executed inside BEGIN READ ONLY transaction.
• Statement timeout set locally.
• Transaction ended with ROLLBACK.
• No fn_iu_enact call.
• No CUT/VERIFY/enact execution.
• No INSERT/UPDATE/DELETE/DDL.

Live output

{
  "context_pins": {
    "live_doc_prefix": "ICX-CONST",
    "live_drift_class": "post_enactment_expected",
    "live_fn_iu_apply_edit_draft_md5": "42e96b6c9e81a2d0a28b30644d178a26",
    "live_fn_iu_enact_md5": "6ca9bc39e2d2be93dd8a71739fa80dc4",
    "live_governance_accessible": false,
    "live_icx_draft": 0,
    "live_icx_enacted": 60,
    "live_icx_total": 60,
    "live_lifecycle_log_review_decisions": 1,
    "live_lifecycle_log_rows": 60,
    "live_lifecycle_triggers_enabled": true,
    "live_uv_enacted": 60,
    "live_uv_enacted_at_nonnull": 60
  },
  "drift_class": "post_enactment_expected",
  "role": {
    "can_write_information_unit": false,
    "can_write_lifecycle_log": false,
    "can_write_unit_version": false,
    "database": "directus",
    "is_superuser": false,
    "transaction_read_only": true,
    "user": "context_pack_readonly"
  },
  "role_is_read_only": true,
  "survey": {
    "doc_prefix": "ICX-CONST",
    "governance_accessible": false,
    "icx_draft": 0,
    "icx_enacted": 60,
    "icx_total": 60,
    "iu_apply_edit_draft_md5": "42e96b6c9e81a2d0a28b30644d178a26",
    "iu_enact_md5": "6ca9bc39e2d2be93dd8a71739fa80dc4",
    "lifecycle_log_review_decisions": 1,
    "lifecycle_log_rows": 60,
    "lifecycle_triggers_enabled": true,
    "uv_enacted": 60,
    "uv_enacted_at_nonnull": 60
  }
}

Interpretation

• ICX-CONST total: 60.
• ICX-CONST draft: 0.
• ICX-CONST enacted: 60.
• unit_version.lifecycle_status='enacted': 60.
• unit_version.enacted_at IS NOT NULL: 60.
• iu_lifecycle_log rows: 60.
• Distinct lifecycle log review decisions: 1.
• fn_iu_enact fingerprint: 6ca9bc39e2d2be93dd8a71739fa80dc4.
• fn_iu_apply_edit_draft fingerprint: 42e96b6c9e81a2d0a28b30644d178a26.
• Lifecycle immutability triggers enabled: true.
• Drift classification: post_enactment_expected.

Result

G3 PASS. Live production state was surveyed read-only and matched expected post-enactment state.