Skip to content

Database schema issue on the backend (sync_behavior column missing) preventing Space creation #143

Closed

Description

@rosalie1984

In the thread "can you create a new space called ILS Deepfield" I got the error message that there is a database schema issue on the backend (sync_behavior column missing) preventing Space creation. This isn't something I can fix from the mesh — it's an infrastructure error.

Activity

  1. added a commit that references this issue on Jul 1, 2026
  2. rbuergi commented on Oct 11, 2026

    @rbuergi
    Contributor

    (re-posted 2026-10-11; originally by @rbuergi on 2026-07-01)

    Root cause found (2026-07-01). The sync_behavior column is missing because the database migration never runs — the memex-migration container on the current image (3.0.0-ci.122 / 6943991) crashes on startup:

    Current DB version: 39
    Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly
    'MeshWeaver.Documentation, Version=3.0.0.280, Culture=neutral, PublicKeyToken=null'.
    

    So the memex-migration-deployment is in CrashLoopBackOff on client-i + memex (verified), the schema stays at v39, and the migration that adds sync_behavior (PR #119, MeshNode.SyncBehavior persistence) is never applied → Space creation fails exactly as reported.

    Note this is separate from the portal: the portals on ci.122 run fine (all 3 rolled and 1/1 Running) — only the migration image is broken. It's a packaging/assembly-version mismatch: the migration binary references MeshWeaver.Documentation v3.0.0.280 but that assembly isn't present at that version in the migration image.

    Fix required: correct the memex-migration image build so MeshWeaver.Documentation is packaged at the referenced version (CD build), then let the migration run to apply v40 (sync_behavior). Until then the schema can't advance past v39. Investigating the migration image build next.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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