Troubleshooting

Common symptoms and the underlying cause:

SymptomCause / fix
OpResult::UnavailableNot the primary, or the engine is shedding load. Use ClusterClient (auto-rotates) or retry.
OpResult::UnauthorizedMissing/incorrect token. Use connect_authed / with_token with ServerConfig.token.
OpResult::Constraint(msg)A NOT NULL / UNIQUE / FK / CHECK rejected the write. This is a deterministic committed result.
OpResult::SchemaError(msg)Bad SQL, unknown table/column, malformed frame. The message names the problem.
server closed the connection unexpectedly from psqlNot built with --features pg-gateway, or KESSELDB_PG_ADDR / KESSELDB_TOKEN unset.
FATAL: invalid_authorization_specificationBearer token mismatch on the SCRAM path.
FATAL: sorry, too many clients already (53300)pg_max_conns hit (default 256). Raise via ServerConfig.pg_max_conns.

Full table including the HTTP gateway error map and the Parquet typed-Unsupported messages: Usage guide (full) §13 and §9 Troubleshooting.