© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3mo ago•
14 replies
Dexter

Messed up my DB

Hello, I somehow managed to mess up my auth schema or smth and now I cannot login or create users. The error i see in the console is "GET /auth/oauth?error=server_error&error_code=unexpected_failure&error_description=Database+error+saving+new+user&next=%2F 307".

The error happens when I click on the oauth sign in flow. I think I might have deleted something on accident from the auth schema.

Luckily I had no useful data in my db. Is there a way to completely reset the database to what it was before and then rerun my migrations ?

I wanted to clear all users so I run the following:
delete from auth.users;
delete from auth.identities;
delete from auth.sessions;
delete from auth.refresh_tokens;
delete from auth.users;
delete from auth.identities;
delete from auth.sessions;
delete from auth.refresh_tokens;
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

I think supabase db dump is locking up my DB
SupabaseSSupabase / help-and-questions
5mo ago
Can't connect to my remote db from my local dbeaver
SupabaseSSupabase / help-and-questions
13mo ago
Setting up a dev/test DB
SupabaseSSupabase / help-and-questions
3mo ago
MY WHOLE DB GOT EMPTIED.
SupabaseSSupabase / help-and-questions
7mo ago