Database error saving new user

Last edited: 1/17/2025

You generally get this error when trying to invite a new user from the dashboard or when trying to insert a user into a table using the table editor in the Supabase dashboard.

This error is normally associated with a side effect of a database transaction.

Common causes of this error:

  • You have a trigger/trigger function setup on the auth.users table
  • You have added a constraint on the auth.users table which isn't being met
  • You are using Prisma and it has broken all the permissions on the auth.users table

Debugging this error:

https://user-images.githubusercontent.com/79497/225517698-b6e3ccaf-cd70-4acd-8124-ffbcee310d63.mp4