SupabaseS
Supabase•3y ago
Reddy

npx supabase start is failing w/ already exists errors

I started seeing below error since yesterday and I have been noodling to fix it.

null value in column \"provider_id\" of relation \"identities\" violates not-null constraint

Tried several solutions like removing supabase/.temp, checking my seed.sql for auth."identities" references etc. But that didn't work.

Upgraded my CLI to latest cli (Tried both npx and brew versions). And now I am seeing below error whenever I run npx supabase start

ERROR: type "invitation_status" already exists (SQLSTATE 42710)    
At statement 18: CREATE TYPE "public"."invitation_status" AS ENUM (
    'accepted',
    'pending',
    'rejected'
)


The above SQL statement is from my first migration sql file under migrations folder. First started seeing above error when I run npx supabase db reset but now it's happening on start itself.

Any help please? I have been trying different solutions since yesterday w/o any luck. Also tried uninstalled and reinstalled Docker.
Was this page helpful?