Skip to content

server-v0.0.6 migration 0000_quiet_slyde fails on stores created by v0.0.5: schema "observatory" already exists #1325

Description

@anudeepadi

Upgrading a working v0.0.5 self-hosted store to v0.0.6 crash-loops on boot:

fatal during startup: failed to apply embedded migration 0000_quiet_slyde statement 1: schema "observatory" already exists
CREATE SCHEMA "observatory";

Repro: run v0.0.5 with a working data dir → install v0.0.6 over it → start. Boot fails 100% of the time; under systemd Restart=always this becomes an infinite crash loop.

Looks like v0.0.5 already creates the observatory schema but v0.0.6's migration ledger doesn't record it, so the baseline migration re-runs. CREATE SCHEMA IF NOT EXISTS (or ledger backfill for pre-0.0.6 stores) would fix the upgrade path.

Same env as my other issue (#1324): Linux x64, Debian 12 (GCE), official install script.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions