Anonymous Sign in not working flutter

This is the error I keep getting:

flutter: AuthRetryableFetchException(message: {"code":"unexpected_failure","message":"Database error creating anonymous user"}, statusCode: 500)

flutter: AuthRetryableFetchException(message: {"code":"unexpected_failure","message":"Database error creating anonymous user"}, statusCode: 500)

I have turned anon sign ups on in the Auth settings in supabase dashboard, but for some reason I still get this error when using:

await_authService.signInAnonymously();

await_authService.signInAnonymously();

Please help, been trying to get it to work, but just can't