Hi everyone.
My team and I are experiencing some corner-case issues when using prisma "transactions" with postgres database. Basically we have unrecoverable "idle in transaction" sessions which make all our subsequent DB queries timeout.
I've opened an issue about it here:
https://github.com/prisma/prisma/issues/9584 and I'm working on a MRE.
However, I do wonder, does anyone in the community already had experienced this kind of issue under high load / lock intensive queries / low ressources environment ? And does anyone have found a suitable solution for it ? (for me the only mitigation I found ATM is to refactor my code to avoid transaction (I loose the rollback ability and the database integrity but it doesn't hang forever))