search

supertokens / supertokens-core

Open source alternative to Auth0 / Firebase Auth / AWS Cognito
https://supertokens.com
Other
13.13k stars 521 forks source link

High latencies for passwordless signup API #1045

Closed kaustubhbabar5 closed 1 month ago

kaustubhbabar5 commented 1 month ago

🐛 Bug Report

Hii, we've self hosted supertokens core and we're experiencing high latencies for /recipe/signinup/code API, there was a load of approximately 100 requests per second for this api and we've seen latencies going upto 60 secs.

kaustubhbabar5 commented 1 month ago

We observed lot of deadlock and could not serialize access due to concurrent update errors for following query around the same time

DELETE FROM passwordless_devices WHERE app_id = $1 AND tenant_id = $2 AND phone_number = $3
rishabhpoddar commented 1 month ago

Hi @kaustubhbabar5 which version of the core are you using?

kaustubhbabar5 commented 1 month ago

it's supertokens-postgresql:6.0

rishabhpoddar commented 1 month ago

Right. Can you try updating the core first and seeing if the issue persist? Thanks.

rishabhpoddar commented 1 month ago

Closing this issue due to no response and we can't reproduce it.