https://supertokens.com/ logo
Title
e

execreate

10/11/2022, 9:40 AM
Hey guys, Our requests to the self-hosted core
supertokens-postgresql:4.1
is throwing 500 errors from time to time. The recipe is
passwordless
, URL path is
/v1/auth/signinup/code/consume
and if you dig into the supertokens-core container errors, it says:
javax.servlet.ServletException: io.supertokens.pluginInterface.exceptions.StorageQueryException: org.postgresql.util.PSQLException: ERROR: could not serialize access due to read/write dependencies among transactions
r

rp

10/11/2022, 9:43 AM
Hey! This is a known issue, but has been incredibly difficult for us to replicate. Have you been able to reliably replicate this?
e

execreate

10/11/2022, 9:44 AM
Hey @rp ! Nope, it happens once per couple of days or so
We have 3000+ daily users and a team of 3 devs, it's really hard to track what has gone wrong
r

rp

10/11/2022, 9:45 AM
right i see.
we will look into this soon
in the next 1-2 weeks
e

execreate

10/11/2022, 9:45 AM
thank you 🙂
r

rp

10/11/2022, 9:46 AM
consider opening an issue about this please, with as much info as you have - it may help us replicate it
e

execreate

10/11/2022, 9:46 AM
btw, a way to inject sentry DSN via env variable to keep track of such errors would be awesome
r

rp

10/11/2022, 9:46 AM
no such way right now. But again, please feel free to open an issue about it
I've checked another occurrences of the exception in our core, logs are the same
@rp btw, I have a device ID and pre-auth session ID of the
signinup/code/consume
request that caused this error. If you think we can use those values to query something useful from the core - just let me know 🙂
r

rp

10/11/2022, 10:16 AM
Thanks