Skip to content

Super-Sync doesn't setup DB #1

@ujaehrig

Description

@ujaehrig

I've followed the README.md. But when starting the docker container and looking into the log, I see the following error:

supersync_db        | 2026-06-12 14:55:28.654 UTC [75] ERROR:  relation "public.user_sync_state" does not exist at character 140
supersync_db        | 2026-06-12 14:55:28.654 UTC [75] STATEMENT:  SELECT "public"."user_sync_state"."user_id", "public"."user_sync_state"."last_snapshot_seq", "public"."user_sync_state"."snapshot_at" FROM "public"."user_sync_state" WHERE ("public"."user_sync_state"."last_snapshot_seq" IS NOT NULL AND "public"."user_sync_state"."snapshot_at" IS NOT NULL) ORDER BY "public"."user_sync_state"."snapshot_at" ASC OFFSET $1

Setup of the database shows the following log:

supersync_db  | CREATE DATABASE
supersync_db  | 
supersync_db  | 
supersync_db  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
supersync_db  | 
supersync_db  | waiting for server to shut down....2026-06-12 14:55:13.680 UTC [41] LOG:  received fast shutdown request
supersync_db  | 2026-06-12 14:55:13.683 UTC [41] LOG:  aborting any active transactions
supersync_db  | 2026-06-12 14:55:13.691 UTC [41] LOG:  background worker "logical replication launcher" (PID 47) exited with exit code 1
supersync_db  | 2026-06-12 14:55:13.692 UTC [42] LOG:  shutting down
supersync_db  | 2026-06-12 14:55:13.694 UTC [42] LOG:  checkpoint starting: shutdown immediate
supersync_db  | 2026-06-12 14:55:13.771 UTC [42] LOG:  checkpoint complete: wrote 921 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.064 s, sync=0.008 s, total=0.080 s; sync files=301, longest=0.004 s, average=0.001 s; distance=4238 kB, estimate=4238 kB
supersync_db  | 2026-06-12 14:55:13.778 UTC [41] LOG:  database system is shut down
supersync_db  |  done
supersync_db  | server stopped
supersync_db  | 
supersync_db  | PostgreSQL init process complete; ready for start up.
supersync_db  | 
supersync_db  | 2026-06-12 14:55:13.804 UTC [1] LOG:  starting PostgreSQL 15.18 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 15.2.0) 15.2.0, 64-bit

I can reach the website, but neither registration fails.

Where is my mistake?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions