AuthApiError: Database error creating new user (seeding and registration blocked)

[Benoble1]

Hi Supabase team,

I’m running into a consistent issue when trying to create users with supabase.auth.admin.createUser (both via seeding script and the registration form).

Error:

AuthApiError: Database error creating new user
status: 500
code: 'unexpected_failure'

What I’ve tried so far:
• Verified auth.users columns (id, email, etc.).
• Rebuilt the handle_new_user trigger to insert into public.user_profiles.
• Tried seeding users with valid emails/passwords.
• Confirmed the issue also happens through the registration form (Database error saving new user).

It looks like my project doesn’t have permission to adjust the auth.users defaults (e.g., setting id to gen_random_uuid()), so I suspect the table might be in a misconfigured state.

Question:
Could you please confirm if my project’s auth.users table needs to be reset or repaired on your end? If so, how should I proceed?

Thanks a lot for your help 🙏

[GaryAustin1]

This is almost always your auth triggers.
Check in the Dashboard Database/Triggers for additional auth.users triggers.
Check the Postgres logs for the exact error the database is getting.

No one on Github can fix your instance, but this is not likely auth.users table as that is protected from change.