Ultimate

X_DB_SCHEMA_STALE

Means

the statement names a table or column the database does not have

Typical cause

SQLSTATE 42P01 / 42703 — an entity edited before the migration that adds its column ran, on either driver (PGlite under x dev included). The cause leads with [SQLSTATE 42703] column "host_id" does not exist and carries the statement after it, excerpted, so the column list can never push the message off the line

Fix

x db gen "<what changed>" && x db migrate — only the migrate half when the migration already exists

Listed under Entity and database

This page as markdown