Garry's Opinionated OpenClaw/Hermes Agent Brain
TypeScript
-- #6650: read-only census of failed fact-fence adoptions in the writer table.
--
-- Answers: how many failed adoption requests exist, which gbrain builds
-- admitted them, whether any are still being minted, and how many of their
-- pages still hold legacy (unfenced) facts. It writes nothing.
--
-- Postgres brains only (a PGLite brain has no managed writer table to census).
-- Run it with psql against the same database the brain uses: the URL is the
-- `database_url` in the brain host's gbrain config (`gbrain doctor --json`
-- names the config file; it prints the URL redacted, so read the file). From
-- a gbrain checkout:
-- psql "<database url>" -v source=default -f scripts/diagnose/fence-adoption-census.sql
-- Without a checkout, fetch the file from the gbrain repository first:
-- curl -fsSLO https://raw.githubusercontent.com/garrytan/gbrain/master/scripts/diagnose/fence-adoption-census.sql
--
-- Compacted receipts (older than the receipt retention window) keep their
-- code but lose their message and intent. A compacted `fence_unrenderable`
-- row is still counted above; a compacted legacy `invalid_params` row can no
-- longer be told apart from other invalid_params refusals, so the first two
-- tables are a lower bound and the last one counts those rows separately as
-- unattributed. The refusal sub-reason (missing / struck / empty /
-- visibility / text) was never stored on the row, so this census cannot
-- reconstruct it; re-run the facts backfill on the current build and read
-- `gbrain doctor` fence_integrity for today's reasons.
BEGIN READ ONLY;
\echo 'Failed adoptions by build, code and message'
SELECT r.admitter_version,
r.error_code,
CASE WHEN r.compacted THEN '(compacted)' ELSE r.error_message END AS message,
count(*) AS failed_requests,
count(DISTINCT r.slug) AS distinct_pages,
min(r.completed_at) AS first_seen,
max(r.completed_at) AS last_seen,
count(*) FILTER (WHERE r.completed_at > now() - interval '24 hours') AS last_24h
FROM persistence_requests r
WHERE r.source_id = :'source'
AND r.state = 'failed'
AND (r.intent->>'kind' = 'managed_maintenance_adopt_fact_fence'
OR r.error_message = 'The adopted fence row does not render its legacy fact.'
OR r.error_code = 'fence_unrenderable')
GROUP BY 1, 2, 3
ORDER BY last_seen DESC;
\echo 'Pages with failed adoptions: how many still hold legacy (unfenced) facts'
WITH failed AS (
SELECT DISTINCT r.slug
FROM persistence_requests r
WHERE r.source_id = :'source'
AND r.state = 'failed'
AND (r.intent->>'kind' = 'managed_maintenance_adopt_fact_fence'
OR r.error_message = 'The adopted fence row does not render its legacy fact.'
OR r.error_code = 'fence_unrenderable')
)
SELECT count(*) AS pages_with_failures,
count(*) FILTER (WHERE EXISTS (
SELECT 1 FROM facts f
WHERE f.source_id = :'source' AND f.entity_slug = failed.slug
AND f.row_num IS NULL AND f.expired_at IS NULL AND f.dimension IS NULL)) AS pages_still_holding_legacy_facts
FROM failed;
\echo 'Unattributed: compacted invalid_params failures (older builds wrote fence refusals with this code; not all of these are adoptions)'
SELECT r.admitter_version,
count(*) AS compacted_invalid_params,
count(DISTINCT r.slug) AS distinct_pages,
min(r.completed_at) AS first_seen,
max(r.completed_at) AS last_seen
FROM persistence_requests r
WHERE r.source_id = :'source'
AND r.state = 'failed'
AND r.compacted
AND r.error_code = 'invalid_params'
GROUP BY 1
ORDER BY last_seen DESC;
ROLLBACK;