Ultimate

X_QUERY_SUBSCRIBES_UNKNOWN

Means

a live query subscribes to a table no entity declares

Typical cause

subscribes: on a live: true query names a relation this app has no entity for — a typo, or a table that was renamed. Raised by x db gen and the drift step, the one tier holding both the manifest and the entity registry: @ultimat3/query has no table catalog and cannot see it. Since #518 x db gen grants no REPLICA IDENTITY FULL for subscribes: (a keyed table is correct on DEFAULT); the list is validated, never granted

Fix

edit subscribes: on the query the cause names to a table the app declares, or drop the name, then x db gen "retry after fixing subscribes" --json

Listed under Policy and authz

This page as markdown