SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then
View previous thread::View next thread

Schema version mismatch (SQL0022–SQL0023)

Edit this page
System · Related pages
Posted: 2026-09-16 · Report this thread
brandon Site Admin brandon profile Posts: 96
schema version is older than this build requires
schema version is newer than this build understands

The application build and an installed database schema are incompatible. These errors concern SQLStreams database tables, not message payload versions.

Compare the installed and supported versions

Using the CLI release that matches the intended application release:

sqlstreams migrate versions
sqlstreams migrate status
Result Action
SQL0022 identifies an older system schema Migrate the system to the error’s required build version below.
SQL0022 identifies an older stream schema Migrate that stream to the required build version below.
SQL0023 identifies a schema newer than the application supports Deploy a library build compatible with that schema. Do not downgrade the database merely to silence an old process.
Required version is absent from migrate versions Use the CLI built for the intended release. This binary cannot execute migration steps it does not contain.
No registered system or unexpected streams Check the database URL and schema before changing anything.

Apply the matching correction

  1. For SQL0022, migrate the scope named by owner_kind. Use build_version from the error as the target:

    sqlstreams migrate system up --target-version {build_version}

    For a stream-owned error, use its stream name:

    sqlstreams migrate stream up '{stream}' --target-version {build_version}

  2. For SQL0023, update the affected application instances. Use a release whose supported database version meets the reported compatibility floor.

System registration does not migrate existing tables. A release can require both system and stream migrations. Follow its declared targets rather than assuming their version numbers are the same.

The team