supabase
Auth service migration error
Bug report
- [ x] I confirm this is a bug with Supabase, not with my own application.
- [x ] I confirm I have searched the Docs, GitHub Discussions, and Discord.
Describe the bug
auth service giving error:
{"level":"fatal","msg":"running db migrations: Migrator: problem creating schema migrations: could not execute CREATE TABLE \"schema_migrations\" (\n\"version\" VARCHAR (14) NOT NULL,\nPRIMARY KEY(\"version\")\n);\nCREATE UNIQUE INDEX \"schema_migrations_version_idx\" ON \"schema_migrations\" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)","time":"2025-03-07T21:29:02Z"}
I have tried adding ?search_path=auth to the end of the GOTRUE_DB_DATABASE_URL: postgres://supabase_auth_admin:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}?search_path=public in the docker-compose.yml file, as someone suggested in the discord: https://discord.com/channels/839993398554656828/993107271393497149/997011784814833775 , this didn't work. However, then when we want to pull in updates it will be out of sync with what is in the supabase repo, even if this did work. Also, we're using the default settings from the official docs where it doesn't say anything about this.
Also, the studio isn't connecting to the database either, doesn't recognize any schemas.
To Reproduce
Following docs for self hosting to run locally with docker: https://supabase.com/docs/guides/self-hosting/docker
only running these services: docker compose -f ./supabase/docker/docker-compose.yml up db rest auth studio kong supavisor --no-deps -d
Expected behavior
Supabase services to be up and running.
System information
- OS: macOS
- using OrbStack for docker
- Version of Node.js: 22.11.0
