500 error when creating anonymous user (signInAnonymously)
Hey everyone 
I’m hitting this error whenever I call supabase.auth.signInAnonymously():
AuthApiError: Database error creating anonymous user
Details:
• Anonymous sign-ins are enabled
• CAPTCHA is disabled
• Using latest @supabase/supabase-js
• /auth/v1/health returns:
{"version": "v2.180.0", "name": "GoTrue"}
→ So my project is definitely on Auth v2
• But in SQL:
select exists(select 1 from pg_catalog.pg_extension where extname = 'supabase_auth') as has_supabase_auth_extension;
returns false, and I only see 4 routines in auth (email, jwt, role, uid).
Auth log:
500: Database error saving new user
500: Database error creating anonymous user
path: /signup
Looks like GoTrue v2 is active, but my database auth schema hasn’t been upgraded (no supabase_auth extension).
Can someone from the team confirm if this means I need a manual schema sync or migration?
Has anyone else seen this after their project was auto-upgraded to GoTrue v2?
Thanks!
I’m hitting this error whenever I call supabase.auth.signInAnonymously():
AuthApiError: Database error creating anonymous user
Details:
• Anonymous sign-ins are enabled
• CAPTCHA is disabled
• Using latest @supabase/supabase-js
• /auth/v1/health returns:
{"version": "v2.180.0", "name": "GoTrue"}
→ So my project is definitely on Auth v2
• But in SQL:
select exists(select 1 from pg_catalog.pg_extension where extname = 'supabase_auth') as has_supabase_auth_extension;
returns false, and I only see 4 routines in auth (email, jwt, role, uid).
Auth log:
500: Database error saving new user
500: Database error creating anonymous user
path: /signup
Looks like GoTrue v2 is active, but my database auth schema hasn’t been upgraded (no supabase_auth extension).
Can someone from the team confirm if this means I need a manual schema sync or migration? Has anyone else seen this after their project was auto-upgraded to GoTrue v2?Thanks!
